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:
Oracle Financial Services Revenue Management and Billing - Version 2.9.0.0.0 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Changes |
Cause |
Solution |
References |