Find the Responsibility name from which a concurrent program can be run


select distinct
 
a.application_id,
 
a.concurrent_program_id,
 
a.user_concurrent_program_name,
 
a.description,
 
b.request_group_id,
 
request_group_name,
 
e.responsibility_name
 
from fnd_concurrent_programs_tl a,
 
fnd_request_groups b,
 
fnd_request_group_units c,
 
fnd_responsibility d,
 
fnd_responsibility_tl e
 
where a.concurrent_program_id = c.request_unit_id
 
and b.request_group_id = c.request_group_id
 
and b.request_group_id = d.request_group_id
 
and d.responsibility_id = e.responsibility_id
 
and a.application_id = b.application_id
 
and b.application_id = c.application_id
 
and d.application_id = e.application_id
 
-- and a.user_concurrent_program_name like 'XX%'
 
and a.concurrent_program_id = 45220
 
 
 
 
 

No comments:

ORA-06512: at "SYS.DBMS_ISCHED"

Database -  Oracle Database 23AI Cause:   An attempt was made to perform a scheduler operation without the required privileges. Action:  Ask...