My Oracle Support Banner

Payment Upload UI - Payment File Is Not Getting Uploaded Due To Length Limitation On NAME1 Column (Doc ID 2356680.1)

Last updated on MARCH 06, 2019

Applies to:

Oracle Financial Services Revenue Management and Billing - Version and later
Information in this document applies to any platform.


Payment Upload UI - Payment file is not getting uploaded due to length limitation on NAME1 column

NAME1 has 40 char limitation on ci_pay_tender_st. We need to increase the size.

ORA-12899: value too large for column "CISADM"."CI_PAY_TNDR_ST"."NAME1" (actual: 41, maximum: 40)

- 2017-12-20 13:23:59,874 [pool-1-thread-4] ERROR (fileUpload.batch.CopyPreStagingPaymentDataBatch) HibernateException in getJobWork() of CopyPreStagingPaymentDataBatch :
org.hibernate.QueryTimeoutException: ORA-12899: value too large for column "CISADM"."CI_PAY_TNDR_ST"."NAME1" (actual: 41, maximum: 40)

at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(
at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(
at com.sun.proxy.$Proxy7.executeUpdate(Unknown Source)
at com.splwg.ccb.domain.payment.fileUpload.batch.CopyPreStagingPaymentDataBatch.insertStgPayTenderData(
at com.splwg.ccb.domain.payment.fileUpload.batch.CopyPreStagingPaymentDataBatch.getJobWork(

The issue can be reproduced at will with the following steps:
Payment Upload from UI

The issue has the following business impact:
Production Environment, Payments are not applied.. it is affecting open receivables and overdue process..creating so much confusion at customer end.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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