Import Financial Journal Entries from an FTP Server

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

Note:

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.

Description

This recipe reads a file from an FTP location, does a simple transformation, and then imports the financial journal entries into Oracle Fusion Cloud Enterprise Resource Planning. 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 Fusion Cloud Enterprise Resource Planning, 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 Fusion Cloud Enterprise Resource Planning . 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 , an embedded sFTP server within Oracle Integration. To use , you must enable it for your Oracle Integration instance. See Enable File Server in Using File Server in Oracle Integration Generation 2.

System Requirements

Oracle Integration
Oracle Fusion Cloud Enterprise Resource Planning
A secure FTP (sFTP) server or File Server (available in Oracle Integration Generation 2).