OGL EPF: ORA-00001 Running Balance Rule - Multiple Unique Indexes
(Doc ID 811163.1)
Last updated on MAY 08, 2009
Applies to:Oracle Enterprise Performance Foundation - Version: 11.5.10 to 184.108.40.206
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document