Cannot Save Formula With Calculate Product Qty Flagged Checked GMD_FORMULA_DETAIL_PUB Procedure Insert_formuladetail

(Doc ID 1187185.1)

Last updated on AUGUST 05, 2016

Applies to:

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


On 12.1.1and above, when creating a new formula with Calculate Product Quantity checked, the system does not allow the save and error message is received:
ORA06502: PL/SQL: numeric or value error: character string
buffer too small in package GMD_FORMULA_DETAIL_PUB Procedure INSERT_FORMULADETAIL

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Set Product Development Parameter "Automatic Product Quantity Calculation" = yes. Create a new
formula with Calculate Product Quantity flagged. Save. The system gives the Error message
Formulator > Formula


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