Cancel a request

[latifa]

Hi Erman,

I am looking to cancel a request but I can't. Message when doing this is:

Request xxxx can no longer be cancelled. The concurrent manager process that was running this request has exited abnormally. The ICM will mark this request as completed with error.


I have done this but no way:

update
   fnd_concurrent_requests
set
   phase_code = 'C',
   status_code = 'E'
where
   request_id =xxxxx ;

I tried to do that in the DB but no way,
Select request_id,os_process_id from fnd_concurrent_requests where request_id='2030578' ;

REQUEST_ID
----------
OS_PROCESS_ID
--------------------------------------------------------------------------------
   xxxxx
yyyy


@APPS@DBOFINP11 >select s.sid , s.serial# from v$session s , v$process p where s.paddr = p.addr and s.process ='yyyy' ;

no rows selected


Any advise please.

Regards,
Latifa

[latifa]

I don't know if it was the following instruction which completed the request or it finished alone:

update
   fnd_concurrent_requests
set
   status_code='X',
   phase_code='C'
where
   request_id =xxxxx;

commit ;



Regards,
Latifa

[ErmanArslansOracleBlog]

I think the process was already exited abnormally in the first place..
This is because of the message you got : "Request xxxx can no longer be cancelled. The concurrent manager process that was running this request has exited abnormally."

did you check the ICM logs? and the related concurrent manager's log? (standard manager or any other manager defined to run this request?)

In such a situation, check the db side as well.
If there is nothing related running in db as well (no problematic concurrent request-related database session is present), updating the problematic concurrent request's phase and status is the right thing to do to have a clean metadata for the concurrent processing environment.