Error ORA-06502 Displayed When Generating Least Cost Formulation (LCF) (Doc ID 2259634.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Process Manufacturing Product Development - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Other Issues

Items and technical parameters were created plus other setups for Least Cost Formulation (LCF). When generating a formula using LCF Formulation, the following message appears. After clearing the message, the Simulator window appears, showing the technical parameters.

ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package GMD_LCF_FETCH_PKG Procedure Load_Tech_Values

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create items, technical parameters, plus other setups for Least Cost Formulation (LCF)
2. Generate Formula
3. Select 'OK', Simulator window appears, showing the technical parameters.

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