Pages

▼

Saturday, December 18, 2010

How to Disable(end date) large number of Users in Oracle Apps

How to end date large number of Users - fnd_users in Oracle Apps

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

5 comments:

  1. aviMay 6, 2015 at 1:38 AM

    This comment has been removed by the author.

    ReplyDelete
  2. aviMay 6, 2015 at 1:40 AM

    This comment has been removed by the author.

    ReplyDelete
  3. aviMay 6, 2015 at 1:41 AM

    This comment has been removed by the author.

    ReplyDelete
  4. Kevin DellingerMarch 7, 2019 at 1:45 AM

    Hi 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
  5. Darren DemersMay 4, 2026 at 4:06 AM

    The article highlights a practical and often overlooked data modeling technique—using a “far future” placeholder date (such as 31-Dec-9999) to represent an open-ended or unknown end date—which is a smart workaround to avoid NULL handling issues and improve query performance. This aligns with established temporal database practices where such values semantically indicate “valid until further notice,” enabling consistent comparisons and simplifying logic in large datasets . Overall, the approach reflects a balance between theoretical correctness and real-world system efficiency, making it especially valuable in enterprise-scale data warehousing and time-variant record management.
    non emergency police singapore
    dubai luxury vacations
    household company

    ReplyDelete