How to cancel concurrent request from back end.

1. Run the below SQL query. Give the request id.

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

2. Run Update Query. Please note it should be same as above.

SQL> update fnd_concurrent_requests set phase_code='C' , status_code='D'  where request_id=&RequestID;

SQL> commit;  (Do remember to commit)

Commit complete.