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
———————————-
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