"Unexpected Error" When Registering A View in EPF R12 Rollup #3 (Doc ID 553997.1)

Last updated on FEBRUARY 18, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 12.0.3
This problem can occur on any platform.
Table Registration
Data Inspector

Symptoms

-- Problem Statement:
On 12.0.3, when attempting to register a view for use within Data Inspector to view the dimension display names instead of the dimension ID numbers, after clicking Save and Next on the Object Column Display Names (Step 1), the following error occurs:

ERROR
You have encountered an unexpected error. Please contact your System Administrator.

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-12899: value too large for
column "FEM"."FEM_TAB_INFO_GT"."TABLE_NAME" (actual: 69, maximum: 30)
ORA-06512: at "APPS.FEM_TABLE_REGISTRATION_PKG", line 2103
ORA-06512: at line 1

Requery on the object shows the view is shown as a Registered Object with a Registered Status of
"Incomplete". Any attempt to Update leads to the same error.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Administration-> Objects and Columns->Create->View-> Object Column Display
Names-> Save and Next

Error is thrown:
You have encountered an unexpected error. Please contact your System Administrator.

Diagnostic details of error show:

Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-12899: value too large for
column "FEM"."FEM_TAB_INFO_GT"."TABLE_NAME" (actual: 69, maximum: 30)
ORA-06512: at "APPS.FEM_TABLE_REGISTRATION_PKG", line 2103
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:980)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)

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