My Oracle Support Banner

When Creating An Offer Getting Error ORA-06502: PL/SQL: Numeric or Value Error: Character String Buffer Too Small in Package QP_Validate_Pricing_Attr Procedure Entity. (Doc ID 2811696.1)

Last updated on OCTOBER 01, 2021

Applies to:

Oracle Trade Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Offers

In Trade Management when creating an offer and updating the offer discount rules with a item category, upon clicking update the below error is seen.

  ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package QP_Validate_Pricing_Attr Procedure Entity.


ERROR
-----------------------

ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package QP_Validate_Pricing_Attr Procedure Entity.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Oracle Trade Management User > Trade Planning
2. Select Accrual Offer, add item category to discount rules
3. Click update (B)
4. Error

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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