Query to find long running concurrent request in oracle apps

Query to find long running concurrent request in oracle apps

In this post , We will be discuss about Query to find long running concurrent request in oracle apps. This SQL query will help to find the long running concurrent requests in oracle apps. This will help to monitoring the long running concurrent jobs/requests in oracle apps. We will be able to track the long running concurrent requests in oracle. Here below is the detail about Query to find long running concurrent request in oracle apps.

2 Important Tables used by Query to find long running concurrent request in oracle apps

1.fnd_concurrent_programs_tl  tl,

2.fnd_concurrent_requests    

Detail SQL Query to find long running concurrent request in oracle apps

 Select   
rq.request_id                          "Concurrent Request ID",

       tl.user_concurrent_program_name        "Concurrent Program Name",

       rq.actual_start_date                   "Start Date",

       rq.actual_completion_date              "Completion Date",

       ROUND((rq.actual_completion_date -

           rq.actual_start_date) * 1440, 2)   "Program Runtime (Minutes)"      

  FROM applsys.fnd_concurrent_programs_tl  tl,

       applsys.fnd_concurrent_requests     rq

 WHERE tl.application_id        = rq.program_application_id

   AND tl.concurrent_program_id = rq.concurrent_program_id

   AND rq.actual_start_date IS NOT NULL

   AND rq.actual_completion_date IS NOT NULL

 ORDER BY rq.request_id DESC

Query to find long running concurrent request in oracle apps

Query to find long running concurrent request in oracle apps