Use the payment transmission configuration feature to automate the bank statement file import process. The process uses the payments transmission feature to connect to bank and download the bank statement file for subsequent processing and loading into the application.
Perform the following steps to set up automatic bank statement file import:
- Set up Payment System: Represents the financial institute or bank in Oracle Fusion Payments. For customers who access Oracle Fusion Applications through Oracle Public Cloud and other implementations, navigate to the Manage Payments System page from Setup and Maintenance to create a payment system.
- Set up Transmission Configuration: Contains the connectivity details for the financial institute or bank. This connectivity information is provided by the bank. The following protocols are supported for connecting and retrieving a file from bank server:
- Secure File Transfer Retrieval Protocol for Static File Names (SFTP_GET): The bank provides the SFTP server details including SFTP server host/ip, port, credential details. Before using this protocol, you must log a service request with Oracle Support and provide the SFTP connectivity details. The SFTP_GET protocol currently supports only basic user name and password based authentication.
- Http(s) GET Request: The bank provides the SSL enabled destination URL for connecting and retrieving the statement files. This URL can have authentication enabled. The HTTPS_GET protocol supports https connection but doesn’t support the exchange of any dynamic tokens.
- Schedule Process Electronic Bank Statement Request: The process performs the following tasks:
- Connects to the bank and retrieves the banks statement file
- Processes and loads the bank statement file into the application