1. Implementing Supply Chain Planning
  2. How You Extract Data from Oracle E-Business Suite for Loading

How You Extract Data from Oracle E-Business Suite for Loading

This topic provides a high-level overview of how you extract data from Oracle E-Business Suite for loading into Oracle Fusion Cloud Supply Chain Planning.

You must run the concurrent program named Extract data for Oracle Supply Chain Planning Cloud in Oracle E-Business Suite for extracting your data.

Information about the concurrent program, the installation and configuration of the functionality for integration between Oracle E-Business Suite and Oracle Supply Chain Planning, and the extraction process is available on My Oracle Support:
  • Doc ID 2339436.1: Integration For EBS 12.1.3 to Fusion Cloud Planning Applications - Release 11.13.17.11 or Later
  • Doc ID 2388134.1: Integration For EBS 12.2.x to Fusion Cloud Planning Applications - Release 13 update 18A or later (equivalent of 11.13.18.02.0)

The high-level process for extracting data from Oracle E-Business Suite and loading the data in Oracle Supply Chain Planning is as follows:

  1. In Oracle E-Business Suite, run the concurrent program named Extract data for Oracle Supply Chain Planning Cloud, and generate the compressed (.zip extension) file with the comma-separated value (.csv extension) files for the data.
  2. Download the .zip file to your local drive.
  3. Depending on your requirement, add the .csv files that you've generated from file-based data import (FBDI) templates to the .zip file.
  4. In Oracle Supply Chain Planning, on the File Import and Export page, search for the .zip file, and upload it to the scm/planningDataLoader/import account.
  5. Run the scheduled process named Load Planning Data from Flat Files for the .zip file.

Related Topics