To list all users having specific responsibilities in Oracle EBS. For example below we are finding “System Administrator” responsibiltiy.
NOTE: IT WILL LIST ALL THOSE USERS WHO ARE NOT END DATED AS WELL AS RESPONSIBILITY IS ALSO NOT END DATED)
set lines 2000 set pages 5000 col USER_NAME for a45 Select b.user_name,b.EMAIL_ADDRESS,B.DESCRIPTION, c.responsibility_name, a.START_DATE, a.END_DATE RES_END_DATE, B.END_dATE USER_END_dATE from fnd_user_resp_groups_direct a, fnd_user b, fnd_responsibility_tl c where a.user_id = b.user_id and a.responsibility_id = c.responsibility_id and c.responsibility_name='System Administrator' AND (A.END_DATE IS NULL AND B.END_DATE IS NULL);
I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
Latest posts by Brijesh Gogia (see all)
- Building a Scalable and Secure AI Infrastructure in the Cloud - May 12, 2024
- Harnessing the Power of AI in the Cloud for Business Transformation - March 2, 2024
- Building a Resilient Cybersecurity Framework in the Oracle Cloud - January 16, 2024