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)
- 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