Your Doorstep to the Temple of Oracle

Oracle EBS

unable to cancel concurrent program from fornt end

Posted by appsdba11i on April 22, 2011

+ Kill The Database Session Associated with the Request.

Note: 187504.1 – bde_request.sql – Process and Session info for one Concurrent Request (11.5)
Note: 735119.1 – How to Find Database Session & Process Associated with a Concurrent Program Which is Currently Running

if u still find that program is runnig then

Run the following query to cancel that request:

SQL> update fnd_concurrent_requests
set status_code=’D’, phase_code=’C’
where request_id=;

Or, you can use cmclean.sql after shutting down the CM.

Note: 134007.1 – CMCLEAN.SQL – Non Destructive Script to Clean Concurrent Manager Tables


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s