Sunday 10 January 2016

How to disable all scheduled concurrent programs after refresh

Below script to disable scheduled concurrent programs after refresh.

Script:

update fnd_concurrent_requests
set phase_code='C',
status_code='D'
where phase_code = 'P'
and (status_code = 'I' OR status_code = 'Q');
and requested_start_date >= SYSDATE
and hold_flag = 'N';

No comments:

Post a Comment