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

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

PPP configured for Manual Completion of Payments.

When Completing the Payments

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 and Review the messages provides the following additional information...


IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:Fatal: External app
callout '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

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