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';
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
*********************SAUDI APPS DBA**********************************************
www.sbjaffer.com
No comments:
Post a Comment