Force termination of a concurrent request

To force a concurrent request to terminate do the below:

SQL> update fnd_concurrent_requests
set status_code='X', phase_code='C'
where request_id=xxxxxx;

SQL> commit;

Then run CMCLEAN.sql script and restart the concurrent manager.