Saturday, June 16, 2018

How to stop a stubborn concurrent request

select ORACLE_PROCESS_ID from apps.fnd_concurrent_requests where REQUEST_ID='137716679';

137716679

update apps.fnd_concurrent_requests set phase_code='C' , status_code='X' where request_id='&REQUEST_ID';

select ORACLE_PROCESS_ID,phase_code,status_code from apps.fnd_concurrent_requests where REQUEST_ID='137716679';

update apps.fnd_concurrent_requests set phase_code='C' , status_code='X' where request_id='137716679';

No comments:

Post a Comment