ORA-00060 Deadlock Detected on Update of WF_LOCAL_ROLES (Doc ID 1189277.1)

Last updated on OCTOBER 07, 2016

Applies to:

Oracle Workflow Cartridge - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
In Oracle Applications 11i, different techstack levels are available regardless of the actual product level versions.
In earlier versions of 11i, Oracle Workflow (OWF) started releasing it's own patchsets (OWF.G & OWF.H) before rolling up it's patchset into ATG patchset releases for the later versions of 11i.

For Oracle Workflow Mini-pack 11i.OWF.G
Set up the default Oracle Workflow user preferences for your entire enterprise using the Global Preferences web page. The Global Preferences web page also lets you define your workflow administrator role and your Workflow web agent.

For Oracle Workflow Mini-pack 11i.OWF.H
User Interface Pages were upgraded to Oracle Applications Framework Technology

The following user interface pages, previously built using PL/SQL Web Toolkit technology, are now available in Oracle Applications Framework technology:

* Workflow Configuration (formerly Global Workflow Preferences)
*
Administration, Notification Search (formerly Find Notifications)
*
Administration, Vacation Rules (formerly Routing Rules)

Additionally, the seeded responsibilities for Oracle Workflow have been updated to remove the obsolete pages and add the new Oracle Applications Framework-based pages. Effective with Release 11.5.10, all Oracle Workflow PL/SQL Web Toolkit-based user interfaces will be desupported in favor of the Oracle Applications Framework-based equivalents.


Symptoms

Some dump files are generated, showing the following:

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-0f5b0013-00000160 200 2953 X 200 2953 X
session 2953: DID 0001-00C8-0001D632 session 2953: DID 0001-00C8-0001D632
Rows waited on:
Session 2953: obj - rowid = 0000B682 - AALKn0AHfAALNPEAAl
(dictionary objn - 46722, file - 479, block - 2937796, slot - 37)
Information on the OTHER waiting sessions:
End of information on OTHER waiting sessions.
Current SQL statement for this session:
UPDATE WF_LOCAL_ROLES SET NOTIFICATION_PREFERENCE = NVL(:B20 , NOTIFICATION_PREFERENCE), LANGUAGE = NVL(:B19 , LANGUAGE), TERRITORY = NVL(:B18 , TERRITORY), EMAIL_ADDRESS = :B17 , FAX = :B16 , DISPLAY_NAME = NVL(:B15 , DISPLAY_NAME), DESCRIPTION = :B14 , EXPIRATION_DATE = :B13 , STATUS = NVL(:B12 , STATUS), START_DATE = :B11 , PARENT_ORIG_SYSTEM = :B10 , PARENT_ORIG_SYSTEM_ID = :B9 , OWNER_TAG = :B8 , LAST_UPDATED_BY = :B7 , LAST_UPDATE_DATE = :B6 , LAST_UPDATE_LOGIN = :B5 WHERE NAME = :B4 AND ORIG_SYSTEM = :B3 AND ORIG_SYSTEM_ID = :B2 AND PARTITION_ID = :B1 AND USER_FLAG = 'Y'
----- PL/SQL Call Stack -----
object line object
handle number name
0x400047e650 3214 package body APPS.WF_DIRECTORY
0x33c13c5940 1115 package body APPS.WF_LOCAL_SYNCH
0x34406aa358 2426 package body APPS.FND_USER_PKG
0x40006ce618 1356 package body APPS.FND_WEB_SEC
0x40006ce618 1379 package body APPS.FND_WEB_SEC
0x40006ce618 1460 package body APPS.FND_WEB_SEC
0x40006ce618 1250 package body APPS.FND_WEB_SEC
0x3cc13b3018 436 package body APPS.FND_USER_PVT
0x3380290640 3903 package body APPS.ORACLEAPPS
0x3380290640 243 package body APPS.ORACLEAPPS
0x3cc140aa48 20 anonymous block

 

Cause

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