Export Supply Chain Planning Data

Use the Export Supply Chain Planning Data scheduled process to replicate sourcing-rule and assignment-set data from your Oracle Fusion Cloud Supply Chain Planning instance to another instance or application without re-entering data manually.

For example, you can replicate the sourcing rules in your Oracle Supply Chain Planning production instance into a reporting system or a test instance.

When to Use

Use the Export Supply Chain Planning Data scheduled process to extract sourcing rules and assignment set data into a comma-delimited values (CSV) file format. The generated file is in the standard file-based data import (FBDI) file format that you can then use to perform these tasks:

  • Check for missing or incorrect sourcing rules or sourcing assignments. For example, does a particular item organization have a valid sourcing assignment?
  • Replicate and then modify existing sourcing rules and assignment sets in a spreadsheet. You can then upload the new setups into another instance or application to create sourcing-rule and assignment-set setups.
  • Copy the sourcing-rule and assignment-set setups from one instance to another instance or application, such as from a test instance to a production instance.

Privileges Required

  • Extract Planning Data (MSC_EXTRACT_PLANNING_DATA_PRIV)

Specifications

Review these specifications before setting up this scheduled process:

Specification Description
Duration Typically, less than two minutes when run independently. However, expected time of completion depends on performance of the sequence of jobs being executed in queue before the job.
Compatibility There should be only one instance of the job running at any time. There’s no current functional need to run multiple instances of this process simultaneously.

Parameters

Parameter Optional or required Description Parameter Value
Filters Optional Use the Filter option to filter your export with specific assignment sets. If you don't select any filters, the process exports all sourcing rules and assignment sets.

All Assignment sets by default.

or

A selected assignment set.

Troubleshooting Information

  • You can view the status of the process in the Scheduled Processes work area.
  • The validation errors and warning messages that prevented the export data operation display in the error log.
  • The process doesn't perform interactive warning validations.
  • After you submit the scheduled process, you can perform any of these tasks in the Scheduled Processes work area:
    • Resubmit it
    • Put it on hold
    • Cancel the process
    • Release the process