How To Cancel Concurrent Request from Back End

Vineet Badre September 18, 2018 ORACLE

There are 2 Steps for Cancelling Concurrent Request from Back End :

Step 1 :-

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

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.

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

SQL> commit; (Do remember to commit)

Commit complete.

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

SQL> commit; (Do remember to commit)

Commit complete.

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

How To Cancel Concurrent Request from Back End

About Vineet Badre

2 comments

Leave a Reply Cancel reply