R12: Payments Cannot Be Marked As Complete - Error With Callout To AP_PMT_CALLOUT_PKG (Doc ID 1630483.1)

Last updated on FEBRUARY 27, 2025

Applies to:

Symptoms

PPP configured for Manual Completion of Payments.
When completing the Payments, the following error is received:

Error
Payments Cannot Be Marked Complete Because An Error Was Returned By The

Callout
AP_PMT_CALLOUT_PKG.payments_completed.

There is no information provided back to the user regarding the reason for the failure.

Enable FND Debug, see the following additional information:

IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:Fatal: External appcallout 'AP_PMT_CALLOUT_PKG.payments_completed', generated exception.
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:SQL code: -20001 "IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:SQL err msg: ORA-20001: APP-SQLAP-10000: ORA-12899: value too large for column
"AP"."AP_CHECKS_ALL"."BANK_ACCOUNT_NUM" (actual: 31, maximum: 30) occurred in AP_PMT_CALLOUT_PKG.payments_completed with parameters (Complted Payments Group id = 3878)
while performing the following operation: insert into ap_checks_all"

Cause

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