OGL EPB Balance Rule Code Combinations Not Properly Mapped - Non-Processing Key Columns Have -1 Values (Doc ID 401133.1)

Last updated on NOVEMBER 24, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.
FEM.D.1 Rollup #1
OGL EPB

Symptoms

In Enterprise Performance Foundation Administrator, the General Ledger Balance rules (Program - Enterprise Performance Foundation General Ledger Balances Rule Engine) are failing with the following error:

The balances load cannot proceed because some code combinations of chart of accounts Accounting Flexfield have not been mapped properly to the account-based dimensions. Please run the dimension rules for this chart of accounts to update the dimension mapping.

In the FEM_INTG_OGL_CCID_MAP table, all dimension columns that are NOT mapped from General Ledger and are NOT included in the processing key of FEM_BALANCES contain a "-1" value for all rows instead of a default value.


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