Teleservice - EBS (MOSC)

MOSC Banner

End dating users in bulk.

edited Apr 21, 2014 12:00PM in Teleservice - EBS (MOSC) 1 commentAnswered

Hi,

I have to end date bulk user accounts (1000+) from fnd_user table and I have got the following code

DECLARE
   CURSOR usercur
   IS
      SELECT fu.user_name
        FROM apps.fnd_user fu
       WHERE user_name = 'TESTACCOUNT';
BEGIN

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

END;

COMMIT;

that works for a single user with a user_name.

Please suggest what modifications do I need to make to that the code so that it runs recursively and end dates every user at one go.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Teleservice Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center