Thursday, May 5, 2011

How to end date large number of fnd_users in Oracle Apps

Below is the syntax, which can used to Huge number of Users in one GO !!

------------------------------------------------------------------------

 

declare cursor cur1 is

select user_name from apps.fnd_user where LOWER(user_name) Not IN ('username','username', .......);

begin

for all_user in cur1 loop

apps.fnd_user_pkg.EnableUser(all_user.user_name);

commit;

end loop;

End

No comments:

Post a Comment