Script to find responsibilities that can run specific concurrent program in Oracle EBS

Find responsibilities that can run the specific concurrent program

SELECT
fcp.concurrent_program_name,
fr.responsibility_name,
frg.request_group_name,
fcp.user_concurrent_program_name
FROM
fnd_request_group_units frgup,
fnd_concurrent_programs_vl fcp,
fnd_request_groups frg,
fnd_responsibility_vl fr
WHERE
1 = 1
AND fr.request_group_id = frg.request_group_id
AND frg.request_group_id = frgup.request_group_id
AND frgup.request_unit_type = 'P'
AND frgup.request_unit_id = fcp.concurrent_program_id
AND fcp.user_concurrent_program_name LIKE '%&concurrent_program_name%';

Author
Recent Posts

Brijesh Gogia

I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).

Script to find responsibilities that can run specific concurrent program in Oracle EBS

Related posts: