Thursday, June 8, 2017

Find Concurrent Program last run Date in Oracle Apps

Concurrent Program Last run details:
========================

SELECT  to_char(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 - 1
       AND fcpt.user_concurrent_program_name LIKE '%Program Name%' ;

No comments:

Post a Comment