My Oracle Support Banner

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

Last updated on JULY 19, 2021

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

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
Cause
Solution
References


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