Query to find runtime of a concurrent program

The query works in both Rel 12 and 11i.


— Query to find runtime for a concurrent program


SELECT /*+ rule */

       rq.parent_request_id                   “Parent Req. ID”,

       rq.request_id                          “Req. ID”,

       tl.user_concurrent_program_name        “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)   “Runtime (in 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 tl.LANGUAGE              = USERENV(‘LANG’)

   AND rq.actual_start_date IS NOT NULL

   AND rq.actual_completion_date IS NOT NULL

   AND tl.user_concurrent_program_name = ‘Autoinvoice Import Program’  — <change it>

   — AND TRUNC(rq.actual_start_date) = ‘&start_date’  — uncomment this for a specific date

 ORDER BY rq.request_id DESC;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s