SQL commnadto hold/cancel all concurrent requests

Manually cancel the request out of the queue with the following SQL against the offending
request id(s). This can be safely done while managers are up and running:


SQL> UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE request_id = '';
commit;

Note: To obtain request details prior to cancelling the request, use Note 134035.1 ANALYZEREQ.SQL - Detailed Analysis of One Concurrent Request. When prompted, provide the request id to be analyzed. This can be useful for determining the reason why the request may be stuck in the queue