Kill Current Session and Update Concurrent Program Status
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.