There are 2 Steps for Cancelling Concurrent Request from Back End :
Step 1 :-
1. Run the below SQL query. Give the request id.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
SQL> select status_code,phase_code from fnd_concurrent_requests where request_id=&RequestID; Otput Example – S P S P - - or - - D C R R STATUS : X =Terminated I = Inactive(on Hold ) E Completed ( Error ) G = Completed ( Warning ) D Cancelled C = Completed ,R = Running |
Step 2 :-
2. Run Update Query. Please note it should be same as above.
|
1 2 3 4 5 |
SQL> update fnd_concurrent_requests set phase_code='C' , status_code='D' where request_id=&RequestID; SQL> commit; (Do remember to commit) Commit complete. |
