How to hold the concurrent requests

List out the Jobs which were already on HOLD

select request_id, phase_code, status_code from fnd_concurrent_requests where hold_flag = 'Y';



3.Create backup of the table with the jobs which were already ON HOLD ##############



create table jobs_already_on_hold as (select request_id, phase_code, status_code from fnd_concurrent_requests where hold_flag = 'Y');



select count(*) from jobs_already_on_hold;

select * from jobs_already_on_hold;



4.Now, Place the pending jobs on HOLD using the below update command.

update fnd_concurrent_requests set hold_flag = 'Y' where phase_code = 'P'  and hold_flag = 'N';

commit;

5.Release Jobs from HOLD

SQL> UPDATE fnd_concurrent_requests

   SET hold_flag = 'N'

WHERE     hold_flag = 'Y'

       AND request_id NOT IN (SELECT request_id FROM jobs_already_on_hold)

Please ensure to check the below query for every 5 minutes until it returns 0 rows.

  List the pending ,running and passed  requests

  

SQL> 

SELECT REQUEST_ID,

       PHASE_CODE,

       STATUS_CODE,

       HAS_SUB_REQUEST,

       IS_SUB_REQUEST,

       hold_flag,

       REQ_INFORMATION

  FROM apps.fnd_concurrent_requests

WHERE    (phase_code = 'P' AND hold_flag = 'N')

       OR phase_code = 'R'

       OR status_code = 'W';