Payment File Reupload Failing when re-uploading the payment file with same name by checking the checkbox 'override existing file' on payment upload screen (Doc ID 2721271.1)

Last updated on OCTOBER 28, 2020

Applies to:

Symptoms

On : 2.9.0.0.0 version, ENV - Environment

ACTUAL BEHAVIOR
---------------------
Payment File reupload failing in RMB 2900

Payment upload is a RMB feature available in RMB 2900. But when customer tries to re-upload payment file with same name by checking the checkbox 'override existing file' on payment upload screen, system is error out and file upload UI remains in loading status.

Below error is thrown from in the logs:

SYSUSER - 254541-904-1 2020-09-11 10:11:18,059 [[ACTIVE] ExecuteThread: '27' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR (fileUpload.servlet.PaymentFileUploadServlet) Error in doPost() :
com.splwg.shared.common.LoggedException: Error executing iterate for rawSQL:
  SELECT pay_hstg_id FROM CI_UPLPAY_STG WHERE pay_hstg_id= (SELECT pay_hstg_id FROM CI_UPLPAY_HSTG WHERE trim(file_name) = trim(?) ) and pay_stg_stat_flg=? /* Select Header ID */
 with 'string' parameter named 'fileName' to : 'Payment_Upload_Multiple_Accounts_5 ' to indices: 1
 with 'string' parameter named 'status' to : 'INVL' to indices: 2

Logs indicates above SQL is triggered from below product code:
at com.splwg.ccb.domain.payment.fileUpload.service.PaymentFileParserService.checkInvalidRecords(PaymentFileParserService.java:281) ~[spl-ccb-2.9.0.0.0.jar:?]

EXPECTED BEHAVIOR
-----------------------
Error should not be thrown.

Changes

Cause

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