Concurrent program last run date query

Concurrent program last run date query

In this post , We will be discuss about Concurrent program last run date query. Using this sql query , we will be able to get all concurrent program last run date history. we will be able to get the complete information about concurrent program running details. This is one of the important sql query to extract the concurrent program last running details. Please find below the complete detail about Concurrent program last run date query.

Important Table used by Concurrent program last run date query

1.fnd_concurrent_requests

2.fnd_concurrent_programs_tl 

Detail Concurrent program last run date query

SELECT  fcpt.user_concurrent_program_name,

to_char(MAX (fcr.REQUEST_DATE) Last run 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 fcpt.user_concurrent_program_name LIKE '%Program Name%' 

       group by  fcpt.user_concurrent_program_name