DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, April 20, 2017

To cancel particular concurrent program

update apps.fnd_concurrent_requests set phase_code = 'X', status_code = 'C' where request_id in (select REQUEST_ID from apps.fnd_concurrent_worker_requests where phase_code='P' and hold_flag!='Y' and USER_CONCURRENT_PROGRAM_NAME='&a' and requested_start_date<=sysdate and concurrent_queue_name<> 'FNDCRM' and concurrent_queue_name<> 'GEMSPS');

No comments: