FOR KILLING A CONCURRENT REQUEST AND FOR KILLING A SESSION

FOR KILLING A CONCURRENT REQUEST:

UPDATE fnd_concurrent_requests

   SET phase_code = ‘C’,

       status_code = ‘X’

 WHERE request_ID = xxxx;

FOR KILLING A SESSION:

Syntax:

alter system kill session ‘<sid>,<Serial#>’;