Cancel a request

Posted by latifa on Feb 26, 2018; 2:08pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Cancel-a-request-tp5258.html

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