Concurrent Requests and Programs Related Scripts

This page will include the scripts
1. Find the responsibility name from which a concurrent program can be run
2. Find the responsibility name from which user has ran the concurrent program

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

Find from which responsibility user has ran the concurrent program

select distinct

user_concurrent_program_name,

responsibility_name,

user_name,

request_date,

argument_text,

request_id,

requested_by,

phase_code,

status_code,

a.concurrent_program_id,

a.responsibility_id,

logfile_name,

outfile_name

from fnd_concurrent_requests a,

fnd_concurrent_programs_tl b,

fnd_responsibility_tl c,

fnd_user d

where a.CONCURRENT_PROGRAM_ID = b.concurrent_program_id

and a.responsibility_id = c.responsibility_id

and a.requested_by = d.user_id

and user_name like 'PRUDHVI'