My Oracle Support Banner

R12: AP: Payment Fail For Specific Vendor With Error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" (Doc ID 1638210.1)

Last updated on DECEMBER 07, 2020

Applies to:

Oracle Payables - Version 12.1.1 and later
Information in this document applies to any platform.


 On R12.1.3,When attempting to create single payment on payment workbench for one specific vendor
the following error occurs.

Exception occured when performing Payment creation

Debug log:

IBY_DISBURSE_SINGLE_PMT_PKG.submit_single_payment       : Exception occured when building payments. Payment creation will be aborted and no payments w
IBY_DISBURSE_SINGLE_PMT_PKG.submit_single_payment       : SQLCODE: -6502
IBY_DISBURSE_SINGLE_PMT_PKG.submit_single_payment       : SQLERRM: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

The issue can be reproduced at will with the following steps:
1. Log in Payables responsibility
2. Navigate to Payment->Payment workbench
3. Create single payment with required information for specific vendor
4. Enter/Adjust invoices and try to save.




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.