Query to extract seeded/custom reports from Oracle EBS

Question

What is the query to extract seeded/custom reports (concurrent requests - long name of the program) from Oracle EBS containing also the last run time of that request and the responsibility (from which program is run)?

Thank you for the help!

Answer 1

You can use the FND Concurrent Requests Summary blitz report. If you need the details, these are in the FND Concurrent Requests query.

Answer 2

The table fnd_conc_prog_onsite_info contains summary information about concurrent requests. Unfortunately, this table does not capture the responsibility used to run the most recent request. One must look in the fnd_concurrent_requests table for the responsibility. However, it is possible that the concurrent request data has been purged. It will not be possible to determine the responsibility for purged requests unless one has some coding/auditing to capture the responsibility for those requests.

SELECT fcp.user_concurrent_program_name
      ,fcpoi.last_run_date
      ,fr.responsibility_name
FROM   fnd_conc_prog_onsite_info fcpoi
       JOIN fnd_concurrent_programs_tl fcp
         ON (fcp.application_id = fcpoi.program_application_id
             AND fcp.concurrent_program_id = fcpoi.concurrent_program_id)
       JOIN fnd_application fa
         ON (fcp.application_id = fa.application_id)
       LEFT JOIN fnd_concurrent_requests fcr
         ON (fcr.request_id = fcpoi.last_run_request_id)
       LEFT JOIN fnd_responsibility_vl fr
         ON (fcr.responsibility_application_id = fr.application_id
             AND fcr.responsibility_id = fr.responsibility_id)
WHERE  fcpoi.last_run_date IS NOT NULL
AND    fa.application_short_name NOT LIKE 'XX%' -- exclude programs under custom applications