R12.2 Apps DBA. Powered by Blogger.

How to Disable all scheduled Concurrent Request in R12.2

No comments :
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;
/
fix:
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
metalink reference articles.
170107.1 and  152209.1

No comments :

Post a Comment

Note: only a member of this blog may post a comment.