We execute very frequently SQL on the table – FND_CONCURRENT_REQUESTS to get the details on the Concurrent details to analysis and know the parameters and other details but not sure if we actually have details on allĀ Status Codes and Phase Codes getting used in the table – FND_CONCURRENT_REQUESTS
MEANING FOR THE PHASE_CODE COLUMN VALUES:
C Completed
I Inactive
P Pending
R Running
MEANING FOR THE STATUS_CODE COLUMN VALUES:
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