How to Terminate a Concurrent Requests from backend

 We can terminate the concurrent request from backend by using below update statement .

 update apps.fnd_concurrent_requests set phase_code='C' , status_code='X' where request_id='&REQUEST_ID'; 

SQL> commit;

Note: Please remember to kill the process for that request.

The related process Id for the Concurrent Requests can be determined by

select ORACLE_PROCESS_ID from apps.fnd_concurrent_requests where REQUEST_ID='&REQUEST_ID';


You can refer my previous post about status-codes-and-phase-codes