Query to Update the Concurrent Request Status as Terminated from Backend

Below sql can be used for Concurrent Requests struck in running state without any database session ,and could not cancelled from Front end.

sqlplus apps

update fnd_concurrent_requests set status_code=’X’,phase_code=’C’ where request_id=&request_id;

commit;