Wednesday, 20 December 2023

Query For Oracle Application EBS R12 Naming User List


select * from fnd_user c where c.end_date is null 

and c.user_name not in ('APPSMGR','AME_INVALID_APPROVER','ASGADM','ASGUEST','GUEST','IEXADMIN','INDUSTRY DATA','IRC_EMP_GUEST','IRC_EXT_GUEST','MOBADM','MOBDEV','MOBILEADM','OP_CUST_CARE_ADMIN','OP_SYSADMIN','ORACLE12.0.0',

'ORACLE12.1.0','ORACLE12.2.0','ORACLE12.3.0','ORACLE12.4.0','ORACLE12.5.0','ORACLE12.6.0','ORACLE12.7.0','ORACLE12.8.0','ORACLE12.9.0','PORTAL30',

'PORTAL30_SSO','XML_USER','WIZARD','AUTOINSTALL');

No comments:

Post a Comment