How to Know Concurrent Program finishes

Query FND_CONCURRENT_REQUESTS table to verify (STATUS_CODE and PHASE_CODE)

 

STATUS_CODE Column:

 

• A Waiting
• B Resuming
• C Normal
• D Cancelled
• E Error
• F Scheduled
• G Warning
• H On Hold
• I Normal
• M No Manager
• Q Standby
• R Normal
• S Suspended
• T Terminating
• U Disabled
• W Paused
• X Terminated
• Z Waiting

  

PHASE_CODE column

• C Completed
• I Inactive
• P Pending
• R Running

one such cases are :
select count (*) from FND_CONCURRENT_REQUESTS where STATUS_CODE = 'Q' and PHASE_CODE = 'P';