Put Concurrent Requests on HOLD when we need to bounce the CONC Managers due to some maintenance activity

To put the jobs on hold –
~~~~~~~~~~~~~~~~~~~

update applsys.fnd_concurrent_requests set hold_flag = 'Y',last_update_date = sysdate,last_updated_by = -1 where phase_code = 'P';

 To release job after downtime –

~~~~~~~~~~~~~~~~~~~~~~~

update applsys.fnd_concurrent_requests a set a.hold_flag = 'N' , last_update_date = sysdate, last_updated_by = -1 where phase_code = 'P'
and a.hold_flag = 'Y'
and last_updated_by = -1
and last_update_date > sysdate-1;


Terminate one concurrent Request:

update applsys.fnd_concurrent_requests
set phase_code = 'C',
status_code = 'X',
actual_completion_date = sysdate
where request_id = '&R';