ORA-00001: Unique Constraint (FEM.FEM_NAT_ACCTS_B_PK) Violated Error Running Dimension Member Loader (Doc ID 1365235.1)

Last updated on MARCH 06, 2013

Applies to:

Oracle Profitability Manager - Version 11.5.10 and later
Oracle Enterprise Performance Foundation - Version 11.5.10 and later
Information in this document applies to any platform.
Dimension Member Loader

Symptoms

In Enterprise Performance Foundation Administrator 11i, after populating the FEM environment using the Bulk/Mass Migration process, the Dimension Member Loader program ends with an error.  When you check the Request's View Log, the following error exists in one of the sub-requests for the Natural Account dimension member:

An unexpected error has occurred: ORA-00001: unique constraint (FEM.FEM_NAT_ACCTS_B_PK) violated. Please contact your System Administrator.

Parent request 778363
Sub-request 778365 encountered an unexpected error and could not continue.
User-Defined Exception

You get the same error for other dimensions also (ex. Company Cost Center Org).

As a result of the error, new dimension members are not loaded.  Un-loaded rows exist in the staging table FEM_NAT_ACCTS_B_T.

All required unique indexes exist on the base FEM_NAT_ACCTS_B table and the staging FEM_NAT_ACCTS_B_T table.

Note: Unpublished Document ID 752221.1 "Mass Profitability Manager Mapping Rule and Dimension Migration" describes the Bulk Migration process recently used to refresh the FEM environment.

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