SQL Concurrent Request Status Codes and Phase Codes
--to cancel all scheduled concurrent programs.
UPDATE fnd_concurrent_requests
SET phase_code = 'C',
status_code = 'X'
WHERE status_code IN ('Q', 'I')
AND
requested_start_date > SYSDATE
AND hold_flag = 'N';
COMMIT;
--to cancel all running concurrent programs
UPDATE fnd_concurrent_requests
SET phase_code = 'C',
status_code = 'X'
WHERE status_code IN ('R',
'I');Commit;
--conc request phase codes
SELECT LOOKUP_CODE, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'CP_PHASE_CODE' AND LANGUAGE = 'US'
AND ENABLED_FLAG = 'Y';
--to cancel Specific request
UPDATE fnd_concurrent_requests
UPDATE fnd_concurrent_requests
SET status_code =
'D', phase_code = 'C'
WHERE request_id
= ;
Lookup_code
|
Meaning
|
C
|
Completed
|
I
|
Inactive
|
P
|
Pending
|
R
|
Running
|
--concurrent request status codes
SELECT LOOKUP_CODE, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'CP_STATUS_CODE' AND LANGUAGE = 'US'
AND ENABLED_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
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
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. The status and the description of each
meaning given below:
Phase Status Description
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|