How to Cancel a Concurrent Request Stuck in the Queue
“The concurrent manager process that was running this request has exited abnormally. The ICM will mark this request as completed with error”.
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.
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’
Here Request id is the request which we want to cancel….