My Oracle Support Banner

R12: AP/IBY: During Void Payment Got Error - 'APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: character string buffer too small occurred in AP_VOID_PKG.AP_REVERSE_CHECK' (Doc ID 2965121.1)

Last updated on AUGUST 01, 2023

Applies to:

Oracle Payables - Version 12.1.3 to 12.2.12 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to void a check,
the following error occurs.

APP-SQLAP-10000: ORA-06502: PL/SQL: numeric or value error: character string buffer too small occurred in AP_VOID_PKG.AP_REVERSE_CHECK<-APXPAWKB with parameters (, CHECK_ID = XXXXXXXXX, REPLACE_FLAG = N, REVERSAL_DATE = DD-MON-YY, PERIOD_NAME =MON-YY, CHECKRUN_NAME = Quick Payment: ID=YYYYYYYY, INVOICE_ACTION = NONE, HOLD_CODE = , HOLD_REASON = , LAST_UPDATED_BY = YYYYY, LAST_UPDATED_LOGIN = YYYYYYYYYY) while performing the following operation: Fetch from c_new_payments cursor


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Payables responsibility>Payments>Entry
2. Query the payment
3. Click on Actions>Void>ok

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
References


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