How to Stop Concurrent Requests from Executing on New Cloned Environment

 If you do not want concurrent requests scheduled in Source to run on a newly cloned environment, Follow the below steps

1. Run “perl adcfgclone.pl appsTier” as normal.
Before starting the application services, run the below update commands

-Take Backup of fnd_concurrent_requests

create table  fnd_concurrent_requests_bkp as select * from fnd_concurrent_requests;

-Terminate ‘Running’ Requests

UPDATE fnd_concurrent_requests
SET phase_code = ‘C’, status_code = ‘X’
WHERE status_code =’R’
OR phase_code = ‘R’
/

-Set Pending jobs to ‘On Hold’

UPDATE fnd_concurrent_requests
SET hold_flag = ‘Y’
WHERE phase_code = ‘P’
AND status_code in (‘Q’,’I’)
/