Object Migration Failed with Error in Migrating Hierarchy Definition (Doc ID 2137544.1)

Last updated on MAY 12, 2016

Applies to:

Oracle Financial Services Asset Liability Management - Version 6.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.5.1.0 and later
Oracle Financial Services Profitability Management - Version 6.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 7.3.5.1.0 version, All Common Apps

When attempting to run object migration for a General Ledger Hierarchy the following error occurs.

Error

REV_MIG_LOG:
Started Migrating Object..[id:201758,name:SBS_HIER,type:5,Source Folder:RNT,Target Folder:RNT]
Hierarchy Migration Error - com.ofs.reveleus.migration.util.MigrationException: Error In Migrating Hierarchy Defintion
Failed Migrating Object..[id:201758,name:SBS_HIER,type:5,Source Folder:RNT,Target Folder:RNT]
Migration Completed With Errors.Number Of Objects Failed to Migrate is ...1

Fusionsubsystemsservice.log:
[HIERARCHYMIGRATIONSERVICE]Status of Hierarchy Add/Update operation..[errorFlag:true,Code:ORA_1_ERROR,Description:Unique constraint on Hierarchy Name]
[HIERARCHYMIGRATIONSERVICE]Exception occurred while trying to get Migration Hierarchy.com.ofs.reveleus.migration.util.MigrationException: Error In Migrating Hierarchy Defintion

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