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.
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.
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
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
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