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;

2 thoughts on “Query to Update the Concurrent Request Status as Terminated from Backend”

Great information shared.. really enjoyed reading this post thank you author for sharing this post .. appreciated

I truly appreciate your technique of writing a blog. I added it to my bookmark site list and will

2 thoughts on “Query to Update the Concurrent Request Status as Terminated from Backend”