Receiving Missing Root Node Error Message Attempting To Load New Hierarchy Using The Dimension Hierarchy Loader
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.
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
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