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