OGL EPF : ORA-00001 Unique Constraint on Line Item and Natural Account Running Dimension Rules First time (Doc ID 389947.1)

Last updated on AUGUST 27, 2007

Applies to:

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

Symptoms

Users are getting the following error message when running Dimension Rules for the first time:

Natural Accounts:
Initializing global variables.
Assigning the value set 10001 to the Dimension Rule version 10067.
Processing single segment mapping(s).
Unexpected error has occurred: ORA-00001: unique constraint
(FEM.FEM_NAT_ACCTS_TL_U1) violated.
Please contact your system administrator.

and

Line Item:
Initializing global variables.
Assigning the value set 10002 to the Dimension Rule version 10069.
Processing single segment mapping(s).
Unexpected error has occurred: ORA-00001: unique constraint (FEM.FEM_LN_ITEMS_TL_U1) violated.
Please contact your system administrator.

Navigation path: Logged into Apps --> Selected EPF Administrator Responsibility --> Selected Data Rules tab --> Assigned the Ledger and set the Ledger and Folder in Application Preferences --> Selected Oracle Dimension Sources subtab --> Mapped the OGL segments to the EPF dimensions --> Clicked on "Submit All Rules" button --> Monitored the concurrent requests.  Users found that two of the requests had failed. Upon reviewing the request logs found that the failed requests were for the LINE ITEM and NATURAL ACCOUNT dimensions.

Users have multiple languages enabled in APPS.

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