10 Advanced Configurations

Oracle Fusion Supply Chain Planning

Oracle Fusion Supply Chain Planning (FSCP) is a self-service advanced capability in Oracle Fusion Data Intelligence that enables you to extract data from a Oracle Fusion Cloud Supply Chain Planning instance. You can use this data to create data augmentations for various Enterprise Resource Planning and Supply Chain Management use cases.

Topics

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

As a service administrator or functional administrator, you can use Oracle Fusion Data Intelligence to acquire data from an Oracle Fusion Cloud Supply Chain Planning instance into a prebuilt analytics model.

To use this feature, be sure Supply Chain Planning Analytics is enabled in Preview Features. See Make Preview Features Available.
  1. Create a sample data augmentation to validate the Oracle Fusion Cloud Supply Chain Planning connection is working properly. See Load Data from Fusion Supply Chain Planning into Fusion Data Intelligence (Preview)
    1. In Oracle Fusion Data Intelligence Console, click Data Configuration under Application Administration, and on the Data Configuration page, under Configurations, click Data Augmentation.
    2. Create a sample augmentation for testing the Oracle Fusion Cloud Supply Chain Planning data connection.
    3. Select any one of the facts in the Data Augmentation page and complete the wizard.
    4. In step 6 of the wizard, provide the details and click Finish to save and schedule your data augmentation pipeline job to ensure the job completes successfully.
  2. Activate the dependent Manufacturing, Order Management, and Purchasing functional areas. See Activate a Data Pipeline for a Functional Area
  3. Create the Planning Analytics application. See Extend Data with Custom Data Configurations.

    In Oracle Fusion Data Intelligence, creating subject areas is dynamic since you have the ability to create subject areas based on the selected plans.

    1. Navigate to the Custom Data configurations and create the planning application by selecting one or more plans.
    2. You can generate the extension metadata (RPD Extension). By default option is disabled.
    3. Depending on the number of plans selected, the dynamic subject areas with different granularities are created.
  4. Publish the Planning Analytics application. See Publish the Model.
    1. Generate and publish the custom application.
    2. After the custom application is deployed, you can see the subject areas.

Frequently Asked Questions

Review these questions to understand the application:

Why does Supply Chain Planning Analytics have many dynamically created subject areas?

The subject areas for Supply Chain Planning Analytics dynamic are created for each of the granularities in the Planning output of the Supply Chain Plan. For example, granularity 135 is created for Item, Org, Customer, Demand Class, and Time. See Dimensionality Group Codes Used by the Plan Extract Process.

What types of dimensions are supported by Supply Chain Planning Analytics?

Supply Chain Planning Analytics supports both standard Oracle Fusion Data Intelligence dimensions as well as planning dimensions extracted from Oracle Fusion Cloud Supply Chain Planning to Oracle Fusion Data Intelligence. For the planning dimensions, the dimension that's part of the extract dimension catalog (configured in the plan options) is extracted to and supported by Oracle Fusion Cloud Supply Chain Planning.

What types of measures/metrics are supported by Supply Chain Planning Analytics?

Supply Chain Planning Analytics supports both standard seeded measures and custom measures created by users.

In Supply Chain Planning Analytics, is there a limit to the number of measures/metrics extracted to Oracle Fusion Data Intelligence?

Yes. The number of measures is limited by granularity. For example, in granularity 135 you can have up to 250 measures; granularity 125 is limited to 150 measures; granularity 110 is limited to 100 measures, and rest of the granularities can have up to 50 measures.

For additional metrics, you can create calculated metrics in Oracle Analytics Cloud while creating dashboards, or use semantic model extensions if needed.

Does Supply Chain Planning Analytics support private plans, and is it possible to analyze such plans in Oracle Fusion Data Intelligence?

Currently Supply Chain Planning Analytics doesn't support private plans. You should configure your plans as Public plans before extracting the plan data into Oracle Fusion Data Intelligence.