'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:
This problem can occur on any platform.
Dimension Hierarchy Migration


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

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'


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