Ozf_resale_pub.Create_resale_utilization Failing With Ora-06502: Pl/Sql: Numeric Or Value Error
(Doc ID 1437177.1)
Last updated on JUNE 09, 2021
Applies to:Oracle Trade Management - Version 12.1.2 and later
Information in this document applies to any platform.
<Patch 13333298> was applied in R12.1.3 environment.
After applying this patch, you try calling the new public API OZF_RESALE_PUB.Create_resale_utilization to create what we term "off-invoice" records.
When you were testing the API it was not creating the data. The error message returned was the following:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package OZF_RESALE_PUB Procedure Create_resale_utilization
After manually debugging the procedure, it was discovered that the variables were hard coded to specific lengths and not using the standard of TABLE_NAME.column_name%TYPE.
The variable in particular failling our program is l_offer_name. It is defined as a VARCHAR(30) when in fact the table definition of QP_LIST_HEADERS_TL.DESCRIPTION is a VARCHAR2(2000).
We have over 82,000 promotions in OTM where the description length exceeds 30 characters. The variables should not be hard coded; they should be based on the table columns.
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