Terminating concrurrent request

Hi,

I want to know how can we Terminate a Long running Concurrent
Request from the Front-End.


Farooq
Appsdba

by killing it?

By sid ?

I want to Terminate it from Front-end is it Possible as SysAdmin.

To update any Running or Terminating requests to Completed/Error, please use the following

SQL> UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'E'
WHERE status_code ='T' OR phase_code = 'R';


If you Know the Request ID.,

SQL> UPDATE fnd_concurrent_requests
SET phase_code = 'C', status_code = 'E'
WHERE request_id = '322';