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.
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.
Support for Supply Chain Planning Analytics
Oracle Supply Chain Planning Analytics provides data models to support reporting and analytics for the selected plans in the custom data application for Planning Analytics.
After you've published the custom data application , the following warehouse tables are created in Oracle Fusion SCM Analytics.
- Planning facts: DW_X_SCPA_APP_F_<PLAN_ID>_<Granularity>_F
- Planning dimensions: DW_X_SCPA_APP_<DIM_CODE>_D
- Plan as a Dimension: DW_X_SCPA_APP_PLAN_DETAILS
- Interface / Metadata tables
Planning Facts: DW_X_SCPA_APP_F_<PLAN_ID>_<Granularity>_F
- There's one fact table that's created in Oracle Fusion SCM Analytics for each granularity of the selected plan. This fact has all the associated dimension identifiers and metrics corresponding to the given granularity (the same as all the exposed columns in the Oracle Fusion Cloud Supply Planning extracts).
- The grain of this fact is at the dimensions associated to the given granularity.
- The available Oracle Fusion SCM Analytics dimension keys are denormalized and provided in this fact.
List of common Oracle Fusion SCM Analytics dimensions that are supported:
| Product | DW_INVENTORY_ITEM_D |
| Time | DW_DAY_D |
| Customer | DW_CUSTOMER_LOCATION_D |
| Organization | DW_INV_ORGANIZATION_D |
| Supplier Site | DW_SUPPLIER_SITE_D |
Planning Dimensions: DW_X_SCPA_APP_<DIM_CODE>_D
- The dimension tables are provided for each of the dimensions associated with all the granularities of the user selected plans.
- There are two types of dimensions: those which have a hierarchy, and those dimensions which don't have any hierarchies.
- Hierarchy Dimension
- The dimension data is created in Oracle Fusion SCM Analytics only with configured hierarchy levels with functional level names.
- The dimension data for all hierarchies is pivoted to a single row.
- Non-Hierarchy Dimension
- All the columns available in the planning dimension extract are created in Autonomous AI Lakehouse (Example: Exception Type, Order Type)
Plan as a Dimension: DW_X_SCPA_APP_PLAN_DETAILS
This dimension provides the details of the selected plans like Plan name, Plan type, and Plan description.
Table 10-1 Interface / Metadata tables
| Type | Table Name | Description |
|---|---|---|
| Data model details table | DW_X_SCPA_APP_FACT_TABLE_MEASURES_DESCRIPTION | This table provides the description of the measures and metrics used in Supply Chain Planning Analytics. |
| Data model details table | DW_X_SCPA_APP_PLAN_TABLES | This table provides the list of facts and dimensions generated for each of the user-selected plans.
This table helps you understand the list of data models available for the application and the data models used for semantic model extension. |
| Granularity measure details | DW_X_SCPA_APP_GRANULARITY_DETAILS | This table provides the list of granularity with the granularity details.
This metadata provides the Presentation table name for the fact. |
| Granularity measure details | DW_X_SCPA_APP_GRANULARITY_PLAN_MEASURES | This table provides the list of measures and metrics available at each granularity of the selected plan.
This metadata helps to build a single logical fact for each granularity across multiple plans by combining the facts of same granularity of different plans. |
| Hierarchy metadata table | DW_X_SCPA_APP_DIM_HIERARCHY_LEVEL_DETAILS | This table provides the hierarchy level details for each of the hierarchies associated with the dimensions.
This helps you build the logical hierarchy in the semantic model. In this table ‘Level 1’ is the base level. |
Supply Chain Planning Subject Areas
Oracle Supply Chain Planning Analytics includes subject areas for "Supplies, Demands, and Pegging", "Resource Requirements", and "Planning Exceptions".
Supplies, Demands, and Pegging
As a planner, analyzing demands, supplies, and pegging details is critical because it forms the foundation for balancing inventory levels, understanding delays, and ensuring high customer satisfaction. End-to-end visibility and traceability is extremely important in planning.
- The Supplies, Demands, and Pegging subject area helps with analyzing and reporting on the Planning output which contains supplies, demands and pegging details.
- The various plan types like Supply Plan, Replenishment Plan and Demand, and Supply Plan are supported.
- Plan-to-plan comparisons are done between supplies, demands, and pegging details generated by various plans.
Dimensions
| Dimension | Common Dimension | Planning Dimension |
|---|---|---|
| Customer | Yes | Yes |
| Customer Site | Yes | Yes |
| Date/Time | Yes | No |
| Item | Yes | Yes |
| Organization | Yes | Yes |
| Plan | No | Yes |
| Supplier | Yes | Yes |
| Supplier Site | Yes | Yes |
Metrics
| Metric Name | Description |
|---|---|
| Expected Scrap Quantity | Represents the expected scrap quantity of the supply record. |
| Firm Quantity | Represents the Quantity is marked as firm so that the quantity doesn't change during re-plan. |
| Firm Start Quantity | Represents the Firm quantity of start quantity when item shrinkage is considered in the supply planning. |
| Implemented Quantity | Represents the Implement quantity of the supply record. |
| Implement Quantity Rate | Represents the Implement daily rate of the supply record. |
| Issued Quantity | Represents the Part quantity issued for the Supply/Demand record. |
| No of Demands Count | Represents the distinct demands counts. |
| No of Pegging Count | Represents the distinct pegging record counts. |
| No of Supplies Count | Represents the distinct supplies counts. |
| Old Order Quantity | Represents the Old Supply quantity of the supply record or Old Demand quantity of the Demand record. |
| Original Firm Quantity | Represents the original firm quantity of the Supply/Demand record. |
| Original Quantity | Represents the Quantity ordered or break quantity for blanket purchase orders, requests for quotation (RFQs), and quotations for supply record and the original quantity of the Demand record. |
| Pegged Quantity | Represents the pegging quantity which is the allocated quantity of the Supply to the Demand. |
| Quantity | Represents the New Order Quantity of the supply record and Using Requirement Quantity of the Demand record. |
| Quantity Completed | Represents the completed quantity of the total work in progress job quantity. |
| Quantity In Process | Represents the Quantity in Process. |
| Quantity Rate | Represents the Quantity Rate of Supply/Demand record. |
| Quantity Remaining | Represents the remaining quantity of the Work in Progress (WIP) record in supply record. |
| Quantity Scrapped | Represents the Current job scrapped quantity units for the assembly. |
| Reserved Quantity | Represents the Quantity reserved of Supply/Demand record. |
| Start Quantity | Represents the is the actual quantity of the Supply record. |
| Total Output Quantity | Represents the quantity produced for the work definition. In process manufacturing, this is the Batch Quantity. This is mapped to Planned start quantity in Manufacturing for discrete jobs. |
| Unmet Quantity | Represents the Unmet Quantity for Independent Demands. |
Resource Requirements
As a Supply planner, reviewing resource requirements ensures all necessary inputs - machinery capacity, raw materials inventory, and skilled labor availability - are confirmed and aligned, establishing the plan's feasibility.
- The Resource Requirements subject area helps wtih analyzing and report the planning output which contains resource requirements.
- Various plan types like Supply Plan and Demand and Supply Plan are supported.
Dimensions
| Dimension | Common Dimension | Planning Dimension |
|---|---|---|
| Customer | Yes | Yes |
| Customer Site | Yes | Yes |
| Date/Time | Yes | No |
| Item | Yes | Yes |
| Organization | Yes | Yes |
| Plan | No | Yes |
| Supplier | No | Yes |
| Supplier Site | No | Yes |
Metrics
| Metric Name | Description |
|---|---|
| Adjusted Resource Hours | Represents the Adjusted Resource Hours of the resource requirement. |
| Operation Cost | Represents the Operation Cost of the resource requirement. |
| Operation Yield | Represents the Operation Yield of the resource requirement. |
| Ready Quantity | Represents the Ready Quantity of the resource requirement. |
| Resource Hours | Represents the Resource Hours of the resource requirement. |
| Scheduled Quantity | Represents the Scheduled Quantity of the resource requirement. |
Planning Exceptions
As a supply or replenishment planner, you must review planning exceptions they proactively flag urgent deviations in the planning process.
- The Planning Exceptions subject area helps with analyzing and reporting on the Planning exceptions of these Plan types: Supply Plan, Replenishment Plan, and Demand and Supply Plan.
- The Seeded Order-based exceptions data can be compared between various Supply Chain Plans.
Dimensions
| Dimension | Common Dimension | Planning Dimension |
|---|---|---|
| Customer | Yes | Yes |
| Customer Site | Yes | Yes |
| Date/Time | Yes | No |
| Exception Type | No | Yes |
| Item | Yes | Yes |
| Organization | Yes | Yes |
| Plan | No | Yes |
| Resource | Yes | Yes |
| Supplier | Yes | Yes |
| Supplier Site | Yes | Yes |
| Work Area | Yes | Yes |
| Work Center | Yes | Yes |
Metrics
All the metrics related to the Seeded Order-based exceptions are supported in this subject area. The common metrics across exceptions are listed in the table below.
| Metric Name | Description |
|---|---|
| Exceptions Count | Represents the Count of Unique exceptions. |
| Exceptions Quantity | Represents the Exceptions quantity. |
| Overload Ratio | Applicable only for Resource Overload exception. |
Frequently Asked Questions
Review these questions to understand the application:
- Why does Supply Chain Planning Analytics have many dynamically created subject areas?
- What types of dimensions are supported by Supply Chain Planning Analytics?
- What types of measures/metrics are supported by Supply Chain Planning Analytics?
- In Supply Chain Planning Analytics, is there a limit to the number of measures/metrics extracted to Oracle Fusion Data Intelligence?
- Does Supply Chain Planning Analytics support private plans, and is it possible to analyze such plans in Oracle Fusion Data Intelligence?
- What causes discrepancies between Oracle Fusion Data Intelligence Planning data and Fusion Applications Planning data?
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.
What causes discrepancies between Oracle Fusion Data Intelligence Planning data and Fusion Applications Planning data?
The Planning extracts are generated from Fusion Supply Chain Planning outputs and are regenerated with each Supply Chain Plan run. If the plan is re-run and the updated data aren't loaded into Oracle Fusion Data Intelligence, discrepancies may occur. To resolve this, perform a full reload of the Planning Analytics data in Oracle Fusion Data Intelligence.