ORA-00001: Unique Constraint (FEM.FEM_NAT_ACCTS_B_PK) Violated Error Running Dimension Member Loader
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
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.
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.
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