Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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. |
I appreciate your efforts vineet, keep doing!
Thanks dude!