Import Collaboration Order Forecasts

You can import the collaboration order forecasts from an external application by using the File-Based Data Import mechanism. For more information on the File-Based Data Import mechanism, see the File-Based Data Import for Oracle Supply Chain Management Cloud guide.

Note: To create the File-Based Data Import files, you can use a set of Microsoft Excel template files that are provided for this purpose. You can download the templates from the File-Based Data Import (FBDI) for SCM guide in the Oracle Help Center.

To load collaboration order forecasts from files, perform the following steps:

1. Setup your collaboration relationships on the Manage Supply Collaboration Network page.

2. Create a collaboration plan using the Manage Collaboration Plans page. You must set the supply plan source to External Application and provide a supply plan name.

3. Prepare data for collaboration order forecasts. You can download the Collaboration Order Forecast file-based data import template, which are Microsoft Excel template files from the File-Based Data Import for SCM Cloud guide on the Oracle Help Center.

4. Extract the templates to a local drive, enter the appropriate data, and generate CSV files. You can compress the CSV files to a zipped file format.

5. Run the Load Interface File for Import scheduled process to load the order forecast data from the CSV files. In the import process, select Import Collaboration Order Forecasts and select the data file you would like to import. If had previously uploaded a data file to the scm/collaborationOrderForecast/import account using the File Import and Export page, the file name will appear in the list of data files.

6. Run the Supply Collaboration Decomposition scheduled process to decompose the imported order forecast data.