Receiving Missing Root Node Error Message Attempting To Load New Hierarchy Using The Dimension Hierarchy Loader

(Doc ID 367523.1)

Last updated on NOVEMBER 27, 2008

Applies to:

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


On 11.5.10 when attempting to use the Dimension Hierarchy Loader to load a new hierarchy, the
following error occurs in the Concurrent Log:

A validation exception occurred when processing records in the FEM_HIERARCHIES_T hierarchy
interface table. Please refer to the STATUS column on this table for further information on the
validation exception.
The execution produced errors. Correct the errors and rerun.

The STATUS column in FEM_HIERARCHIES_T has a status of 'MISSING ROOT NODE'.

The issue can be reproduced at will with the following steps:
1. Populate the following tables:


2. Run the Dimension Hierarchy Loader


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