Getting Import Error When Uploading A Bank Statement (Doc ID 2593500.1)

Last updated on FEBRUARY 19, 2024

Applies to:

Symptoms

On : 11.13.19.04.0 version, Manage Banking-Manage Bank Statements

When attempting to run the Bank Statement import,the program completed with error.

ERROR
-----------------------
oracle.apps.financials.payments.shared.util.publicModel.common.util.CodePoint::sun.reflect.NativeMethodAccessorImpl.invoke0(-2)
oracle.apps.financials.payments.shared.util.publicModel.common.util.CodePoint::sun.reflect.NativeMethodAccessorImpl.invoke(57)
oracle.apps.financials.payments.shared.util.publicModel.common.util.CodePoint::sun.reflect.DelegatingMethodAccessorImpl.invoke(43)
oracle.apps.financials.payments.shared.util.publicModel.common.util.CodePoint::java.lang.reflect.Method.invoke(606)
oracle.apps.financials.payments.shared.util.publicModel.common.util.CodePoint::oracle.apps.financials.payments.shared.util.publicModel.common.util.CodePoint.invokeJava(257)
oracle.apps.financials.payments.shared.util.publicModel.common.util.CodePoint::oracle.apps.financials.payments.shared.util.publicModel.common.util.CodePoint.invoke(211)
oracle.apps.financials.payments.shared.util.publicModel.common.util.CodePoint::oracle.apps.financials.payments.sharedSetup.transmissions.publicModel.entity.TransmissionConfigurationEOImpl.transmit(569)
oracle.apps.financials.payments.shared.util.publicModel.common.util.CodePoint::oracle.apps.financials.payments.sharedSetup.transmissions.publicModel.entity.TransmissionConfigurationEOImpl.transmit(534)
oracle.apps.financials.payments.shared.util.publicModel.common.util.CodePoint::oracle.apps.financials.payments.shared.inboundFile.protectedModel.entity.InboundFileEOImpl.fetchFile(268)
oracle.apps.financials.payments.shared.util.publicModel.common.util.CodePoint::oracle.apps.financials.payments.shared.inboundFile.controlService.view.InboundFileVORowImpl.fetchFile(132)
oracle.apps.financials.payments.shared.util.publicModel.common.util.CodePoint::oracle.apps.financials.cashManagement.bankStatements.loaderService.applicationModule.BankStatementProcessingAMImpl.fetchFile(251)
oracle.apps.financials.payments.shared.util.publicModel.common.util.CodePoint::oracle.apps.financials.cashManagement.bankStatements.ess.program.BankStatementProcessingProgram.resumeProcessing(696)
oracle.apps.financials.payments.shared.util.publicModel.common.util.CodePoint::oracle.apps.financials.cashManagement.bankStatements.ess.program.BankStatementProcessingProgram.execute(292)
oracle.apps.financials.payments.shared.util.publicModel.common.util.CodePoint::oracle.apps.fnd.applcp.request.exec.ExecutableWrapper.executeHelper(107)
oracle.apps.financials.payments.sharedSetup.transmissions.publicModel.entity.TransmissionConfigurationEOImpl::oracle.apps.fnd.applcore.messages.ApplcoreException: JBO-IBY:::IBY_40006: IBY-825216The file /tmp could not be opened to read data.
iby.shared.inboundFile.protectedModel.entity.InboundFileEO.fetchFile::oracle.apps.financials.payments.sharedSetup.transmissions.publicModel.util.TransmitFunction$TransmissionException: JBO-29000: Unexpected exception caught: oracle.apps.fnd.applcore.messages.ApplcoreException, msg=JBO-IBY:::IBY_40006: IBY-825216The file /tmp could not be opened to read data.
[2019-09-27 06:14:07.085] Fetch process is complete. Status of inbound statement file is [FETCH_ERROR]
[2019-09-27 06:14:07.218] ERROR: 1 file(s) did not import successfully.
[2019-09-27 06:14:07.226] **** Bank Statement Processing Program Completed in [0h0m3s] ****

STEPS:

The issue can be reproduced at will with the following steps:

1.Get a file from the bank having .mt940 extension
2.Zip the file using Winzip,7Zip,etc.

3.Upload the file using Load and Import in /fin/cash management/import

4.Load the file using "Load and import bank statements" EssJob

Cause

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