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 OCTOBER 17, 2016

Applies to:

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

Symptoms

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

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

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

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