OGL EPF: ORA-00001 Running Balance Rule - Multiple Unique Indexes
Last updated on MAY 08, 2009
Applies to:Oracle Enterprise Performance Foundation - Version: 11.5.10 to 18.104.22.168
This problem can occur on any platform.
OGL EPF Data Integration
In Enterprise Performance Foundation Administrator 11i, when running a Balance Rule that transfers data from Oracle General Ledger (GL) to Enterprise Performance Foundation (FEM), the rule request fails and the following error is in the concurrent View Log:
ORA-00001: unique constraint (FEM.FEM_BALANCES_P1) violated.
Please contact your system administrator.
The error prevents GL records from being transferred into FEM_BALANCES.
Steps To Reproduce:
- Go to the Enterprise Performance Foundation Administrator responsibility
- Go to Data Rules > Oracle Data Sources > GL Balances
- Create and run a balance rule
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