How to list all responsibilities for a user

below is the script to list all responsibilities related to specific user: 

SELECT   fr.responsibility_name
FROM apps.fnd_responsibility_tl fr,
apps.fnd_user_resp_groups_direct fur,
apps.fnd_user fu
WHERE 1 = 1
AND fu.user_name LIKE UPPER ('&username')
AND fur.user_id = fu.user_id
AND fr.responsibility_id = fur.responsibility_id
ORDER BY fr.responsibility_name;

Tag:, ,

Admin bar avatar
Sameh Bakkar
Sameh Bakkar has over 15 years Oracle Applications implementation experience (EBS/Fusion) and he is an Oracle authorized trainer. He has in-depth technical and Functional knowledge of Oracle Applications and Oracle HCM Cloud. Sameh has excellent experience in Team management, Man Power and resource planning, and Pre-Sales management Process. Additionally he has also given Best Practices seminars on Oracle e-business suite and Oracle Fusion.

You may also like

Leave A Reply

Your email address will not be published. Required fields are marked *