My Oracle Support Banner

Not Able To Save Offer Adjustment Due To The Error ORA-06502: PL/SQL: Numeric or Value Error: Character String Buffer Too Small (Doc ID 2866296.1)

Last updated on APRIL 29, 2022

Applies to:

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

Symptoms


In Trade Management, receive error for Accrual offer adjustment when adding market eligibility for a new line associated to attribute context.  When populating the 'Attribute Value From'
with more than 30 characters gives below error on save.


Error
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.OZF_OFFER_ADJUSTMENT_PVT_W", line 1316 ORA-06512: at line 1


Steps
The issue can be reproduced at will with the following steps:
1. Trade Management > Trade Planning > Offers
2. Select offer, goto offer adjustments screen
3. Create new adjustment to update market eligibility




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.