My Oracle Support Banner

OGL EPF: Balance Rule Code Combinations Not Properly Mapped - After All GL Data Fixed (Doc ID 409193.1)

Last updated on FEBRUARY 15, 2010

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10 to
Information in this document applies to any platform.
OGL EPF Data Integration


In Enterprise Performance Foundation Administrator, when running the program "Program - Enterprise Performance Foundation General Ledger Balances Rule Engine" to transfer GL balances into the FEM_BALANCES table, the following error appears in the View Log:

Loading standard balances
All code combinations for chart of accounts <Chart of Account Name> have not been mapped properly to the account-based dimensions.

All dimension rules and hierarchy rules had been run successfully.

You then identify the inconsistent data in Oracle General Ledger (GL) triggering the error and fix the GL data issue.  However, when you re-run the Balance Rule program, the same error occurs again.  There are still rows in the FEM_INTG_OGL_CCID_MAP table with -1 values for some dimensions.

You run the fem_gl_data_check.sql from MetaLink <> "OGL EPF: Balance Rule Code Combinations Not Properly Mapped - All Dimensions Have -1 Values Due to Bad GL Data" and no rows are returned by the script.  You also follow the troubleshooting steps in <> "OGL EPF: How to Troubleshoot the Balance Rule "Unmapped Accounts" Error" but cannot identify any inconsistent data in GL.  All data issues have been fixed.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.