OGL EPF: Balance Rule Code Combinations Not Properly Mapped After Fixing Summary Flag (Doc ID 889882.1)

Last updated on OCTOBER 22, 2012

Applies to:

Oracle Enterprise Performance Foundation - Version 11.5.9 to 12.0.6 [Release 11.5 to 12]
Information in this document applies to any platform.
OGL EPF Data Integration
Checked for relevance on 05-Sep-2012.

Symptoms

In Enterprise Performance Foundation Administrator, you are trying to run a General Ledger (GL) to FEM_BALANCES balance transfer rule for Budget data.  The balance rule fails and the following error is in the Output Log:

The balances load cannot proceed because some code combinations of chart of accounts Operations Accounting Flex 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.

The following is the list of unmapped accounts:

Unmapped Account
----------------------------------------------------------------------------------------------------
01-000-1000-0000-000



You used My Oracle Support Doc ID <Note 394494.1> "OGL EPF: How to Troubleshoot the Balance Rule "Unmapped Accounts" Error" to determine the cause of the error.  Account "01-000-1000-0000-000" is for Code Combination ID: 16402. The following data corruption exists in GL:

In FND_FLEX_VALUES, the "1000" value has SUMMARY_FLAG = 'Y'.
In GL_CODE_COMBINATIONS, this code combination has SUMMARY_FLAG = 'N'.

You try to resolve the issue by updating the SUMMARY_FLAG to 'Y' in GL_CODE_COMBINATIONS, removing the related Code Combination ID row from FEM_INTG_OGL_CCID_MAP, resetting the max_ccid_processed column in FEM_INTG_DIM_RULE_DEFS to -1, and re-running the dimension rules (as described in INTERNAL Note 377053.1 "OGL EPF Balance Rule Code Combinations Not Properly Mapped - Summary Flag Incorrect Manual Fix").  However, after performing all of these steps, you still get the same error when running the Budget GL-FEM Balance transfer rule.

Steps To Reproduce:

  1. Go to the Enterprise Performance Foundation Administrator responsibility
  2. Go to Data Rules > Oracle Data Sources
  3. Select the Vision Operations (USA) Ledger
  4. Run the Balance Rule

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