Payment With Bank Account Number More Then 30 Characters (Doc ID 2121591.1)

Last updated on APRIL 10, 2017

Applies to:

Oracle Fusion Payments Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

When creating a payment, the following error occurs:

ERROR Code :-12899
ERROR Msg :ORA-12899: value too large for column "FUSION"."AP_CHECKS_ALL"."BANK_ACCOUNT_NUM" (actual: 31, maximum: 30)
AP.PLSQL.AP_PMT_CALLOUT_PKG..payments_completed-insert into ap_checks_all - 2016-02-29 08:13:05.392904000 +00:00
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: Application error ORA-12899: value too large for column "FUSION"."AP_CHECKS_ALL"."BANK_ACCOUNT_NUM" (actual: 31, maximum: 30) occurred while performing operation insert into ap_checks_all with parameters Complted Payments Group id = 1261 i

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