1 About This Recipe
Use this recipe to import a payment request from an FTP server to Oracle ERP Cloud.
Note:
This recipe is available as FTP Server — Oracle ERP Cloud | Import Payment Requests in the Integration Store. Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.
Overview
This recipe imports an interface file containing payment requests from an FTP server to Oracle ERP Cloud according to a schedule specified in Oracle Integration.
In Oracle ERP Cloud, a payment request is used to make a one-time payment (without creating a supplier record) to external suppliers or parties. When a payment request (transaction) is imported into Oracle ERP Cloud, the payees, parties, and bank accounts are automatically created in the application, thereby simplifying the task of making the payment. In addition, the transactions are validated automatically, eliminating the need for manual intervention.
As part of this recipe, Oracle provides an example file structure that you can use to load a payment request into Oracle ERP Cloud.
To use the recipe, you must install the recipe and configure the connections and other resources within it. Subsequently, you can activate and run the recipe manually or specify an execution schedule for it. When triggered, the recipe loads a payment request from a specified FTP server to Oracle ERP Cloud.
System and Access Requirements
-
Oracle Integration, Version 21.4.2.0.0 or higher
-
Oracle ERP Cloud, Version 21d or higher
-
Accounts on Oracle ERP Cloud with the Administrator role and the Accounts Payable Invoice Supervisor/Accounts Payable Manager/Accounts Payable Specialist role (in order to check for payment requests)
-
A secure FTP (sFTP) server or File Server
-
An FTP client to access the sFTP server.
Recipe Schema
This section provides an architectural overview of the recipe.
The primary integration flow (Oracle FTP ERP Cloud Payment Request), when triggered by an execution schedule or a manual submission, queries the FTP server for a payment request file (.zip). If a file is found, the integration flow processes the file. Initially, the flow maps the file’s layout to the layout required by Oracle ERP Cloud, and then it imports the payment requests in bulk through the ERP Adapter.
After importing the payment request, Oracle ERP Cloud makes a callback to the secondary integration flow (Oracle FTP ERP Cloud Payment Request Callback), which downloads the log files from Oracle ERP Cloud and places them on the FTP server.
