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
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