1. Getting Started with Oracle Integration Generation 2
  2. Recipes Reference
  3. Enterprise Resource Planning (ERP) Recipes
  4. Extract Bulk Data from Oracle ERP Cloud to an FTP server

Extract Bulk Data from Oracle ERP Cloud to an FTP server

Use this recipe to export bulk data from Oracle Enterprise Resource Planning (ERP) Cloud and import it into an FTP server.

Note:

This recipe is available as Oracle ERP Cloud — FTP Server | Extract Bulk Data 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 extracts BI Publisher (BIP) report data from Oracle ERP Cloud in an asynchronous manner. The integration uses a scheduled orchestration pattern so that you can schedule when to extract the data extract and how often. The extracted reports are then transferred and uploaded to an FTP server. The reports are now available to users and applications directly from the FTP location. If required, you can enrich or edit the extracted report data within the integration.

The sample integration performs these actions:

  • Query bulk data from Oracle ERP Cloud.

  • Receive the data via the ERP trigger.

  • Invoke it through the SOAP Adapter and get the data from a business event.

  • Complete the process. If the import completes successfully as per the Oracle ERP Cloud callback, then upload the file received in the callback to the FTP server. If the import fails, then send an email notification.

You can upload the extracted reports to 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, Version 19.2.3.0.0 (190518.1400.28490)

  • Oracle ERP Cloud, Version 19A (11.13.19.01.0)

  • 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.

Related Documentation