22 Nov 2024

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;



No comments:

Post a Comment

Was this Post Helpful?

Feel free to suggest your opinions in the comments section!