How to Cancel a Concurrent Request Stuck in the Queue

Cause:

Tried to Cancel a concurrent request. Used the "Cancel Request" button from the Administer > Concurrent > Manager form.

 Got the following message:

Request xxxxxx can no longer be cancelled. The Concurrent Manager Process that was running this request has exited abnormally. The ICM will mark this request as completed with error.

Solution :

 

SQL> UPDATE fnd_concurrent_requests

     SET phase_code = 'C', status_code = 'X'

     WHERE request_id = '<request id>';

     commit;

How to Cancel a Concurrent Request Stuck in the Queue? [ID 749748.1]

ANALYZEREQ.SQL Detailed Analysis of One Concurrent Request (Release 11 and up) [ID 134035.1]