Import Financial Journal Entries from an FTP server to Oracle ERP Cloud

Use this recipe to import financial journal entries from an FTP Server location to Oracle ERP Cloud. The recipe uses File-Based Data Integration (FBDI).

Note:

This recipe is available as Oracle ERP Cloud — FTP Server | Import Financial Journal Entries 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 reads a file from an FTP location, does a simple transformation, and then imports the financial journal entries into Oracle ERP Cloud. The integration flow can be invoked explicitly either as a web service or as a scheduled orchestration.

The sample integration performs the following actions:

Read the ledger-entries file from the FTP location.
Unzip the file.
Stage the file in Oracle Integration and read each entry.
Transform the data as required. For example, this sample integration changes the value in the currency column.
Use the Oracle ERP Cloud Adapter to send the file to Oracle ERP Cloud, configure a callback, and invoke the import process with the required parameters.
Report the results. After the import is completed, 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 in Using File Server in Oracle Integration Generation 2.

System and Access Requirements

Oracle Integration
Oracle ERP Cloud
A secure FTP (sFTP) server or File Server

Install, Configure, and Run the Recipe

For more information and steps to install, configure, and run recipes, see Get Started with Integration Accelerators and Recipes.