Skip to content

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%';
Brijesh Gogia
Leave a Reply