Load Data from Fusion Supply Chain Planning into Oracle Fusion Data Intelligence (Preview)

As a service administrator, you can use the Oracle Fusion Data Intelligence extract service to acquire data from a Fusion Supply Chain Planning instance.

You can later use this data to create data augmentations for various Enterprise Resource Planning and Supply Chain Management use cases. Establish the connection from Fusion Data Intelligence to your Fusion Supply Chain Planning instance to start data acquisition followed by augmentation.

Ensure that Fusion Supply Chain Planning is enabled on the Enable Features page prior to creating this connection. See Make Preview Features Available.

Note:

Oracle Fusion SCM Analytics is a prerequisite to use the Fusion Supply Chain Planning connector.
  1. In Fusion Data Intelligence, create the Fusion Supply Chain Planning data connection:
    1. In Fusion Data Intelligence Console, click Data Configuration under Application Administration.
    2. On the Data Configuration page, click Manage Connections.
    3. On the Manage Connections page, click Create and then click Connection.
    4. In Create Connection, select Data Extraction in Usage Type and then select Fusion Supply Chain Planning as the connection type.

      Fusion Supply Chain Planning connection option

    5. In the Create Connection dialog, enter these details and then click Save:
      • Connectivity Type: Standard.
      • Notification Email: An email address to receive notifications.
      • SCP Plan Names: The applicable plan names in your Fusion Supply Chain Planning instance.

      Note:

      If you have multiple Supply Chain Plan names, enter them in a comma-separated list with no spaces between plan names.

      Create Fusion Supply Chain Planning connection

    6. Verify that the Refresh Metadata toggle is enabled to ensure that the metadata is refreshed when you save the connection.
      You can later refresh the metadata from the Actions menu on the Manage Connections page, if required.

      Note:

      You can’t create augmentations for Fusion Supply Chain Planning unless you perform a metadata extract.
  2. On the Manage Connections page, select Actions for the Fusion Supply Chain Planning connection and then select Test Connection.
  3. To delete a connection, on the Manage Connections page, click Actions for the applicable connection and select Delete.

    Note:

    Ensure that you delete the functional areas, data augmentations, and custom data configurations related to the data connection before deleting it. You can't update or load data from deleted data connections to the warehouse.
  4. After the connections are successfully established, navigate to the Data Configuration page, select the connection in Data Source, then click the Data Augmentation tile, and create a data augmentation using the Fusion Supply Chain Planning data. Select the applicable Fusion Supply Chain Planning source tables. See Augment Your Data.