OGL EPF: ORA-01407: cannot update ("FEM"."FEM_INTG_OGL_CCID_MAP"."LINE_ITEM_ID") to NULL with Dimension Rules (Doc ID 406897.1)

Last updated on OCTOBER 30, 2011

Applies to:

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

Symptoms

Users are getting the following error message when running Submit All for the Dimension Rules:

Enterprise Performance Foundation: Version : 11.5.0 - Development

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

FEM_INTG_DIM_RULE_WORKER module: Program - Enterprise Performance Foundation General Ledger Dimension Rule Worker
+---------------------------------------------------------------------------+
Current system time is 21-DEC-2006 15:15:48
+---------------------------------------------------------------------------+
**Starts**21-DEC-2006 15:15:48
ORACLE error 1407 in FDPSTP

Cause: FDPSTP failed due to ORA-01407: cannot update ("FEM"."FEM_INTG_OGL_CCID_MAP"."LINE_ITEM_ID") to NULL
ORA-06512: at "APPS.FEM_INTG_NEW_DIM_MEMBER_PKG", line 4932
ORA-06512: at line 1
.

The SQL statement
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
<< Start of mapping table update worker >>
p_Worker_Id : 4
p_coa_id : 50268
p_gvsc_id : 10004
p_Num_Workers : 16
p_Worker_Id : 4
p_max_ccid_processed : -1
p_max_ccid_to_be_mapped : 14218
Processing rowid from AAB4BrAGSAAAT/5AAA to AAB4BrAGSAAAUAICcP

Worker Error ORA-01407: cannot update ("FEM"."FEM_INTG_OGL_CCID_MAP"."LINE_ITEM_ID") to NULL
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...

Finished executing request completion options.
+---------------------------------------------------------------------------+
Exceptions posted by this request:
Concurrent Request for "Program - Enterprise Performance Foundation General Ledger Dimension Rule Worker" has completed with error.

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