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-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...