ORA-00001: unique constraint (FEM.FEM_HIER_VALUE_SETS_T_PK) Error Running Dimension Hierarchy Migration (Doc ID 844611.1)

Last updated on JUNE 18, 2009

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
FEM
Dimension Hierarchy Migration
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 11.5.10 in when attempting to run the Dimension Hierarchy Migration from Source to Target the following error occurs:

ERROR
ORACLE error 1 in FDPSTP

Cause: FDPSTP failed due to ORA-00001: unique constraint (FEM.FEM_HIER_VALUE_SETS_T_PK)
violated
ORA-06512: at "APPS.FEM_DIMENSION_MIGRATION_PKG", line 2915
ORA-06512: at "APPS.FEM_DIMENSION_MIGRATION_PKG", line 3177
ORA-06512:

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Made sure dates we set properly on target instance to accept the effective date range of the hierarchy being migrated
2. Ensured needed dimension members were enabled in target
3. Logged into target environment and executed "Dimension Hierarchy Migration" from target instance with the following paramaters:
a.Database Link active and confirmed working
b. Dimension - Company Cost Center Organization
c. Hierarchy Name - Cost Center Categorization
d. Hierarchy Version Name - 06012009081903
e. Submitted this process in target instance and received the error.

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