Tuesday, April 6, 2010

Status code and Phase code for Concurrent requests

Status code and Phase code for Concurrent requests
Here is what the abbreviation for status code and phase code means for Concurrent Requests in Oracle Apps

select lookup_type,lookup_code,meaning
from fnd_lookups
where lookup_type in ('CP_STATUS_CODE','CP_PHASE_CODE')

LOOKUP_TYPE LOOKUP_CODE MEANING
CP_PHASE_CODE C Completed
CP_PHASE_CODE I Inactive
CP_PHASE_CODE P Pending
CP_PHASE_CODE R Running

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

Note above that there are three status codes for Normal: C, I, and R and there are two satus codes for Waiting: A and Z.
Thus a request in "Running" "Normal" state will have phase_code "R" and status_code"R"

No comments:

Post a Comment