How to stop concurrent requests

How to Terminate running Concurrent Requests- in Oracle Apps>

Set Terminating or Running to phase_code- Completed and status_code-Terminated 

Many times, we get request from development team, that a request is running from long time and doing nothing or to terminate request from back end. In this case, we can use below sql query to update the request to Terminated.

 
UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'X'
WHERE status_code ='T'
OR phase_code = 'R';

Remember to commit it.

commit;

How to set pending jobs on Hold->

Manytimes, during ERP downtime- like patching etc, we want to place the pending concurrent requests on hold. We can use the below sql query for accomplishing the same.

Place Pending/(Normal/Standby) to On Hold
UPDATE fnd_concurrent_requests
SET hold_flag = 'Y'
WHERE phase_code = 'P'
AND status_code in ('Q','I');

commit;

The above two queries can also be used if you don't want to run the requests which are copied from source system to target system during cloning. The above can be executed before making the CM up.

Also, to remove the hold from concurrent request after the downtime, we can use following query-

UPDATE fnd_concurrent_requests 
SET hold_flag = 'N' 
WHERE phase_code = 'P' 
AND status_code in ('Q','I');

commit;