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 11.5.10.2
Information in this document applies to any platform.
OGL EPF Data Integration

Symptoms

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 <<Note:402464.1>> "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 <<Note:394494.1>> "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.

Cause

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