To Disable/Enable bulk number of users in oracle Applications, we have a API
apps.fnd_user_pkg.EnableUser =>To Enable Users
apps.fnd_user_pkg.DisableUser =>To Disable Users,
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
This comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteHi there Dear, are you genuine visiting this web site regularly, if so after that you will absolutely take nice knowledge. Learn More: How To Password Protect Folder The Spartan Way.
ReplyDelete