'Hierarchy Does Not Exist On Source System' Error Running Dimension Hierarchy Migration (Doc ID 604707.1)

Last updated on NOVEMBER 24, 2008

Applies to:

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

Symptoms

-- Problem Statement:
On 11.5.10.2 in Production:
When attempting to migrate a Hierarchy from the Target instance into the Source instance, the
following error occurs:

ERROR
Migrating Hierarchy...
The Hierarchy <My Hierarchy Name> does not exist in the source system.

It is confirmed that the database link is functional and registered correctly.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Login to Source instance
2. Run the 'Dimension Hierarchy Migration'

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