Experience: is what you get soon after you need it.
My Cloud Certifications:
AWS Certified Solutions Architect Associate
Azure Certified Administrator
Oracle Cloud Infrastructure 2018 Certified Architect Associate.
Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.
Oracle Database Cloud Administrator Certified Professional.
Oracle Database Cloud Service Operations Certified Associate.
Friday, April 1, 2011
Find Scheduled concurrent programs
select a.request_id, b.user_concurrent_program_name,c.concurrent_program_name,a.requested_start_date, c.EXECUTION_METHOD_CODE,
from apps.fnd_concurrent_requests a, apps.fnd_concurrent_programs_tl b, apps.fnd_concurrent_programs c,
where status_code in ('Q','I')
and a.concurrent_program_id = b.concurrent_program_id
and b.concurrent_program_id = c.concurrent_program_id
and a.requested_start_date > SYSDATE
and a.hold_flag = 'N'
order by 1;
also look at the below notes for further understanding:
How to Determine Scheduled Concurrent Requests [ID 170107.1]
What are the Meaning of the Codes in the STATUS_CODE and PHASE_CODE Columns of FND_CONCURRENT_REQUESTS Table? [ID 152209.1]
Status Code Incorrect for Scheduled Requests in FND_CONCURRENT_REQUESTS Table [ID 1054419.6]