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
https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=134007.1

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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