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




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