How to find a report

Quite often business users ask me on how to get some specific data from Oracle. Before I start sketching any functional design for a new report, I check the list of all concurrent requests in Oracle to see if there isn't already one available. When I do find it, it is difficult to determine the responsibility where it is assigned to. To work around this inconvenience I prepare the below query that lists all the reports containing a specific string in the name, their responsibilities and application. Quite often this makes life a bit easier.

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 like '%Invoice Audit%'

This will not work if the report is assigned to a menu function, rather than the responsibility.