Monday, 16 May 2016

Query to find the last run date of a Concurrent Program in Oracle Apps

Query to find the last run date of a Concurrent Program
--input:     Concurrent Program name


SELECT MAX (fcr.REQUEST_DATE)
  FROM fnd_concurrent_requests          fcr,
       fnd_concurrent_programs_tl       fcpt
 WHERE     fcr.concurrent_program_id = fcpt.concurrent_program_id
       AND fcr.program_application_id = fcpt.application_id
       AND fcr.actual_start_date > SYSDATE - :days_to_check
       AND fcpt.user_concurrent_program_name LIKE '%' || :Program_Name || '%'

3 comments:

  1. it is for 1 concurrent program, if we want to check for multiple concurrent programs last run date at once

    ReplyDelete
  2. it is for 1 concurrent program, if we want to check for multiple concurrent programs last run date at once

    ReplyDelete
  3. Thanks for this useful bit of sql!

    ReplyDelete