My Oracle Support Banner

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

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
  Symptoms
  Cause
  Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.