Enable/disable users in fnd_user table (FND_USER_package)

To Enable /disable application users in fnd_user table using fnd_user_package.

To enable or diable single user in fnd_user table.

BEGIN
fnd_user_pkg.enableuser(username=>'lc_user_name') ;

END;

To enable or disable multiple users in fnd_user tables(remove or add end_date)

 

BEGIN
FOR i in (select * from fnd_user where user_name in ('user1','user2','user3'))
loop
fnd_user_pkg.enableuser(username=> i.user_name );
END LOOP;
COMMIT;
END;