Monday, October 5, 2015

Concurrent Programs running more than 1 hour in oracle applications


  SELECT fu.user_name,
         fu.description,
         request_id,
         fcp.user_concurrent_program_name,
         actual_start_date,
         TRUNC ( (SYSDATE - actual_start_date) * 24, 2) time_in_hours
    FROM apps.fnd_concurrent_requests fcr,
         apps.fnd_concurrent_programs_vl fcp,
         apps.fnd_user fu
   WHERE     actual_start_date LIKE SYSDATE
         AND fcr.request_date > TRUNC (SYSDATE)
         AND status_code = 'R'
         AND phase_code = 'R'
         AND fcr.concurrent_program_id = fcp.concurrent_program_id
         AND fu.user_id(+) = fcr.requested_by
         AND TRUNC ( (SYSDATE - actual_start_date) * 24, 2) > 1
-- AND fcp.concurrent_program_id = 750966
ORDER BY time_in_hours DESC

No comments:

Post a Comment