Payment Upload UI - Payment File Is Not Getting Uploaded Due To Length Limitation On NAME1 Column

(Doc ID 2356680.1)

Last updated on FEBRUARY 02, 2018

Applies to:

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

Symptoms

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.


ERROR
-----------------------
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(SQLStateConversionDelegate.java:156)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at com.sun.proxy.$Proxy7.executeUpdate(Unknown Source)
at com.splwg.ccb.domain.payment.fileUpload.batch.CopyPreStagingPaymentDataBatch.insertStgPayTenderData(CopyPreStagingPaymentDataBatch.java:288)
at com.splwg.ccb.domain.payment.fileUpload.batch.CopyPreStagingPaymentDataBatch.getJobWork(CopyPreStagingPaymentDataBatch.java:149)
at com.splwg.base.support.batch.JavaJobExecuter$1.execute(JavaJobExecuter.java:301)


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

BUSINESS IMPACT
-----------------------
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.

Changes

 

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