OGL EPF: Bad Value Set Id Causes Ora-20001 No Message Found Running Dimension Rule (Doc ID 473097.1)

Last updated on DECEMBER 02, 2008

Applies to:

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

Symptoms

After applying the FEM.D.1 Rollup #3 patch and a file from development provided for <<Bug:6367995>>, when you re-run the General Ledger (GL) to Enterprise Performance Foundation (EPF) dimension transfer rules, one of the dimension rules fails. The following error is in the Concurrent Manager View Log:

Initializing global variables.
ORA-20001:
No message found
Process registration has failed.

The FND: Debug output in FND_LOG_MESSAGES shows the following additional error:

ORA-00001: unique constraint (FEM.FEM_VALUE_SETS_B_U1) violated
ORA-01403: no data found
Calling FEM_VALUE_SETS_PKG.insert_row with
X_VALUE_SET_ID => 12007
X_DEFAULT_LOAD_MEMBER_ID => NULL
X_DEFAULT_MEMBER_ID => NULL
X_OBJECT_VERSION_NUMBER => 1
X_DEFAULT_HIERARCHY_OBJ_ID => NULL
X_READ_ONLY_FLAG => N
X_VALUE_SET_DISPLAY_CODE => Operations Product:DIM:3
X_DIMENSION_ID => 3
X_VALUE_SET_NAME => Operations Product:DIM:3
X_DESCRIPTION => Operations Product:DIM:3

Several different dimensions get can get this error.

Steps To Reproduce:

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