Payments Transmission Using SFTP Protocol Failing (Doc ID 832917.1)

Last updated on OCTOBER 06, 2016

Applies to:

Oracle Payments - Version 12.0.1 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
Oracle iPayment - Version: 12.0.1 to 12.0.6


Symptoms

When using SFTP Protocol, Create Settlement Batch fails with following error:

STATEMENT:[iby.net.SecureFTPPutFunction.transmit]:sending file
EXCEPTION:[iby.net.SecureFTPPutFunction.transmit]:oracle.apps.xdo.delivery.InvalidPropertyValueException: Invalid property value for Integer. Property name :[SFTP_PORT], Property value type :[java.math.BigDecimal]
at oracle.apps.xdo.delivery.AbstractDeliveryRequest.validatePropertyValue(AbstractDeliveryRequest.java:1433)
at
oracle.apps.xdo.delivery.AbstractDeliveryRequest.validateProperties(AbstractDeliveryRequest.java:1398)
at oracle.apps.xdo.delivery.AbstractDeliveryRequest.submit(AbstractDeliveryRequest.java:1174)
at oracle.apps.iby.net.SecureFTPPutFunction.transmit(SecureFTPPutFunction.java:162)
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:585)
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:199)
at oracle.apps.iby.payment.proc.BatchCCPayment.getBatchResp(BatchCCPayment.java:1176)
at oracle.apps.iby.payment.proc.BatchCCPayment.closeBatch(BatchCCPayment.java:948)
at oracle.apps.iby.scheduler.SchedBatchClose.schedPmt(SchedBatchClose.java:438)
at oracle.apps.iby.scheduler.Scheduler.doProcess(Scheduler.java:320)
at oracle.apps.iby.scheduler.Scheduler.init(Scheduler.java:417)
at oracle.apps.iby.scheduler.SchedInitiator.runProgram(SchedInitiator.java:209)

The issue can be reproduced at will with the following steps:
1. Configure SFTP tranmission protocol for FTP PUT
2. Attach the protocol with Funds Capture Process Profile
3. Run Create Settlement Batch

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