Concurrent Request Assignment Responsibility

This is a very handy System Administrator report that shows you all responsibilities that have access to a report through their request group.

Creating reports in Excel-Out directly in System Administrator responsibility  is so quick that it may be more convenient to store your frequently running queries as Excel-Out reports rather than queries on your local or shared drives.

This report has one parameter, the name of the concurrent program. Use the '150 Character Optional' standard value set or create your own value set that contains list of all concurrent programs. You can create that by copying the 'Concurrent Program Name' standard value set and removing the WHERE condition.

select resp.responsibility_name,
pr.user_concurrent_program_name,
ex.executable_name,
ex.application_name
from FND_EXECUTABLES_FORM_V ex,
FND_CONCURRENT_PROGRAMS_VL pr,
FND_REQUEST_GROUP_UNITS rgu,
FND_REQUEST_GROUPS rg,
FND_RESPONSIBILITY_VL resp
where 1=1
and pr.executable_id=ex.executable_id
and rgu.request_group_id=rg.request_group_id
and rgu.request_unit_id=pr.concurrent_program_id
and resp.request_group_id=rg.request_group_id
and pr.user_concurrent_program_name =p_parameter01