OGL EPF : Dimension Rule Failed with ORA-00060 Deadlock Detected (Doc ID 356428.1)

Last updated on NOVEMBER 21, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.
OGL EPF Direct Integration
FEM

Symptoms

While running Dimension Rules submit all, received the following error on some of the dimensions.

ERROR
Processing assign single value mapping(s).
ORA-00060: deadlock detected while waiting for resource

STEPS
1. Go to EPF Administration -->Data Rules-->Oracle Dimension Sources
2. Submit All Rules.

Example: Concurrent manager log for Channel Dimension Rule shows the following error:

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Initializing global variables.
Assigning the value set 13 to the Dimension Rule version 10431.
Populating mapping table.
Processing assign single value mapping(s).
ORA-00060: deadlock detected while waiting for resource
No message found
Process registration has failed.
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

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