Query to check concurrent request status from backend

Query to check concurrent request status from backend

In this post , we will be discuss about query to check concurrent request status from backend. This sql query will help to extract the concurrent request status details from backend. We will also get some other important informations about concurrent request using this sql query. This is one of the important sql query to check concurrent request status from backend.

Important Table used by Query to check concurrent request status from backend

1.fnd_concurrent_programs_vl
2.fnd_concurrent_requests
3.fnd_lookup_values

SQL Query to check concurrent request status from backend

SELECT DISTINCT fcp.user_concurrent_program_name,
                fcp.concurrent_program_name,
                fcr.request_id,
                fcr.request_date,
                flv.meaning status,
                fcr.status_code,
                fcr.completion_text,
                fcr.logfile_name,
                fcr.outfile_name,
                fcr.argument_text
  FROM apps.fnd_concurrent_programs_vl fcp,
       apps.fnd_concurrent_requests    fcr,
       apps.fnd_lookup_values          flv
 WHERE fcr.concurrent_program_id = fcp.concurrent_program_id
   AND trunc(fcr.last_update_date) = trunc(SYSDATE)
   AND flv.lookup_code = fcr.status_code
   AND flv.lookup_type = 'CP_STATUS_CODE'
   AND flv.language = 'US'
 ORDER BY fcr.request_date desc