Wednesday, April 2, 2014

How to terminate Concurrent Program from backend and Killing Session in Oracle APPS R12

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#>’;

No comments:

Post a Comment