About This Recipe
This recipe reads a file from an FTP location, does a simple transformation, and then imports the financial journal entries into Oracle ERP Cloud. It uses File-Based Data Integration (FBDI). The integration flow can be invoked explicitly either as a web service or as a scheduled orchestration.
To use the recipe, you must install the recipe and configure the connections and other resources within the recipe.
The integration flow of the recipe performs the following tasks:
- Reads the ledger-entries file from the FTP location.
- Unzip the file.
- Stages the file in Oracle Integration and read each entry.
- Transforms the data as required. For example, this integration changes the value in the currency column.
- Sends the file to Oracle ERP Cloud, configure a callback, and invoke the import process with the required parameters.
- After the import completes, Oracle Integration receives the result of the import from Oracle ERP Cloud. If the import completes successfully, then upload the log file to the FTP server. If the import fails, then send an email notification.
You can store the ledger-entries file on File Server, an embedded sFTP server within Oracle Integration. To use File Server, you must enable it for your Oracle Integration instance. See Enable File Server.