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
FEM
This problem can occur on any platform.

Symptoms

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:

ERROR
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'.

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

FEM_HIERARCHIES_T
FEM_USER_DIM2_HIER_T
FEM_HIER_VALUE_SETS_T

2. Run the Dimension Hierarchy Loader

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