How to Disable all scheduled Concurrent Request in R12

The following query will disable all the scheduled concurrent request in Oracle R12.





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

/

commit;

/

The following is the metalink reference articles.

a. 170107.1

b. 152209.1