My Oracle Support Banner

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.


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
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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.