Monday, May 6, 2013

ICM will mark this request as completed, will it?

From time to time, when trying to access concurrent requests you can be presented with this error message:

Request [ID] 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.

That would be fine if it actually happened, but the problem is that I've seen this error message on many different EBS, Tech Stack and database versions over seven years and I've never actually seen the ICM mark the request in any way when the request gets into this state.  There are 2 ways that I know how to resolve this.  One, go into Help -> Diagnostics -> Examine (if you have this available) and change the fields PHASE_CODE to C and the STATUS CODE to X in two separate "transactions", Ctrl-S to save the record and when you refresh the form the request should show as Completed/Terminated.  The other way is much more simple, where you write a script to update the same columns for the request in fnd_concurrent_requests as such:

update fnd_concurrent_requests
set phase_code = 'C', status_code = 'X'
where request_id = [ID]

1 comment: