Thursday, December 22, 2016

Concurrent Request on hold


Put all Concurrent requests on hold.

UPDATE fnd_concurrent_requests
SET hold_flag = 'Y'
WHERE phase_code = 'P'
and status_code in ('Q','I');

unhold all requests submitted/submitted by sysadmin --

UPDATE fnd_concurrent_requests
SET hold_flag = 'N'
WHERE phase_code = 'P'
and status_code in ('Q','I')
and REQUESTED_BY='0';