RSS

R12 disable all users script

15 Jun

regulatory after clone, you asked to close “disable/ end date/ deactivate” application “end” users

use the following script

declare cursor x is
select user_name from apps.fnd_user where LOWER(user_name) Not IN ('list some users you don't want to close');
begin
for all_user in x loop
apps.fnd_user_pkg.DisableUser(all_user.user_name);
commit;
end loop;
End;
 

Tags: ,

Leave a Reply