My Oracle Support Banner

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

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