Script to HOLD and UNHOLD the scheduled concurrent requests

 
###################Holding Concurrent Request##################

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

Commit;

select substr(fcrv.request_id,1,10)REQUEST,
substr
(fcrv.program,1,25)PROGRAM,
fcr.hold_flag,fcr.PHASE_CODE,fcr.status_code,fcr.last_updated_by
from apps.fnd_conc_req_summary_v fcrv,apps.fnd_concurrent_requests fcr
where fcrv.request_id = fcr.request_id and fcr.hold_flag = 'Y' and fcr.phase_code='P';

###################Un Holding Concurrent Request##################

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;

Commit;