After submitting concurrent request, the phase of the request is RUNNING and never completing. When we search for the database session, it is not having any session id for the request_id. Therefore, request needs to be canceled and resubmitted. However, when we try to cancel it throws error as below.
Even from backend, we are not able to cancel the request due to lock, which is held by Concurrent Requests. So let us check how to cancel the request. Before that we will analyze the route cause for this issue.
Cause:
When issue ‘ps -ef | grep lp’ from OS command line you will find some failing lp print jobs, showing the user name of the same person who owns those running requests. If ‘kill -9’ in Unix is done on those requests, then the Request Summary from within Applications will change from RUNNING to COMPLETED with WARNING.
When Any XML Publisher Requests are submitted in Oracle Applications, Once, the control has moved from standard manager to OPP manager, Requests are unable to cancel. We found there is issue in progressing the request in Output Post Process. So plenty of request are not completed. So we follow the below steps to cancel the request.
Step 1:
Column Manager Format A12
Column Request Format 999999999
Column Program Format A30
Column User_Name Format A15
Column Started Format A15
Column FNDLIBR Format A9
select substr(Concurrent_Queue_Name, 1, 12) Manager,
Request_Id Request,
User_name,
pro.OS_PESS_ID “FNDLIBR”,
substr(Concurrent_Program_Name, 1, 35) Program,
Status_code,
To_Char(Actual_Start_Date, ‘DD-MON-YY HH24:MI’) Started
from apps.Fnd_Concurrent_Queues cq,
apps.Fnd_Concurrent_Requests cr,
apps.Fnd_Concurrent_Programs cp,
apps.Fnd_User Fu,
apps.Fnd_Concurrent_PesS pro
where Phase_Code = ‘R’ And Status_Code ‘W’ And
cr.Controlling_Manager = Concurrent_Pess_Id and
(cq.Concurrent_Queue_Id = pro.Concurrent_Queue_Id and
cq.Application_Id = pro.Queue_Application_Id) and
(cr.Concurrent_Program_Id = cp.Concurrent_Program_Id and
cr.Program_Application_Id = cp.Application_Id) and
cr.Requested_By = User_Id and
cr.request_id =&request_id
/
Step 2:
Now take OS Process id from the above query and get associated Session details using below script .
select S.sid,
S.serial# serial#,
P.spid,
S.sql_id,
S.Process,
S.last_call_et,
S.event
from gv$session S, gv$process P
where S.paddr = P.addr
and S.process in (‘&process_ID’);
Step 3:
Now kill the database session using alter system kill session ‘,’ immediate;
Step4:
Try now to cancel the request and we able to cancel. Else use the below update script to cancel.
UPDATE apps.fnd_concurrent_requests
SET phase_code = ‘C’, status_code = ‘X’
WHERE request_id = ‘’;
commit
/
Now we able to cancel the request.
