Unable To Settle Claim With AP Settlement If Customer Ref Number Is Greater Than 30 Chars (Doc ID 1924182.1)

Last updated on NOVEMBER 18, 2015

Applies to:

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

Symptoms

When attempting to settle claim with AP settlement, the following error occurs if Customer Reference Number is greater than 30 chars.

ERROR

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


STEPS TO REPRODUCE


The issue can be reproduced at will with the following steps:


1. Create a claim
2. Enter customer reference number more than 30 characters
3. save.
4. Go to lines and select any AP related settlement method
5. save.
6. Check if error is thrown during settlement.



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