Format Payment Instruction Log Doesn't Raise Error If Connection Fails And Fil (Doc ID 1363362.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payments - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

When sending payment file via SFTP, the file payment format program was completing normally, but the file was not being sent to endpoint.

The payment format program log, clearly shows a success:
Start transmission.iby.scheduler.FDFormatProgramUtils.doTransmission()
Exit: iby.scheduler.FDFormatProgramUtils.doTransmission()
Transmission successful. So setting result status to TRANSMITTED

But debuging the xdo there is clearly an exxception:

oracle.apps.xdo.delivery.ssh2.SFTPDeliveryRequestHandler][EXCEPTION] oracle.apps.xdo.delivery.ssh2.SshException: Exception in authenticating
at oracle.apps.xdo.delivery.ssh2.SFTPDeliveryRequestHandler.submitRequest(SFTPDeliveryRequestHandler.java:239)
at oracle.apps.xdo.delivery.AbstractDeliveryRequest.submit(AbstractDeliveryRequest.java:1270)
at oracle.apps.iby.net.SecureFTPPutFunction.transmit(SecureFTPPutFunction.java:179)

This exeception needs to be captured and handled.


Also please review the following:

from xdo.log:
072511_010444019http://oracle.apps.xdo.delivery.ssh2.userauth.PublicKeyAuthenticationClientERROR Passwd Authenticating failed. Authentications that can be tried are password,publickey,keyboard-interactive
072511_010444021http://oracle.apps.xdo.delivery.ssh2.SFTPDeliveryRequestHandlerEXCEPTION oracle.apps.xdo.delivery.ssh2.SshException: Exception in authenticating
at oracle.apps.xdo.delivery.ssh2.SFTPDeliveryRequestHandler.submitRequest(SFTPDeliveryRequestHandler.java:239)
at oracle.apps.xdo.delivery.AbstractDeliveryRequest.submit(AbstractDeliveryRequest.java:1270)
at oracle.apps.iby.net.SecureFTPPutFunction.transmit(SecureFTPPutFunction.java:179)
at oracle.apps.iby.net.XxwinSecureFTPPutFunction.transmit(XxwinSecureFTPPutFunction.java:119)
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)

from payment log:
Instruction status was CREATED, the instruction is set to transmit immediately and the transmission configuration is available. Starting transmission.
Enter: iby.scheduler.FDExtractAndFormatting.doTransmission()
Enter: iby.scheduler.FDFormatProgramUtils.getCPFilename()
got CP outfile_name: /interface/j_wnct/TWNCTI/archive/ORAPAYBACS925285.dat
Exit: iby.scheduler.FDFormatProgramUtils.getCPFilename()
Enter: iby.scheduler.FDFormatProgramUtils.doTransmission()
Created ByteArrayInputStream containing the format output.iby.scheduler.FDFormatProgramUtils.doTransmission()
Start transmission.iby.scheduler.FDFormatProgramUtils.doTransmission()
Exit: iby.scheduler.FDFormatProgramUtils.doTransmission()
Transmission successful. So setting result status to TRANSMITTED
Enter: iby.scheduler.FDExtractAndFormatting.postResults()

As we can see the log is not giving error information

Cause

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