My Oracle Support Banner

How To Troubleshoot Electronic Bank Statement Process SFTP Failures (Doc ID 2225338.1)

Last updated on SEPTEMBER 17, 2023

Applies to:

Oracle Fusion Payments Cloud Service - Version 11.1.4.0.0 and later
Oracle Fusion Cash Management Cloud Service - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Goal

Process Electronic Bank Statement ESS job automates the process of connecting to bank and downloading the bank statement file. This is done using "Secure File Retrieval Protocol" (SFTP_GET) provided by Fusion Payments. Bank statement file download using SFTP_GET requires direct point to point connection from SaaS Cloud to Bank SFTP server to be opened. However, starting Release 13.18.05, application leverages proxy based SFTP connection. We no longer need to open DIRECT connection. Instead, by default, application uses PROXY based connection. There is no need to create SFTP_TRHOUGH PROXY lookup.

The following steps should be used when troubleshooting failures due to connectivity issues with bank either using DIRECT or PROXY connection.

Solution

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
Goal
Solution
 1. Troubleshooting SFTP_GET When using direct connection
 2. Troubleshooting SFTP_GET When using proxy connection


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