Updating or Entering a Price List Line for an Item Category Errors: ORA-06502: "buffer too small in Package QP_Validate_pll_pricing_attr Procedure Entity"
(Doc ID 2709339.1)
Last updated on JULY 18, 2022
Applies to:Oracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.
ORA-06502: buffer too small in Package QP_Validate_pll_pricing_attr Procedure Entity
When one tries to enter an Item category on a price list line, the below error is shown.
if the price list already has a price list line for item category.
Price list setup form shows error:
ORA-06502: PL/SQL: numeric value or Value error: character string
buffer too small in Package QP_Validate_pll_pricing_attr Procedure Entity
The issue can be reproduced at will with the following steps:
1. Navigate to Oracle Pricing Super User responsibility
2. Price Lists > Price list Setup
3. Query the Price List
4. Navigate to List Lines > Select product attribute as Item Category, Issue arises.
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