OGL EPF: Hierarchy Rule Completes Successfully but No Members Assigned in FEM_xxxxx_HIER Table
(Doc ID 352560.1)
Last updated on AUGUST 24, 2007
Applies to:Oracle Enterprise Performance Foundation - Version: 11.5.9 to 11.5.10
Oracle Enterprise Planning and Budgeting - Version: 11.5.9 to 11.5.10
This problem can occur on any platform.
OGL EPF Integration
When trying to make a "Business Area" effective in Enterprise Planning and Budgeting (EPB), the following error occurs:
"The Hierarchy for Rule Organization Hierarchy default hierarchy has no members associated"
The Organization Hierarchy Rule was run successfully in Enterprise Performance Foundation Administrator from the following screen: "Data Rules" → "Oracle Dimension Sources" → "Chart of Accounts" → "Organization" → "Define Hierarchy Rules".
The View Log for the Hierarchy Rule shows the rule ran successfully:
Creating dimension attributes.
Process registration completed successfully.
Concurrent request completed successfully
However, the dimension hierarchy table, FEM_xxxxx_HIER, contains 0 rows.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
Checked for relevance on 24-Aug-2007.