Generic Alert Log Error: DEADLOCK DETECTED ( ORA-00060 ) (Doc ID 1549444.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 17-MAR-2015***

Goal

Reviewed alert log and associated trace log automatically created by the system.  See:

DEADLOCK DETECTED ( ORA-00060 )

[Transaction Deadlock]

The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:

Deadlock graph:
  ---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-01a8000d-0001727b 281 555 X 88 71 X
TX-01a90007-0001c378 88 71 X 281 555 X

session 555: DID 0001-0119-0000435D session 71: DID 0001-0058-00008EA0
session 71: DID 0001-0058-00008EA0 session 555: DID 0001-0119-0000435D

----- Current SQL Statement for this session (sql_id=3um94ruurr4vg) -----
UPDATE WF_ITEM_ATTRIBUTE_VALUES SET NUMBER_VALUE = NUMBER_VALUE + 1 WHERE NAME LIKE '#CNT_%' AND NUMBER_VALUE IS NOT NULL AND ITEM_TYPE = :B2 AND ITEM_KEY = :B1
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object line object
 handle number name
0x211e40288 5100 package body APPS.WF_ENGINE
0x1ed864308 1058 package body APPS.OE_ORDER_WF_UTIL 0x1ed864308 840 package body APPS.OE_ORDER_WF_UTIL
0x1ed864308 777 package body APPS.OE_ORDER_WF_UTIL
0x1ce389400 16468 package body APPS.OE_LINE_UTIL
0x210ab5ba0 3373 package body APPS.OE_ORDER_PVT
0x210ab5ba0 6822 package body APPS.OE_ORDER_PVT
0x210ab5ba0 8228 package body APPS.OE_ORDER_PVT
0x1e6baf8b8 224 package body APPS.OE_SHIPPING_INTEGRATION_PVT
0x1e6baf8b8 3669 package body APPS.OE_SHIPPING_INTEGRATION_PVT
0x1e6baf8b8 4618 package body APPS.OE_SHIPPING_INTEGRATION_PVT
0x204e78158 1044 package body APPS.OE_SHIP_CONFIRMATION_PUB
0x1e4ed40d0 2321 package body APPS.OE_DS_PVT
0x1e4ed40d0 628 package body APPS.OE_DS_PVT
0x2138c4938 4 anonymous block
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms