OGL EPB: Cannot Assign Ledger & Cannot See Oracle General Ledger Classification
Last updated on MAY 26, 2017
Applies to:Oracle Enterprise Performance Foundation - Version 11.5.10 to 126.96.36.199 [Release 11.5]
Information in this document applies to any platform.
OGL EPB Integration
In Enterprise Performance Foundation Administrator, in "Data Rules" > "Oracle Ledger Assignments", you cannot assign a Ledger or use any screens under "Data Rules". The following error occurs:
"Please assign dimensions to all user dimension columns in FEM_BALANCES and enable the table classification Oracle General Ledger prior to using this feature."
However, when you go to assign the classification to FEM_BALANCES at "Administration" > "Registration" > "Tables and Columns", you cannot see an "Oracle General Ledger" classification in the list of available table classifications.
This is preventing you from implementing the Oracle General Ledger transfer rules.
Navigation to table classification screen:
- Go to Enterprise Performance Foundation Administrator
- Go to Administration > Registration > Tables and Columns
- Search for "FEM_BALANCES"
- Click on "Update"
- Click on "Save and Next" until you reach the Table Classifications screen
Applied FEM.D.1 Rollup #2 patch 5560579.
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