Concurrent Request Status Codes and Phase Codes

Concurrent Request Phase Codes:-

SELECT LOOKUP_CODE, MEANING

FROMFND_LOOKUP_VALUES

WHERE LOOKUP_TYPE = 'CP_PHASE_CODE' AND LANGUAGE = 'US'

ANDENABLED_FLAG = 'Y';

LOOKUP_CODE	MEANING
C	Completed
I	Inactive
P	Pending
R	Running

Concurrent Request Status Codes:-

SELECT LOOKUP_CODE, MEANING

FROMFND_LOOKUP_VALUES

WHERE LOOKUP_TYPE = 'CP_STATUS_CODE' AND LANGUAGE = 'US'

ANDENABLED_FLAG = 'Y';

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

Normally a concurrent request proceeds through three, possibly four, life cycle stages or phases,

Phase Code Meaning with Description Pending Request is waiting to be run Running Request is running Completed Request has finished Inactive Request cannot be run Within each phase, a request's condition or status may change. Below appears a listing of each phase and the various states that a concurrent request can go through.   Status code and Phase code from fnd_concurrent_requests   FND_CONCURRENT_REQUESTS 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 The status and the description of each meaning given below: Phase Status Description PENDING Normal Request is waiting for the next available manager. Standby Program to run request is incompatible with other program(s) currently running. Scheduled Request is scheduled to start at a future time or date. Waiting A child request is waiting for its Parent request to mark it ready to run. For example, a report in a report set that runs sequentially must wait for a prior report to complete. RUNNING Normal Request is running normally. Paused Parent request pauses for all its child requests to complete. For example, a report set pauses for all reports in the set to complete. Resuming All requests submitted by the same parent request have completed running. The Parent request is waiting to be restarted. Terminating Running request is terminated, by selecting Terminate in the Status field of the Request Details zone. COMPLETED Normal Request completes normally. Error Request failed to complete successfully. Warning Request completes with warnings. For example, a report is generated successfully but fails to print. Cancelled Pending or Inactive request is cancelled, by selecting Cancel in the Status field of the Request Details zone. Terminated Running request is terminated, by selecting Terminate in the Status field of the Request Details zone. INACTIVE Disabled Program to run request is not enabled. Contact your system administrator. On Hold Pending request is placed on hold, by selecting Hold in the Status field of the Request Details zone. No Manager No manager is defined to run the request. Check with your system administrator.