Unexpected Error Message When Going to Table Processing Key Page

(Doc ID 343130.1)

Last updated on NOVEMBER 05, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.
FEM

Symptoms

When trying to register or update the FEM_BALANCES table in the Enterprise Performance Foundation Administrator responsibility at "Administration" → "Registration" → "Objects and Columns", the following error occurs after filling in the Display Names in the "Table Column Display Names" step and clicking on "Save and Next":

You have encountered an unexpected error. Please contact the System Administrator for assistance.

The "Table Processing Key" page never appears. The error prevents the FEM_BALANCES table from being registered.

The following errors appear if the System Profile value for "FND: Diagnostics" is set to "Yes" and the error is triggered. Going to the "Click here for exception details" link shows the following error:

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.FND_MSG_PUB", line 279
ORA-06512: at "APPS.FEM_TABLE_REGISTRATION_PKG", line 1421
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1

Steps to replicate:

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