Script to find all active responsibilities linked to an EBS user.
SELECT UNIQUE fu.user_id, fu.user_name user_name, fr.responsibility_key responsibility, fa.application_name application FROM fnd_user fu, fnd_user_resp_groups fg, fnd_application_tl fa, fnd_responsibility fr WHERE fg.user_id(+) = fu.user_id AND fg.responsibility_application_id = fa.application_id AND fa.application_id = fr.application_id AND fg.responsibility_id = fr.responsibility_id AND fu.user_name like upper('%USER_NAME%') AND fg.end_date is Null ORDER BY fu.user_id, fa.application_name, fr.responsibility_key;
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