Monday, 19 July 2021

Oracle EBS - Query to get responsibility for each OU

Query mostly required when we have to run program from backend for each responsibility


SELECT fpo.profile_option_name

     , frt.responsibility_name resp_name

     , frt.application_id resp_appl_id

     , frt.responsibility_id resp_id

     , fp.profile_option_value org_id

     , fu.user_id

  FROM FND_PROFILE_OPTION_VALUES fp

     , fnd_responsibility_tl frt

     , fnd_profile_options fpo

     , fnd_user fu

 WHERE fp.level_id = 10003 

   AND fp.level_value = frt.responsibility_id

   AND fp.profile_option_id = fpo.profile_option_id

   AND fpo.profile_option_name = 'ORG_ID'

   AND fu.user_name = 'SYSADMIN'

   AND frt.responsibility_name like '%Superuser%'

ORDER BY  fp.profile_option_value,frt.responsibility_name;  

No comments:

Post a Comment