How to Cancel a Concurrent Request Stuck in the Queue

Some times we get a Request from customers that they are not able to cancel their request because of the following error.

“The concurrent manager process that was running this request has exited abnormally.    The ICM will mark this request as completed with error”.





Navigation 


If we try to cancel a concurrent request using “Cancel Request” button from the Administer > Concurrent > Manager form.
We will get 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


This can be safely done when Concurrent Managers are up and running.


1) Backup fnd_concurrent_requests table


2) SQL> UPDATE fnd_concurrent_requests
SET phase_code = ‘C’, status_code = ‘X’
WHERE Request_id=&request_id
Here Request id is the request which we want to cancel….


3) Commit



Happy Learning…

  • December 30, 2016 | 31 views