Saturday, 6 July 2013

How to cancel running concurrent request

To cancel running concurrent request
———————————-
sqlplus>

UPDATE fnd_concurrent_requests
SET PHASE_CODE=’C’
,STATUS_CODE=’E’
WHERE request_id=’3477766′;

sqlplus>

UPDATE fnd_concurrent_requests
SET  PHASE_CODE=’C’
,STATUS_CODE=’E’
WHERE  CONCURRENT_PROGRAM_ID=’20393′;

(when large number of request are pending …kill all thiose with concurrent_program_id)

Hope this will help you.


Ur's
AmarAlam

0 comments:

Post a Comment