OGL EPF: Hierarchy Rule Completes Successfully but No Members Assigned in FEM_xxxxx_HIER Table
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.
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