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);
Latest posts by Brijesh Gogia (see all)
- Oracle Database Service for Azure (ODSA) 3 – Database Services - May 1, 2023
- Oracle Database Service for Azure (ODSA) 2 – Interconnect Details - April 30, 2023
- Oracle Database Service for Azure (ODSA) 1 – Fundamentals - April 29, 2023