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 || '%'
it is for 1 concurrent program, if we want to check for multiple concurrent programs last run date at once
ReplyDeleteit is for 1 concurrent program, if we want to check for multiple concurrent programs last run date at once
ReplyDeleteThanks for this useful bit of sql!
ReplyDelete