OGL EPF: Bad Value Set Id Causes Ora-20001 No Message Found Running Dimension Rule
Last updated on DECEMBER 02, 2008
Applies to:Oracle Enterprise Performance Foundation - Version: 22.214.171.124
This problem can occur on any platform.
OGL EPF Integration
After applying the FEM.D.1 Rollup #3 patch and a file from development provided for <
Initializing global variables.
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:
- Go to the Enterprise Performance Foundation Administrator responsibility
- Go to Data Rules > Oracle Dimension Sources > Chart of Accounts
- Click on the "Submit All Rules" button to run all of the dimension rules
- One dimension rule fails with the above errors
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