OGL EPF : All Code Combinations Not Mapped Error Running Balance Rule and Intercompany Dimension Rule Fails on FEM.D.1 Rollup #2 (Doc ID 412869.1)

Last updated on JULY 23, 2009

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10.2 to 11.5.10.2
This problem can occur on any platform.
OGL EPF Data Integration
FEM

Symptoms

On FEM.D.1 Rollup #2 in 11.5.10.2 in when attempting to run a Balance Rule, the following error occurs:

ERROR
Loading standard balances
All code combinations for chart of accounts <XXXX> ACCOUNTING FLEXFIELD have not been mapped properly to the account-based dimensions.

After further investigation, the following error message was found in the Intercompany Dimension Rule log file:

Initializing global variables.
Assigning the value set 12017 to the Dimension Rule version 10041.
Processing assign single value mapping(s).
Kicking off 32 workers requests at 23-JAN-2007 14:52:15
Dimension Rule Worker Error:
No message found
Process registration has failed
.

The failing Intercompany Dimension Worker log file has the following message:

**Starts**23-JAN-2007 14:51:53
ORACLE error 1747 in FDPSTP

Cause: FDPSTP failed due to ORA-01747: invalid user.table.column, table.column, or column specification
ORA-06512: at "APPS.FEM_INTG_NEW_DIM_MEMBER_PKG", line 4933
ORA-06512: at line 1
.

The SQL statement bein
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
<< Start of mapping table update worker >>
p_Worker_Id : 1
p_coa_id : 50166
p_gvsc_id : 10000
p_Num_Workers : 32
p_Worker_Id : 1
p_max_ccid_processed : -1
p_max_ccid_to_be_mapped : 647064
Processing rowid from AAF7dcAIkAABAUJAAA to AAF7dcAIkAABAWICcP

Worker Error ORA-01747: invalid user.table.column, table.column, or column specification
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


A query on FEM_INTG_OGL_CCID_MAP table reveals -1 values in several dimension columns.

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