R12.2 Apps DBA. Powered by Blogger.

Kill Current Session and Update Concurrent Program Status

No comments :
Kill Session
SELECT SID, serial#, module, action, status
  FROM v$session;

ALTER SYSTEM KILL SESSION 'SID,SERIAL#';

UPDATE fnd_concurrent_requests
   SET phase_code = 'C',
       status_code = 'X'
 WHERE request_id = &REQUEST_ID;

COMMIT;

No comments :

Post a Comment

Note: only a member of this blog may post a comment.