All the Concurrent Requests submitted from the Front-end are recorded in fnd_concurrent_requests and it has 2 specific columns which will describe the status.Please find the detailed description of each code.
FND_CONCURRENT_REQUESTS table
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
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
1 comment:
select pl.meaning, sl.meaning, fcr.*
from FND_CONCURRENT_REQUESTS fcr
,Fnd_Lookups pl
,Fnd_Lookups sl
where pl.lookup_type = 'CP_PHASE_CODE'
AND pl.lookup_code = fcr.phase_code
AND sl.lookup_type = 'CP_STATUS_CODE'
AND sl.lookup_code = fcr.status_code
AND (fcr.phase_code <> 'C' AND fcr.status_code <> 'C');
Post a Comment