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 11.5.10.2
This problem can occur on any platform.
OGL EPF Data Integration
FEM

Symptoms

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:

  1. Go to the Enterprise Performance Foundation Administrator responsibility
  2. Go to Data Rules > Oracle Data Sources > GL Balances
  3. Create and run a balance rule

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