Creativz Lab

Oracle ERP system has n number of seeded concurrent programs and while implementation custom concurrent programs may come.

To find out various concurrent programs associated with certain responsibility, following query will be useful.

select user_concurrent_program_name  from fnd_concurrent_programs_tl
where concurrent_program_id in (
select request_unit_id from fnd_request_group_units
where request_group_id in (
select request_group_id from fnd_request_groups where request_group_id in (
select request_group_id from fnd_responsibility where responsibility_key like ‘%ORACLE_INVENTORY%’)
));