Saturday, July 11, 2015

Query to checking the concurrent programs running currently with details of processed time

  SELECT DISTINCT
         c.user_concurrent_program_name,
         ROUND ( ( (SYSDATE - a.actual_start_date) * 24 * 60 * 60 / 60), 2)
            AS process_time,
         a.request_id,
         a.parent_request_id,
         a.request_date,
         a.actual_start_date,
         a.actual_completion_date,
         (a.actual_completion_date - a.request_date) * 24 * 60 * 60
            AS end_to_end,
         (a.actual_start_date - a.request_date) * 24 * 60 * 60 AS lag_time,
         d.user_name,
         a.phase_code,
         a.status_code,
         a.argument_text,
         a.priority
    FROM apps.fnd_concurrent_requests a,
         apps.fnd_concurrent_programs b,
         apps.fnd_concurrent_programs_tl c,
         apps.fnd_user d
   WHERE     a.concurrent_program_id = b.concurrent_program_id
         AND b.concurrent_program_id = c.concurrent_program_id
         AND a.requested_by = d.user_id
         AND status_code = 'r'

ORDER BY process_time DESC;

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect