Creativz Lab

To know request group name, to which a concurrent program is associated and also executable name of the concurrent program, following query will be useful. For seeded concurrent programs it is known to everybody, but for custom concurrent programs it will be very difficult to memorize.

select
fg.request_group_name,e.executable_name,responsibility_key,user_concurrent_program_name
from fnd_responsibility r,
fnd_concurrent_programs_tl p,
fnd_request_group_units u,
fnd_request_groups fg,
fnd_executables e,
fnd_concurrent_programs fcp
where r.request_group_id=u.request_group_id
and u.request_group_id = fg.request_group_id
and u.request_unit_id = p.concurrent_program_id
and fcp.executable_id = e.executable_id
and user_concurrent_program_name like ‘%Period close value summary%’
and fcp.concurrent_program_id = p.concurrent_program_id