Terminating a Concurrent Requests
Concurrent Requests can be terminated from front end. But we can also terminate the Concurrent Request from the back end.
update apps.fnd_concurrent_requests set phase_code='C' , status_code='X' where request_id=&REQUEST_ID;
Note: Please remember to kill the process for that request first before terminating the concurrent 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;
update apps.fnd_concurrent_requests set phase_code='C' , status_code='X' where request_id=&REQUEST_ID;
Note: Please remember to kill the process for that request first before terminating the concurrent 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;
if you like please follow and comment
1 Comments
Thank you so much!
ReplyDeleteIt was useful.
Post a Comment