Inventory Management - EBS (MOSC)

MOSC Banner

ORA-00060: Deadlock detected while waiting for resource

edited Mar 1, 2011 12:56PM in Inventory Management - EBS (MOSC) 3 commentsAnswered
 Hi All,

On month end there are 2 uncosted transactions in an org. On tracing back i was able to see that there was a pick release transaction on 15 Feb 2011 which had an error code ORA-00060: Deadlock detected while waiting for resource. I also checked in TOAD, MTL_Material_Transactions table for this particular transaction id the costed_flag was showing as E.

How can i rectify this transaction? How is it possible to get the trace file for this transaction to see what the error was?

Pls help as its month end

Jay

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Inventory Mgmt Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center