About This Recipe

This recipe reads a file from an Amazon S3 location, does a simple transformation, and then imports the financial journal entries into Oracle ERP Cloud. The recipe uses File-Based Data Integration (FBDI).

To use the recipe, you must install the recipe and configure the connections and other resources within the recipe. The integration uses a scheduled orchestration pattern to download the file from the Amazon S3 location, process it, and import it into Oracle ERP Cloud. The import process records the results in a log file. To send this log file back to the Amazon S3 location, the integration uses an app-driven orchestration. The trigger to start an app-driven orchestration is based on an event happening. In this case, the log file is ready for export.

System and Access Requirements

  • Oracle Integration, Version 24.04 or higher

  • Amazon Web Services (AWS) with Amazon S3

  • An account on AWS with Administrator role

  • Oracle ERP Cloud

  • An account on Oracle ERP Cloud with the Administrator role