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.
When attempting to settle claim with AP settlement, the following error occurs if Customer Reference Number is greater than 30 chars.
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
4. Go to lines and select any AP related settlement method
6. Check if error is thrown during settlement.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms