How to kill terminating/long running/hang request oracle

Action:

1) #First Terminate the Request as follows

         update fnd_concurrent_requests

         set status_code='X', phase_code='C'

         where request_id=10122488;

         commit;

2) #Then change the status with Completed-Error as follows.

         update fnd_concurrent_requests

         set status_code='E', phase_code='C'

         where request_id=10122488;

         commit;

#This will change the status of any request.

#Status Code

E -  Error

X -  Terminate

G -  Warning