Saturday, July 11, 2015

Query to checking last run of a concurrent program along with processed time. useful to find the details of concurrent programs which run daily and comparison purpose

SELECT DISTINCT
       c.user_concurrent_program_name,
       ROUND (
          (  (a.actual_completion_date - a.actual_start_date)
           * 24
           * 60
           * 60
           / 60),
          2)
          AS process_time,
       a.request_id,
       a.parent_request_id,
       TO_CHAR (a.request_date, 'dd-mon-yy hh24:mi:ss'),
       TO_CHAR (a.actual_start_date, 'dd-mon-yy hh24:mi:ss'),
       TO_CHAR (a.actual_completion_date, 'dd-mon-yy hh24:mi:ss'),
       (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 trunc(a.actual_completion_date) = '24-aug-2005'
       AND c.user_concurrent_program_name = 'incentive compensation analytics - odi'
       --  and argument_text like  '%, , , , ,%';

       --  and status_code!='c'

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect