R12: AP/IBY/XDO: Payment File Transmission Failed to Reach the Bank - java.io.FileNotFoundException in XDO Log (Doc ID 1382244.1)

Last updated on APRIL 07, 2017

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.0 to 12.1.3 [Release 12.0 to 12.1]
Oracle Payments - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Goal

After applying unpublished patch 9848981:R12.XDO.A or 9848981:R12.XDO.B for the following bug, to get file MessageProcessor.java version 120.2.12000000.4 or 120.2.12010000.4 (respectively), to eliminate an error condition, the bank did not receive the transmitted payment file.
Bug 9848981 - SFTP CONNECTION FAILS TO NEGOTIATE SECONDARY CIPHER

Examining the XDO log showed the following new error:
[102711_121834131][][ERROR] Private key format implemented by oracle.apps.xdo.delivery.ssh2.transport.publickey.SshtoolsPrivateKeyFormat will not be available oracle.classloader.util.AnnotatedClassNotFoundException:
Missing class: oracle.apps.xdo.delivery.ssh2.transport.publickey.SshtoolsPrivateKeyFormat

Unpublished patch 8869321:R12.XDO.A or 8869321:R12.XDO.B was then applied to upgrade file SshPrivateKeyFormatFactory.java to get version 120.0.12000000.2 or 120.0.12010000.2 (respectively), which is the fixed version for that error, as described in unpublished bug 9937937.  Afterward, the new error is no longer seen, and the Payment Instruction status has reached "Transmitted".  However, the transmitted file is still not received by the bank, and the bank did not find any record of the connection in their logs.

FND debug messages logs and XDO logs were again gathered for manual transmission test and for an automatic transmission test. And this time the following error was seen in the XDO log:
[111411_122336247][oracle.apps.xdo.delivery.ssh2.SFTPDeliveryRequestHandler][EXCEPTION] java.io.FileNotFoundException: /u02/oracle/SIT1/apps/apps_st/comn/java/classes/com/stantec/ftpmanager/keys (Is a directory (errno:21))
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:106)
at oracle.apps.xdo.delivery.ssh2.transport.publickey.SshPrivateKeyFile.parse(SshPrivateKeyFile.java:145)
at oracle.apps.xdo.delivery.ssh2.SFTPDeliveryRequestHandler.submitRequest(SFTPDeliveryRequestHandler.java:216)
at oracle.apps.xdo.delivery.AbstractDeliveryRequest.submit(AbstractDeliveryRequest.java:1270)
at oracle.apps.iby.net.SecureFTPPutFunction.transmit(SecureFTPPutFunction.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.apps.iby.engine.CodePoint.invokeJava(CodePoint.java:250)
at oracle.apps.iby.engine.CodePoint.invoke(CodePoint.java:199)
at oracle.apps.iby.engine.TransmitConfig.transmit(TransmitConfig.java:216)
at oracle.apps.iby.scheduler.FDFormatProgramUtils.doTransmission(FDFormatProgramUtils.java:617)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.doTransmission(FDExtractAndFormatting.java:426)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:322)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:159)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

Unpublished patch 8557369:R12.XDO.A or 8557369:R12.XDO.B was then applied to upgrade file SftpClient.java to version 120.0.12000000.3 or 120.0.12010000.3 (respectively), in an attempt to address that error. Yet even after that, the bank's Data Transmission Support group confirmed that no file was received and no connection was recorded in their communication log

Solution

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