Payment Fail For Specific Vendor With Error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small"
Last updated on OCTOBER 17, 2016
Applies to:Oracle Payables - Version 11.0.3 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
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.
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