Tip: The Demantra Local Application replaces Collaborator Workbench. You may see both names in this text.
This appendix covers the following topics:
The following is a list of the available levels in the Demand Management application:
For Item dimensions:
Asset Group
Asset Group Attribute 1
Asset Group Attribute 2
Asset Group Attribute 3
Class Code
Demand Class
Item
Item Description
Item Type
Product Category
Product Family
Master Item
For Location dimensions:
Organization
Legal Entity
Operation Unit
Business Group
Sales Channel
Site
Account
Customer
Customer Class
Trading Partner Zone
Zone
For Item dimensions:
Item
Item Category Code 1
Item Category Code 2
Item Category Code 3
Item Category Code 4
Item Category Code 5
Item Category Code 6
Item Category Code 7
Product Description
For Location dimensions:
Organization
Item Category Code 1
Item Category Code 2
Item Category Code 3
Item Category Code 4
Item Category Code 5
Branch City
Branch Country
Branch State
Site
Account
Customer Category Code 1
Customer Category Code 2
Customer Category Code 3
Customer Category Code 4
Customer Category Code 5
Customer Category Code 6
Customer Category Code 7
Customer City
Customer Country
Customer State
Trading Partner Zone
| Level | Level Type | Parent Level | Data Table | Population Attribute | Description |
|---|---|---|---|---|---|
| CTO | General Level | T_EP_CTO | t_ep_cto | Contains information for each link in the BOM tree. | |
| Parent Item | General Level | T_EP_CTO_PARENT_ITEM Synonym to T_EP_ITEM | - | Alias level to Item, contains the parent items in the BOM tree. | |
| Base Model | - | T_EP_CTO_BASE_MODEL | - | Contains the Base Model items in the BOM tree. | |
| Demand Type | - | T_EP_CTO_DEMAND_TYPE | - | Identifies whether a link is a Base Model or an Option. |
For information about SPF Item levels, refer to the Available EBS Levels.
SPF Location levels:
Organization Type
Organization Tier
Country Virtual
Region Virtual
Time Zone Virtual
Global Virtual
The table below provides information about general SPF levels.
| Level | Level Type | Parent Level | Data Table | Population Attribute | Description |
|---|---|---|---|---|---|
| SPF | General Level | SPF Base Model | T_EP_SPF | t_ep_spf | Contains information about each item in the service BOM tree. |
| SPF Base Model | General Level | - | T_EP_SPF_BASE_MODEL | - | Contains information about the Base Model (root item) of the service BOM. |
| SPF Child | General Level | - | T_EP_SPF_CHILD_ID | - | Internal level used to map BOM structure. |
| SPF Demand Type | General Level | - | T_EP_SPF_DEMAND_TYPE | - | Level indicating whether selected member stores dependant or independent demand. |
| SPF Latest Revision | General Level | - | T_EP_SPF_LATEST_REV | - | Level that groups different spares in the same supersession. Level can be used for forecasting items serving the same role for a base model together. |
| SPF Parent | General Level | - | T_EP_SPF_PARENT | - | Internal level used to map BOM structure. |
| SPF Parent Item | General Level | - | T_EP_SPF_PARENT_ITEM | - | Internal level used to map BOM structure. |
The levels SPF Maintenance Type, SPF Visit Stage Type, SPF Visit Type and SPF Transit Visit will be disabled by default in the DM and S&OP components.
For more information about this integration, refer to "Oracle Demantra Integration with Asset Intensive Planning Applications" in the Oracle Demantra Implementation Guide.
| Level | Level Type | Parent Level | Data Table | Population Attribute | Description |
|---|---|---|---|---|---|
| SPF Visit Stage Type | General Level | - | t_ep_spf_visit_stage_type | - | Type of visit stage a specific maintenance work order is associated with. Used to stripe work order usage. This level is provided to support Demantra integration with Oracle Complex Maintenance Repair and Overhaul (cMRO) and/or Enterprise Asset Management (eAM). |
| SPF Visit Type | General Level | SPF Transit Visit | t_ep_spf_visit_type | - | Type of visit a specific maintenance work order is associated with. Used to stripe work order usage. This level is provided to support Demantra integration with Oracle Complex Maintenance Repair and Overhaul (cMRO) and/or Enterprise Asset Management (eAM). |
| SPF Transit Visit | General Level | - | t_ep_spf_transit_visit | - | Parent of SPF Visit Type used to specify whether specific visit type is associated with scheduled maintenance or with a transit visit. This level is provided to support Demantra integration with Oracle Complex Maintenance Repair and Overhaul (cMRO) and/or Enterprise Asset Management (eAM). |
| SPF Maintenance Type | General Level | - | t_ep_spf_maint_type | - | Type of maintenance to which the work order is associated. Used to stripe work order usage. This level is provided to support Demantra integration with Oracle Complex Maintenance Repair and Overhaul (cMRO) and/or Enterprise Asset Management (eAM). |
The following is a list of series used by the Demand Management application:
| Series | Description |
|---|---|
| % Change to Base | Factor Override on Sales Forecast |
| 1 Week Lag Forecast | Forecast as of 1 Week ago. |
| 10 Week Lag Forecast | Forecast as of 10 Weeks ago. |
| 11 Week Lag Forecast | Forecast as of 11 Weeks ago |
| 12 Week Lag Forecast | Forecast as of 12 Weeks ago |
| 13 Week Lag Absolute Dev | Absolute Deviation of 13 Week Lagged Forecast (abs(13 Week Lag Forecast - Adjusted History)) |
| 13 Week Lag Absolute Pct Err | Absolute Pct Error of 13 Week Lagged Forecast (abs(13 Week Lag Forecast - Adjusted History)/ Adjusted History) |
| 13 Week Lag Forecast | Forecast as of 13 Weeks ago |
| 13 Week Lag Pct Err | Pct Error of 13 Week Lagged Forecast ((13 Week Lag Forecast - Adjusted History)/Adjusted History) |
| 2 Week Lag Forecast | Forecast as of 2 Weeks ago |
| 3 Week Lag Forecast | Forecast as of 3 Weeks ago |
| 4 Week Lag Absolute Dev | Absolute Deviation of 4 Week Lagged Forecast (abs(4 Week Lag Forecast - Adjusted History)) |
| 4 Week Lag Absolute Pct Err | Absolute Pct Error of 4 Week Lagged Forecast (abs(4 Week Lag Forecast - Adjusted History)/ Adjusted History) |
| 4 Week Lag Forecast | Forecast as of 4 Weeks ago |
| 4 Week Lag Pct Err | Pct Error of 4 Week Lagged Forecast ((4 Week Lag Forecast - Adjusted History)/Adjusted History) |
| 5 Week Lag Forecast | Forecast as of 5 Weeks ago |
| 6 Week Lag Forecast | Forecast as of 6 Weeks ago |
| 7 Week Lag Forecast | Forecast as of 7 Weeks ago |
| 8 Week Lag Absolute Dev | Absolute Deviation of 8 Week Lagged Forecast (abs(8 Week Lag Forecast - Adjusted History)) |
| 8 Week Lag Absolute Pct Err | Absolute Pct Error of 8 Week Lagged Forecast (abs(8 Week Lag Forecast - Adjusted History)/ Adjusted History) |
| 8 Week Lag Forecast | Forecast as of 8 Weeks ago |
| 8 Week Lag Pct Err | Pct Error of 8 Week Lagged Forecast ((8 Week Lag Forecast - Adjusted History)/Adjusted History) |
| 9 Week Lag Forecast | Forecast as of 9 Weeks ago |
| Abs % Error | Absolute % Error for Fit Forecast |
| Abs Deviation | Absolute Deviation for Fit Forecast |
| Adjusted History | Final History data including adjustments |
| Base Override | Manual Override on Sales Forecast |
| Baseline Forecast | Analytical Sales Forecast Including User Simulations |
| Booking Req Qty Req Date | Booking History Requested Quantity Requested Date |
| Booking Book Qty Book Date | Booking History Booked Quantity Booked Date |
| Booking Book Qty Req Date | Booking History Booked Quantity Requested Date |
| Booking Req Qty Book Date | Booking History Requested Quantity Booked Date |
| Demand Class Destination Key | Demand Class Destination Key |
| Demand Priority | Demand Priority |
| EBSPRICELIST0 to EBSPRICELIST129 | Price lists |
| Final Approval | Final Approved if Checked |
| Final Approved By | User who finally approved the forecast |
| Final Forecast | Final Forecast |
| History | Historical Actual Sales/Shipment |
| History Override | Historical Manual Override on Sales |
| Item Destination Key | Item Destination Key |
| Mean Absolute Pct Err | Mean Absolute Pct Err |
| Organization Destination Key | Organization Destination Key |
| Pct Bias | Pct Bias |
| Relative Err | Relative Err |
| Return History | Returns History |
| Return History Site Source Key | Returns History Site Source Key |
| Root Mean Squared Err | Root Mean Squared Err |
| Sales Channel Destination Key | Sales Channel Destination Key |
| Shipping Req Qty Req Date | Shipping History Requested Quantity Requested Date |
| Shipping Ship Qty Req Date | Shipping History Shipped Quantity Requested Date |
| Shipping Ship Qty Ship Date | Shipping History Shipped Quantity Shipped Date |
| Simulation | Analytical Re-Forecast Triggered by a User Simulation |
| Site Destination Key | Site Destination Key |
This is a list of the series for Configure to Order
| Series | Description |
|---|---|
| Archived Consensus Total Demand | Consensus Total Demand for each of the most recent 13 historical weeks. |
| BOM Eff End Date | Effective end date of the option Sourced from Oracle e-Business Suite. |
| BOM Eff Start Date | Effective start date of the option. Sourced from Oracle e-Business Suite. |
| Consensus Forecast | Weighted combination of the Final Forecast, Sales Forecast, and Marketing Forecast. Oracle Demantra Sales and Operations Planning series, available to Oracle Demantra Demand Management. |
| Consensus Forecast Amount | Monetary value of Consensus Forecast Calculated: Consensus Forecast * Item price |
| Consensus Total Demand | Demand represented by the sum of Final Forecast Dependent Demand and Consensus Forecast of an item. Calculated: Final Forecast Dependent Demand + Consensus Forecast |
| Consensus Total Demand Amount | Monetary value of Consensus Total Demand Calculated: Forecast Dependent Demand Amount + Consensus Forecast Amount |
| Constrained Forecast | Indicates how much of the consensus demand can be filled given supply chain constraints. Oracle Demantra Sales and Operations Planning series, imported from Oracle Advanced Supply Chain Planning or Oracle Strategic Network Optimization, available to Oracle Demantra Demand Management. |
| Dep Demand Existing | Dependent demand calculated based on series Plng Pct Existing. Calculated: Plng Pct Existing of item* If Parent = BaseModel, Consensus Forecast of Parent. Otherwise, series Final Forecast Dependent Demand of Parent. |
| Dep Demand History | Dependent demand calculation based on Plng Pct History. Calculated: Plng Pct History of item* (If Parent = BaseModel, Consensus Forecast of Parent). Otherwise, series Final Forecast Dependent Demand of Parent. |
| Final Forecast Amount | Monetary value of Final Forecast Calculated: Final Forecast * Item price |
| Final Forecast Dependent Demand | Based on the override and Forecast Dependent Demand Calculated: Use Forecast Dependent .Demand.Override; if it is null, use Forecast Dependent Demand |
| Final Forecast Dependent Demand Amount | Monetary value of Final Forecast Dependent Demand Calculated: Final Forecast Dependent Demand * Item price |
| Final Plng Pct | Final planning percentage based on series Plng Pct Choice. Value can be overriden by series Plng Pct Override. Use Plng Pct Override; if it is null, use Plng Pct Choice |
| Final Plng Pct Aggregated | Final Plng Pct at levels higher than Item/Org Calculated: Server expression |
| Forecast Dependent Demand | Based on series Final Plng Pct. Calculated: Final Plng Pct * If Parent = BaseModel, Consensus Forecast of Parent. Otherwise, series Final Forecast Dependent Demand of Parent. |
| Forecast Dependent Demand Override | Override of the item's Forecast Dependent Demand Manual entry |
| Dependent History | Historical dependent demand for the default History series Default is Shipping History, requested items, shipped date Loaded at levels PRD for Item, TIM: for Day, ORG for Organization, GEO for Site, CHN for Sales Channel, and DCS: Demand Class |
| History series (seeded) | Historical dependent demand for the series - Dependent Booking booked items booked date - Dependent Booking requested items booked date - Dependent Booking booked items requested date - Dependent Booking requested items requested date - Dependent Shipping requested items shipped date (default) - Dependent Shipping shipped items requested date - Dependent Shipping requested items requested date Loaded at levels PRD for Item, TIM: for Day, ORG for Organization, GEO for Site, CHN for Sales Channel, and DCS: Demand Class For each seeded history series, there is a corresponding dependent demand series. For example, seeded history series Booking - booked items - booked date corresponds to dependent demand series Dependent Booking - booked items - booked date. |
| Marketing Forecast | Forecast from Marketing Department. Oracle Demantra Sales and Operations Planning series, available to Oracle Demantra Demand Management. |
| MAPE CTO | Mean Absolute Percentage Error used for Forecast Accuracy Statistic Calculated: Results of the MAPE CTO procedure that calculates the accuracy statistics for Consensus Total Demand. Calculatedsum(abs(Total History - Archived Forecast))/sum(History) |
| Plng Pct Existing | Planning percentage from the source Sourced from Oracle e-Business Suite |
| Plng Pct History | Planning Percentage calculated based on the sales history of items and their parents. Calculated: Averaged over the number of periods in parameter CTO_HISTORY_PERIODS, default is 52. Total(History Dependent Demand over CTO_History_Periods) / If Item's Parent = BaseModel, Total(History of Parent over CTO_History_Periods). Otherwise, Total(History Dependent Demand of Parent overCTO_History_Periods) |
| Plng Pct Choice | Planning percentage used to calculate Forecast, Dependent Demand, and Final Forecast Dependent Demand. Select from dropdown list, stored in paraeater CTO_PLANNING_PERCENTAGE. Valid values
|
| Plng Pct Override | Override of planning percentage value from series Plng Pct Existing, Plng Pct History, or Plng Pct Forecast. Manually entered. |
| Quantity Per Parent | Number of this item used for one parent. Sourced from Oracle e-Business Suite. |
| Sales Forecast | Forecast from Sales Department. Oracle Demantra Sales and Operations Planning series, available to Oracle Demantra Demand Management. |
The following table displays the series used by Service Parts Forecasting.
| Series Name | Definition |
|---|---|
| SPF Analytical Forecast Archive 1 | Analytical forecast generated and archived for 1 forecasting cycles prior to the current cycle. |
| SPF Analytical Forecast Archive2 | Analytical forecast generated and archived for 2 forecasting cycles prior to the current cycle. |
| SPF Analytical Forecast Archive3 | Analytical forecast generated and archived for 3 forecasting cycles prior to the current cycle. |
| SPF Analytical Forecast BIAS % | Accuracy measure that indicates whether the forecast is above or below demand. Calculated by comparing shipments to SPF Analytical Forecast. |
| SPF Analytical Forecast Bias % 1 Month lag | Bias of the analytical forecast one month into the future. |
| SPF Analytical Forecast MAPE 1 Month lag | Accuracy of the analytical forecast one month into the future. |
| SPF Analytical Models | Series displaying which analytical models were used to generate the Spares forecast. |
| SPF Analytical Models Min | For Internal Use. Displays whether different models were used to forecast different combinations under the level displayed in worksheet. |
| SPF Analytics Forecast MAPE | Accuracy measure that indicates how accurately the forecast matches demand. Calculated by comparing shipments to SPF Analytics Forecast. |
| SPF Average Demand | Indicates the average historical demand for a spare/org. Calculated by the proport mechanism. |
| SPF Baseline Forecast | Latest forecast generated by the analytical engine. |
| SPF Best Forecast | Series displays whether calculated or analytical forecast is more accurate. |
| SPF Calculated Forecast | Latest forecast generated by multiplying install base under contract and final failure rate %. This series' values will automatically be updated when SPF Install Base Final and SPF Failure Rate % Final are modified. |
| SPF Calculated Forecast Archive1 | Analytical forecast generated and archived for 1 forecasting cycles prior to the current cycle. |
| SPF Calculated Forecast Archive2 | Analytical forecast generated and archived for 2 forecasting cycles prior to the current cycle. |
| SPF Calculated Forecast Archive3 | Analytical forecast generated and archived for 3 forecasting cycles prior to the current cycle. |
| SPF Calculated Forecast BIAS % | Accuracy measure that indicates whether the forecast is above or below demand. Calculated by comparing shipments to SPF Calculated Forecast. |
| SPF Calculated Forecast Bias % 1 Month lag | Bias of the calculated forecast one month into the future. |
| SPF Calculated Forecast MAPE | Accuracy measure that indicates how accurately the forecast matches demand. Calculated by comparing shipments to SPF Calculated Forecast. |
| SPF Calculated Forecast MAPE 1 Month lag | Accuracy of the calculated forecast one month into the future. |
| SPF Child Spares | For Internal Use. Contains child information for Spares BOM. |
| SPF Consensus Forecast | The consensus forecast values imported into Demantra. Based on the forecast made at Base Model/All Orgs. |
| SPF Demand Type | For Internal Use. Contains demand type information for Spares BOM. |
| SPF Depth | For Internal Use. Contains Spares BOM information regarding depth in BOM. |
| SPF Engineering Estimated Failure Rate % | A manual estimate of the Failure Rate for a new part. |
| SPF Engineering Estimated Failure Rate % MAPE | MAPE measure of last three months, comparing calculated forecast based on SPF Engineering Estimated Failure Rate %. |
| SPF Failure Rate % Calculated | Result of the failure rate calculation. |
| SPF Failure Rate % Calculated MAPE | MAPE measure of last three months, comparing calculated forecast based on SPF Failure Rate % Calculated. |
| SPF Failure Rate % Final | Failure rate value used for propagation and calculation. Based on Override, Calculated, and Engineering Estimates. When the value of this series change, the change propagates to the SPF Calculated Forecast series. |
| SPF Failure Rate % Generation Method | Indicates whether the calculated or the statistical forecast will be used in the SPF Final Forecast series. |
| SPF Failure Rate % Override | Manual override of failure rate calculation, displayed as a percentage. |
| SPF Final Forecast | Forecast series that will be exported to other systems. Generated by taking into account user overrides and selected forecasting method. User overrides are applied if available; otherwise selected method is used. |
| SPF Final Forecast Archive1 | Analytical forecast generated and archived for 1 forecasting cycles prior to the current cycle. |
| SPF Final Forecast Archive2 | Analytical forecast generated and archived for 2 forecasting cycles prior to the current cycle. |
| SPF Final Forecast Archive3 | Analytical forecast generated and archived for 3 forecasting cycles prior to the current cycle. |
| SPF Final Forecast Bias % 1 Month lag | Bias of the final forecast one month into the future. |
| SPF Final Forecast MAPE 1 Month lag | Accuracy of the final forecast one month into the future. |
| SPF Forecast MAPE (In Sample) | In Sample accuracy measure, generated by the analytical engine. |
| SPF Forecast MAPE (Out of Sample) | Accuracy measure that indicates how accurately the forecast matches demand. Calculated by comparing shipments to SPF Final Forecast. |
| SPF Forecast Method | Indicates whether to use either the analytical or the calculated forecast to drive final forecast. Default is Analytical. |
| SPF Forecast Method Min | For Internal Use. Displays whether different forecast methods are configured for different combinations under the level displayed in worksheet. |
| SPF Forecast Override | Override value that serves as the final forecast. |
| SPF Forecast Volatility | Forecast volatility metric. |
| SPF Install Base Final | Value used to drive calculated forecast. In history will display historical values while in the future will display the forecast for install base. Install base overrides will supersede historical and forecasted values. |
| SPF Install Base Forecast | Displays future forecast associated with install base under contract. When the value of this series changes, the change will be propagated to the SPF Calculated Forecast series. |
| SPF Install Base Override | Allow user override of install base information. |
| SPF Install Base Simulation | Displays values associated with simulated install base under forecast. |
| SPF Install Base Under Contract | Amount of Base Model units being supported for a specific Organization. |
| SPF Item Shipment Final | Displays the final shipments. Displays user override if available, otherwise shows imported shipments. |
| SPF Item Shipment Override | User override of shipments imported into Demantra. |
| SPF Item Shipments | Stores the item shipments imported into Demantra. |
| SPF Item Usage | Stores the item usage imported into Demantra. |
| SPF Item Usage Final | Final usage value. Displays user override if available, otherwise shows loaded shipments. |
| SPF Item Usage Override | User override of item usage imported into Demantra. |
| SPF Latest Rev | Displays the latest revision information in worksheets using Spares BOM. |
| SPF Parent Install Base | For Internal Use. Propagates Install Base information to Spares BOM child nodes. |
| SPF Parent Spares | For Internal Use. Contains parent node Install Base information in Spares BOM. Used in data propagation. |
| SPF Simulation | Latest forecast generated running a simulation. |
The series in this section are provided to support Demantra integration with Oracle Complex Maintenance Repair and Overhaul (cMRO) and/or Enterprise Asset Management (eAM).
For more information about this integration, refer to "Oracle Demantra Integration with Asset Intensive Planning Applications" in the Oracle Demantra Implementation Guide.
| Series Name | Description |
|---|---|
| Available Resource Plan | Available resource capacity stored by plan. |
| Beginning On Hand Defectives | Beginning defectives inventory level. |
| Constrained Forecast Archived | Archived constrained forecast. |
| Fleet Flight Hours | Historical and projected usage hours associated with a fleet. |
| Fleet Size | Historical and projected fleet size. |
| Fleet Times Used | Historical and projected number of distinct uses associated with fleet. |
| Intransit Defectives | Current intransit inventory level (defectives). |
| Material Purchase Cost | Cost of purchased materials. |
| Material Repair Cost | Material repair cost. |
| Material Resource Cost | Material resource cost. |
| Personnel in Organization | Number of persons in organization. Can be used to drive non-maintenance forecast. |
| Plan Production Cost per Unit | Material production cost per unit stored in Plan Scenario dimension. |
| Plan Purchase Cost per Unit | Material purchase cost per unit stored in Plan Scenario dimension. |
| Plan Repair Cost per Unit | Material repair cost per unit stored in Plan Scenario dimension. |
| Plan Resource Cost per Hour | Resource cost per hour stored in Plan Scenario dimension. |
| Production Cost per Unit | Material production cost per unit stored in fact data. |
| Purchase Cost per Unit | Material purchase cost per unit stored in fact data. |
| Repair Cost per Unit | Material repair cost per unit stored in fact data. |
| Repair Plan | Planned repairs. |
| Required Capacity Archived | Archived repair capacity forecast. |
| Required Resource Plan | Required resource capacity required to meet demand. |
| Resource Cost per Hour | Resource cost per hour stored in fact data. |
| SPF Fleet Size | Historical and projected fleet size stored on SPF dimension. |
| SPF Fleet Times Used | Historical and projected number of distinct uses associated with fleet stored on SPF dimension. |
| SPF Fleet Usage Hours | Historical and projected usage hours associated with a fleet stored on SPF dimension. |
| SPF Item Usage Final | Usage information striped by work order attributes. |
| SPF Total Independent Demand | Total independent demand used to generate failure rates. For internal use only. |
| SPF Weighted Failure Rates | Failure rates weighted using independent demand. Only to be used for exporting failure rates. |
| SPF Work Order History | Aggregated work orders. Work orders are striped by several attributes and aggregated to serve as independent demand for service part BOM. |
| Total Demand | Total of material requirements used to feed Inventory Optimization. |
| Work order Demand | Projected material and resource demand for work orders by plan. |
| Work order Demand Approved | Projected material and resource demand for work orders with accepted plans. |
| Work order Demand Archive | Snapshot of work order demand stored without plan context. Information is used to drive work order accuracy calculation. |
| Work order Demand MAPE | Calculated MAPE measure for work order demand. It is calculated by comparing Work Order Demand Archive and Adjusted History series. |