Request xxxxxx can no longer be canceled

 Problem:

when we try to cancel a concurrent request using the frontend “Cancel Request” button from the Administer > Concurrent > Manager form.
We are getting the following message:

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

Solution.

connect to APPS,

1. Backup of FND_CONCURRENT_REQUESTS.

create table fnd_concurrent_requests_backup_12_Apr_22 as select * from fnd_concurrent_requests;

2. UPDATE.

UPDATE fnd_concurrent_requests

SET phase_code = ‘C’, status_code = ‘D’

WHERE Request_id=&request_id

3. Commit.