When Increasing Quantity in Material Requirement and save, Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.AHL_PP_MATERIALS_PVT_W" (Doc ID 2873620.1)

Last updated on DECEMBER 27, 2023

Applies to:

Symptoms

Problem Statement:
When increasing the quantity in Material requirement and saving, getting error.

Error
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.AHL_PP_MATERIALS_PVT_W", line 140 ORA-06512: at "APPS.AHL_PP_MATERIALS_PVT_W", line 1093 ORA-06512: at line 1

Steps:
Navigate to the CMRO Super user --> Production Planning --> Material Requirements
Query the Material requirement and try to increase the quantity and save, the error appears.

Changes

Cause

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