Kill Current Session and Update Concurrent Program Status

Here in this post we will discuss on how to kill a background session and update the concurrent program's status.

Kill the Session

The following query will pick up all the active session which is running. Find the one which your concurrent program makes use of.

SELECT SID, serial#, module, action, status

  FROM v$session;

 Then use the below command to the session.

ALTER SYSTEM KILL SESSION 'SID,SERIAL#' -- Use the values which corresponds to your request --

Update Concurrent Program Status

Then update the concurrent program status to Terminated

UPDATE fnd_concurrent_requests

   SET phase_code = 'C',

       status_code = 'X'

 WHERE request_id = &REQUEST_ID;

COMMIT;

For any suggestion or issues with the above code, please leave your comments. I will try to reply back as soon as possible