ORA-06502: PL/SQL: Numeric or Value Error on Mapping Rule With Large Hierarchy Comp (Doc ID 756873.1)

Last updated on MAY 08, 2009

Applies to:

Oracle Profitability Manager - Version: 11.5.10 to 12.0.6
Oracle Enterprise Performance Foundation - Version: 11.5.10 to 12.0.6
This problem can occur on any platform.

Symptoms

In Profitability Manager (PFT), a Mapping Rule with a hierarchy dimension component containing many "Node Only" values is ending with an error.  The following errors appear in the concurrent request View Log and Output Log:

View Log errors:

Assertion failed: FALSE, file fem/lib/FCFilterCond.cpp, line 355
/u01/app/vision/visappl/fem/11.5.0/bin/FEMCCE
Program was terminated by signal 6

Output Log errors:

APP-FEM-416323: An unhandled error has occurred while processing the condition: ORA-06502: PL/SQL: numeric or value error: character string buffer too small. Please contact your system administrator for more information.

Go to the following screen to review the dimension component:

There are many rows with Relation = Node Only.

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