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 and AI Architect with over 19 years in Oracle Applications, Databases, and Cloud ecosystems. My work spans large-scale, global projects where I’ve designed and optimized solutions across both Oracle and non-Oracle stacks—on-prem and in the cloud. Lately, my focus has shifted toward integrating AI into enterprise architectures, leveraging GenAI, automation, and data intelligence to drive performance, resilience, and modernization. I’m passionate about exploring emerging AI tools, agentic workflows, and practical use cases—and I'm fortunate that my role gives me space to experiment and share my learnings.

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

Related posts: