Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

fnd_user_pkg.updateuser - Remove End Date from Users

user16854Dec 3 2010 — edited Dec 3 2010
As part of an upgrade, we need to end-date the vast majority of our users.

I've used the fnd_user_pkg.updateuser API to populate the end_date on the fnd_user table.

However, when I've come to test removing the end-date, I can't seem to do it. In the example below, the end_date remains populated.
DECLARE
   CURSOR usercur
   IS
      SELECT fu.user_name
        FROM apps.fnd_user fu
       WHERE user_name = 'TEST_ACCOUNT';
BEGIN

   FOR myuser IN usercur
   LOOP
      fnd_user_pkg.updateuser(
         x_user_name      => myuser.user_name
       , x_owner          => 'CUST'
       , x_end_date       => NULL
      );
   END LOOP;

END;
On the example on this post:
http://apps2fusion.com/forums/viewtopic.php?f=99&t=108

They removed the end-date via:

x_end_date => SYSDATE + 10000);

However, that's not really removing the end date, it's just setting it to a long time in the future.

I wondered if I might be missing something obvious?

Any advice much appreciated.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 31 2010
Added on Dec 3 2010
3 comments
5,844 views