R12:JL:AP: Cannot Cancel Payment Due to Errors APP-JL-62481 ORA-01722

(Doc ID 2365044.1)

Last updated on FEBRUARY 23, 2018

Applies to:

Oracle Financials for the Americas - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.0.0 version, Argentina Payables

When attempting to cancel an invoice,
the following error occurs.

APP-SQLAP-10000: ORA-6502: PL/SQL: numeric or value error: character string buffer too small
ORA-6512: at ''APPS.AP_WITHHOLDING_PKG line 5182
ORA-20001 APP-JL-62481: ORA-01722 no valid number JL_AR_AP_WITHHOLDING_PKG..JI_Ar_Ap_Undo_Withholding with
parameters (parent_id = 933929, calling_module = VOID PAYMENT, Undo_Awt_Date=2018/02/07)
while performing the following operation:
AP_VOID_PKG.AP_REVERSE_CHECK PERIOD_NAME = FEB-18, CHECKRUN_NAME = EXPO 07-02-18 ES 3,INVOICE_ACTION = NONE, HOLD_CODE = , HOLD_REASON = , LAST_UPDATED_BY = 4437, LAST_UPDATED_LOGIN = 38601887)
while performing the following operation:
Fetch from c_new_payments cursor'

The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables - Argentina localization
2. Path: Payments -> Entry -> Payments
3. Query a payment
4. Cancel the payment
When trying to cancel payment 24864 the following appears:

APP-SQLAP-10000: ORA-6502: PL/SQL: numeric or value error: character string buffer too small
ORA-6512: at ''APPS.AP_WITHHOLDING_PKG line 5182
ORA-20001 APP-JL-62481: ORA-01722 no valid number JL_AR_AP_WITHHOLDING_PKG..JI_Ar_Ap_Undo_Withholding with
parameters (parent_id = 933929, calling_module = VOID PAYMENT, Undo_Awt_Date=2018/02/07)
while performing the following operation:
AP_VOID_PKG.AP_REVERSE_CHECK PERIOD_NAME = FEB-18, CHECKRUN_NAME = EXPO 07-02-18 ES 3,INVOICE_ACTION = NONE, HOLD_CODE = , HOLD_REASON = , LAST_UPDATED_BY = 4437, LAST_UPDATED_LOGIN = 38601887)
while performing the following operation:
Fetch from c_new_payments cursor'

The issue has the following business impact:
Due to this issue, users cannot cancel the invoice

Changes

 

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