How to terminate and cancel the request in oracle apps?

Please cancel the Request Id.35853542 in ebsoltp instance.
Note:
 you will get a request from user as user is unable to cancel a request from front end and user will raise a ticket with dba team to terminate a request.



find out crossponding sid for the request id .35853542.Once you found check sid status and hash sql vlaue
that will help you when you try to update fnd_concurrent_requests taable and you are unable to update the table or it will hang or it will not come to the prompt in such case you need sid and serial# value to kill the session.

SQL> @sid
What is the SID : 3538

LOGONTIME SID SERIAL# STATUS TYPE USERNAME OSUSER MACHINE PROGINFO
--------------- ------ ---------- -------- ---------- ---------- ---------- ---------- ------------------------------
PROCESS DBProc SQL_HASH_VALUE
------------------------ ------ --------------
06/10 13:33:10 3538 339 ACTIVE USER APPS appoltp ctssp e:FND:cp:STANDARD - STANDARD@t
4225 23232 3964553037

SQL>

SQL> @hashsql
What is the SQL Hash Value : 2283418808

SQL_TEXT
----------------------------------------------------------------
begin FND_CP_OPP_REQ.postprocess (:reqid, :groupid, :flag, :errm
sg); end;


SQL> select name from v$database;

NAME
---------
ebsoltp

SQL> update applsys.fnd_concurrent_requests set phase_code = 'C',status_code = 'X' where request_id ='35853542';

==>sometime it will hang here.do alter system kill session new window and commit it.
1 row updated.

SQL> commit;

Commit complete.

SQL>


awstatus.sql
select sid,serial#,machine,sql_hash_value,status from v$session where sid='3538';

Below script and above sql statement is same.

SQL> @awstatus.sql
Enter value for sid: 3538

SID SERIAL# MACHINE SQL_HASH_VALUE STATUS
------ ---------- ---------- -------------- --------
3538 339 ctssp 2283418808 ACTIVE

SQL> alter system kill session '3538,339';

System altered.

SQL>