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 SEPTEMBER 24, 2024

Applies to:

Oracle Payables - Version 12.1.1 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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.