OZF_CLAIMS_ALL.PAYMENT_REFERENCE_NUMBER Column Size Issue (Doc ID 1983152.1)

Last updated on FEBRUARY 27, 2015

Applies to:

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

Symptoms

Users are not able to settle claim with AP settlement if Customer Reference Number is greater than 30 chars.  The following error is encountered:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package OZF_AP_INTERFACE_PVT Procedure Create_ap_invoice

There is a legislative requirement to have the column size set to VARCHAR(50)


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms