R12: Payments Cannot Be Marked As Complete - Error With Callout To AP_PMT_CALLOUT_PKG

(Doc ID 1630483.1)

Last updated on MARCH 05, 2018

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.


PPP configured for Manual Completion of Payments.

When Completing the Payments

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

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
with parameters (Complted Payments Group id = 3878)
while performing the following operation:
insert into ap_checks_all"


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