Oracle Demantra Release Notes for Release 7.3.1

In release 7.3.1, Demantra provides integration with Oracle Service Part Planning (SPP) to generate a demand forecast and forecast accuracy metrics for service parts (also referred to as spare parts). The forecast can be based on usage history or shipment history. In cases where there is insufficient history for a reliable basis, Demantra bases the forecast on the item's install base population and average failure rate.

The following changes support Service Parts Forecasting (SPF):

• New workflows and integration interfaces to import service parts usage, shipment history, and install base under contract data into Demantra.
• Calculate failure rates and generate an analytical forecast for service parts. The average failure rate per week is calculated based on install base under contract data as well as historical service parts consumption.
• New SPF worksheets and related series to view the calculated forecast, statistical forecast, and forecast metrics, and to run simulations.
• New method to incrementally export changes made in Demantra worksheets to Service Parts Planning.
• Forecast demand for the latest item in a service parts supersession chain by merging together the history of all items in the chain.
• Define multiple forecasting engine configurations so that a single Demand Management installation can be leveraged for multiple lines of business that forecast in different ways. For example, Supply Chain can use CTO forecasting while Service Parts Planning can consider different data streams and analytical configurations when generating a forecast.
• Include General Levels in the forecast tree (in addition to Item and Location levels).
• New engine profiles:
• Forecast Install Base
• Forecast Spares Demand
• Simulation Install Base
• Simulation Spares Demand
• New workflows and integration interfaces to export the service parts demand forecast, forecast accuracy metrics, and other data to Oracle Service Parts Planning.

IMPORTANT: If you will be leveraging Service Parts Forecasting (SPF) functionality, refer to the Oracle Demantra Installation Guide, My Oracle Support, Document 1226023.1, for important pre and post-installation tasks.

Database performance can decline due to out-of-order tables or incorrectly defined primary keys. In this release, standard mechanisms for performing database "health checks" (both a quick and thorough version) and procedures to rebuild key data tables, like SALES_DATA and MDP_MATRIX, are available. This procedure will be dynamically created in Demantra and can be run either while the application server is live or when the application server is not running.

For details, refer to the Oracle Demantra Implementation Guide Supplement.

In this release, all analytical engine settings can be configured for each engine profile. These changes support various business processes, increase configuration flexibility, and support forecasting for service parts (SPF) and manufacturing options. When configuring the forecast tree and causal factors, users can now choose which engine profile to which the settings apply.

For details, refer to "Configuring the Forecast Tree" and "Configuring Causal Factors" in the Oracle Demantra Implementation Guide.

The Proport mechanism typically processes a large amount of data and can require substantial amount of time and resources. In this release, several new system parameters can improve Proport runtime performance by enabling parallel processing and by grouping the Proport process into several iterations.

For details, see the "Fine Tuning and Scaling Demantra" chapter in the Oracle Demantra Implementation Guide.

Some worksheets access a large amount of data which can cause them render slowly. A parallel hint can be implemented to improve the performance for specific worksheets and users. A hint specifies the number of threads used by the worksheet query and can be applied to two parts of the worksheet: generation of the combinations and retrieval of data to be displayed.

Note: Setting a hint requires manually adding a row to the WORKSHEET_HINTS table using SQL Developer or similar tool. Therefore; this task should be performed only by an experienced system or database administrator.

For details, see the "Fine Tuning and Scaling Demantra" chapter in the Oracle Demantra Implementation Guide.

In this release, Demantra users can create groups of rolling data profiles and assigned each an ID. All profiles within the group can then be executed by calling the profile group ID from a workflow.

For details, refer to the "Configuring Rolling Data" chapter in the Oracle Demantra Implementation Guide.

This release sets engine pass through as the default configuration for the analytical engine. With this configuration, the Sales_Data_Engine will not be created for every engine branch, but instead, the data will be retrieved directly from the Sales_Data table as needed.

This enhancement reduces configuration time needed to apply this configuration, improves implementation delivery times, and maintains or improves engine run times.

A new "Data Preservation" setting was added to the Population Attributes section of the Configure Levels screen in Business Modeler. This parameter is available only if the Population Type setting for the selected GL level is "Searchable" and the selected level has a Data table.

This setting controls whether the selected General Level (GL) member's dates are preserved when either the member's "from" and "until" dates change, or the member's population changes. It also controls whether the series-level settings "Copy/Paste Preservation Type" and "Move Preservation Type" are respected when a member's dates or population changes.

Examples:

• Member's date range shifts:
  Old date range = 10 weeks in 2011.
  New date range = 10 weeks in 2012.
• Member's date duration changes:
  Old duration = Brand A, 10 weeks in 2011.
  New duration = Brand A, 15 weeks in 2011
• Member's population changes:
  Old population = Brand A, 10 weeks in 2011.
  New population = Brand B, 10 weeks in 2011.

A member's date or population may change when:

• Reloading a member via an integration interface
• Editing a member in a Worksheet
• Copy/pasting a member
• Running the "Refresh Population" method

Values for the Data Preservation setting include:

• Disable: The GL member's data will not be shifted and the "preservation type" settings will be ignored (equivalent to setting Preservation Type to "Do Nothing").

This is the default setting for all General Levels except "Promotion".

• Enable for Manual Edit Only: Preservation Type settings are respected when the member's "from" and "until" date or population is changed by a manual edit in the worksheet, by Copy/Paste, or by Refresh Population.
• Enable for Manual Edit and Integration: Preservation Type settings are respected when the member's "from" and "until" date or population is changed either by a manual edit in the worksheet, by Copy/Paste, by Refresh Population, or by data integration.

This is the default setting for the Promotion level.

For more information about configuring General Levels, see "Adding a Population Attribute to a General Level" in the Oracle Demantra Implementation Guide.

In the Demantra 7.3.1.2 release, a property in the Demantra Web service WSDL file has changed (this file exposes the Web service to clients). The namespace attribute was modified as were several other attributes derived from it.

Previously the syntax used was:

http://workflow.webServices.common.demantra.com/

This has changed to:

http://com.demantra.common.webServices.workflow/

Therefore, if you used Web services in a prior Demantra release and are upgrading to 7.3.1.2 or above, you must change the client code that accesses the Demantra Web service according to the new modified WSDL file.

The following files must be modified:

• MSC_WS_DEMANTRA_WORKFLOW.wsdl
• MSC_WS_DEMANTRA_WORKFLOW.wsdl.WLS

Note that in release 7.3.1.2 Demantra supports only the WebLogic application server, so the only affected file is MSC_WS_DEMANTRA_WORKFLOW.wsdl.

For more information about Web services, see the Oracle Demantra Implementation Guide.

In this release, Demantra provides the ability to embed a URL in a series and display it as a link in any Demantra worksheet. The URL can then be used to launch a webpage or external document.

For details, refer to the Oracle Demantra Implementation Guide Supplement.

Improvements have been made to the Analytical Engine's ability to review and analyze indirect cannibalization and halo effects caused by promotions. Enhancement filters information viewed by the engine and reduces changes of overfitting.

For details, refer to "Influence Group Handling and Filtering" in the Oracle Demantra Implementation Guide Supplement.

In this release, Demantra provides integration with Oracle Complex Maintenance Repair and Overhaul (cMRO) as well as Enterprise Asset Management (eAM). These integrations enable an organization to plan for complex maintenance activities and spare parts usage. Such implementations must be able to project material and resource usage and manage the entire maintenance lifecycle for complex assets, such as aircraft engines and component assemblies.

Note: If you will be integrating Demantra with one of the supported asset intensive planning applications, please review the recommended implementation steps that are provided in the patch Readme file.

For details, refer to the Oracle Demantra Implementation Guide Supplement.

This release provides the following enhancements to the Trade Promotion Optimization (TPO) module:

• Exclusion rules: Users will be able to define a set of conditions that should not occur together in a solution. For example, you should not run a TPR simultaneously with an Ad, and discount should exclude discounts in a certain range.
• Optimized buydown: Buydown is now optimized like other variables in the optimizer. In previous releases, the buydown calculation was deterministic and calculated using the minimum retailer margin constraint. In this version, buydown is now part of the optimization problem and the value is selected by the optimization process.
• Vehicle cost overrides: The vehicle_cost expression has been changed to allow cost event overrides per causal and per transpose.
• Control over impact of financial constraints: Provide the ability to turn off financial constraints such as minimum manufacturer or retail margins.
• Define baseline: If a manual override was done to the baseline forecast, customers might require that value be used as the baseline for the promotion when calculating Revenue and Profit. In this release, we provide control over the expression denoting baseline.

In release 7.3.1.4, using Demantra Anywhere, Value Chain Planning (VCP) applications allow users to access Demantra applications and worksheets from the VCP application. A separate log in is not required, and the user does not need to open a second browser instance.

This enhancement also provides additional support for the following mobile technology applications:

• Apple iPad

For details, refer to "Embeddable Worksheets" in the Oracle Demantra Implementation Guide Supplement.

Promotion calendars graphically display promotions in an interactive calendar. In a promotion calendar, levels, table and calendar are combined into a single graphical representation. The left side displays aggregative levels and summary information. The right side displays promotions across time as part of a promotional calendar.

Each promotion appears as a separate box in the calendar, and each may display several series and their values (for example, Vehicle Type, Start and End Event dates, Event Spend).

The ability to define a Promotion Calendar is available in release 7.3.1.4. For details, refer to the Oracle Demantra Implementation Guide Supplement.

As part of Asset Intensive Planning (AIP) projected use of material and resources coming from eAM and cMRO is loaded into Demantra striped by key work order attributes.

Processing a large volume of work orders individually in ASCP for the entire projection horizon may adversely affect performance.

In EBS release 12.1.3.8, work orders may be aggregated when loaded into ASCP. This aggregation level is higher than the aggregation used in Demantra. Demantra release 7.3.1.4 supports this aggregation. Detailed work order information is loaded from ASCP to Demantra (as in previous releases) while aggregate information is imported directly from ODS.

For details, refer to the Oracle Demantra Implementation Guide Supplement.

In release 7.3.1.4, the Demantra user interface has been enhanced to provide a better user experience and enhanced security. The application interface "look and feel" has been updated to match other Oracle applications. The application has also been streamlined to reduce the number of steps or clicks to perform tasks.

User Interface Enhancements

In this release, Demantra provides the following user interface enhancements:

• Enhanced visuals including gradients and 3D graphs.
• Ability to access level methods from toolbar
• Configurable colors and fonts
• Hide frame - Each worksheet tab has a frame around it. This frame allows you to minimize, maximize, and re-size the worksheet tab. To hide these frames, click Hide Frames in the Options menu.
• Drag and drop levels and series in a table - Levels and series within a worksheet can be moved using drag and drop.
• Graph display enhancements - New graph display styles are available by right-clicking a graph and selecting an option. Graphs can now display as 3-D and the angle of the 3-D appearance can be altered by clicking and holding mouse over over the graph. Moving the pointer over the graph changes the angle of the 3-D graph highlight.
• New toolbar icons - More consistent appearance and improved usability.
• Display Methods in the Toolbar - New setting allows methods to be displayed as an icon on the toolbar.

For information about the toolbar and interface changes, refer to the Demantra Predictive Trade Planning User's Guide.

In release 7.3.1, Demantra provides integration with Oracle Service Part Planning (SPP) to generate a demand forecast and forecast accuracy metrics for service parts (also referred to as spare parts). The forecast can be based on usage history or shipment history. In cases where there is insufficient history for a reliable basis, Demantra bases the forecast on the item's install base population and average failure rate.

The following changes support Service Parts Forecasting (SPF):

• New workflows and integration interfaces to import service parts usage, shipment history, and install base under contract data into Demantra.
• Calculate failure rates and generate an analytical forecast for service parts. The average failure rate per week is calculated based on install base under contract data as well as historical service parts consumption.
• New SPF worksheets and related series to view the calculated forecast, statistical forecast, and forecast metrics, and to run simulations.
• New method to incrementally export changes made in Demantra worksheets to Service Parts Planning.
• Forecast demand for the latest item in a service parts supersession chain by merging together the history of all items in the chain.
• Define multiple forecasting engine configurations so that a single Demand Management installation can be leveraged for multiple lines of business that forecast in different ways. For example, Supply Chain can use CTO forecasting while Service Parts Planning can consider different data streams and analytical configurations when generating a forecast.
• Include General Levels in the forecast tree (in addition to Item and Location levels).
• New engine profiles:
• Forecast Install Base
• Forecast Spares Demand
• Simulation Install Base
• Simulation Spares Demand
• New workflows and integration interfaces to export the service parts demand forecast, forecast accuracy metrics, and other data to Oracle Service Parts Planning.

IMPORTANT: If you will be leveraging Service Parts Forecasting (SPF) functionality, refer to the Oracle Demantra Installation Guide, My Oracle Support Document 1226023.1 for important pre and post-installation tasks.

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Demantra in Release 7.3.1. These components may include the following: worksheets, series, levels, methods, workflows, system parameters, reports, alerts, APIs, programs, tables, views, profile options, and integration interfaces.

Technical reference material is planned for the release 7.3.1 time frame. Please check the Oracle Demantra Documentation Library, Document 443969.1, frequently for updates.

New Worksheets

The following new worksheets are associated with this feature:

• SPF: Analyze Forecast Organization Latest Revision
• SPF: Analyze Forecast Latest Revision
• SPF: Analyze Organization Base Model Spare

Changed Worksheets

There are no changed worksheets that are associated with this feature.

Obsolete Worksheets

There are no obsolete worksheets that are associated with this feature.

New Series

The following new series are associated with this feature:

• SPF Item Shipments
• SPF Item Shipment Override
• SPF Item Shipment Final
• SPF Item Usage
• SPF Item Usage Override
• SPF Item Usage Final
• SPF Consensus Forecast
• SPF Engineering Estimated Failure Rate %
• SPF Engineering Estimated Failure Rate % MAPE
• SPF Failure Rate % Calculated
• SPF Calculated Failure Rate % MAPE
• SPF Failure Rate % Generation Method
• SPF Failure Rate % Override
• SPF Failure Rate % Final
• SPF Forecast MAPE (In Sample)
• SPF Final Forecast MAPE (Out of Sample)
• SPF Analytics Forecast MAPE
• SPF Analytical Forecast BIAS %
• SPF Calculated Forecast MAPE
• SPF Calculated Forecast BIAS %
• SPF Analytical Forecast
• SPF Simulation Analytical
• SPF Calculated Forecast
• SPF Analytical Forecast Archive1
• SPF Analytical Forecast Archive2
• SPF Analytical Forecast Archive3
• SPF Calculated Forecast Archive1
• SPF Calculated Forecast Archive2
• SPF Calculated Forecast Archive3
• SPF Forecast Method
• SPF Forecast Override
• SPF Final Forecast
• SPF Final Forecast Archive1
• SPF Final Forecast Archive2
• SPF Final Forecast Archive3
• SPF Analytical Forecast MAPE 1 Month lag
• SPF Final Forecast MAPE 1 Month lag
• SPF Calculated Forecast MAPE 1 Month lag
• SPF Analytical Forecast Bias % 1 Month lag
• SPF Final Forecast Bias % 1 Month lag
• SPF Calculated Forecast Bias % 1 Month lag
• SPF Forecast Volatility
• SPF Average Demand
• SPF Install Base Under Contract
• SPF Install Base Override
• SPF Install Base Forecast
• SPF Install Base Simulation
• SPF Install Base Final
• SPF Analytical Models
• SPF Item Price

Changed Series

There are no changed series that are associated with this feature.

Obsolete Series

There are no obsolete series that are associated with this feature.

New Levels

The following SFP Location and General levels are new.

SPF Location Levels:

• Organization Type
• Organization Tier
• Country Virtual
• Region Virtual
• Time Zone Virtual
• Global Virtual

SPF General Levels:

• SPF
• SPF Base Model
• SPF Child
• SPF Demand Type
• SPF Latest Revision
• SPF Parent
• SPF Parent Item

Changed Levels

There are no changed levels that are associated with this feature.

Obsolete Levels

There are no obsolete levels that are associated with this feature.

New Methods

The following new methods are associated with this feature:

• Publish SPF Changes

Changed Methods

There are no changed methods that are associated with this feature.

Obsolete Methods

There are no obsolete methods that are associated with this feature.

New Workflows

The following new workflows are associated with this feature:

• SPF Upload Data
• SPF Incremental Upload
• Calculate Spares Forecast
• Calculate Spares Forecast for LOB
• Export Consensus Forecast for SPF
• Import SPF Base Model
• Import SPF Child
• Import SPF Data
• Import SPF Latest Revision
• Import SPF Level
• Run Forecast Install Base
• Run Forecast Spares Demand
• SPF Calc Forecast Accuracy
• SPF Full Download
• SPF Generate Forecast
• SPF GL Data Download
• SPF Archive Forecast

Changed Workflows

There are no changed workflows that are associated with this feature.

Obsolete Workflows

There are no obsolete workflows that are associated with this feature.

New System Parameters

The following new system parameters are associated with this feature:

• GLPropSupersessionMethod
• EngKeyDef_Supersession

Changed System Parameters

There are no changed system parameters that are associated with this feature.

Obsolete System Parameters

There are no obsolete system parameters that are associated with this feature.

New Windows or Pages

There are no new windows or pages that are associated with this feature.

Changed Windows or Pages

There are no changed windows or pages that are associated with this feature.

Obsolete Windows or Pages

There are no obsolete windows or pages that are associated with this feature.

New Reports

There are no new reports that are associated with this feature.

Changed Reports

There are no changed reports that are associated with this feature.

Obsolete Reports

There are no obsolete reports that are associated with this feature.

New Alerts

There are no new alerts that are associated with this feature.

Changed Alerts

There are no changed alerts that are associated with this feature.

Obsolete Alerts

There are no obsolete alerts that are associated with this feature.

New Public APIs

There are no new public APIs that are associated with this feature.

Changed Public APIs

There are no changed public APIs that are associated with this feature.

Obsolete Public APIs

There are no obsolete public APIs that are associated with this feature.

New Programs

There are no new programs that are associated with this feature.

Changed Programs

There are no changed programs that are associated with this feature.

Obsolete Programs

There are no obsolete programs that are associated with this feature.

New Tables

The following new tables are associated with this feature:

• init_params_121
• init_params_122
• init_params_141
• init_params_142
• BIIO_SPF_BASE_MODEL
• BIIO_SPF_BASE_MODEL_ERR
• BIIO_SPF_CHILD
• BIIO_SPF_CHILD_ERR
• BIIO_SPF_DATA
• BIIO_SPF_DATA_ERR
• BIIO_SPF_LATEST_REVISION
• BIIO_SPF_LATEST_REVISION_ERR
• BIIO_SPF_LEVEL
• BIIO_SPF_LEVEL_ERR
• BIIO_SPF_POPULATION
• BIIO_SPF_POPULATION_ERR
• BIIO_SPF_SALES_FCST_DATA
• BIIO_SPF_SALES_FCST_DATA_ERR
• BIIO_SPF_SPARES_HIST_DATA
• BIIO_SPF_SPARES_HIST_DATA_ERR

Changed Tables

There are no changed tables that are associated with this feature.

Obsolete Tables

There are no obsolete tables that are associated with this feature.

New Views

There are no new views that are associated with this feature.

Changed Views

There are no changed views that are associated with this feature.

Obsolete Views

There are no obsolete views that are associated with this feature.

New Profile Options

There are no new profile options that are associated with this feature.

Changed Profile Options

There are no changed profile options that are associated with this feature.

Obsolete Profile Options

There are no obsolete profile options that are associated with this feature.

New Integration Interfaces

The following new integration interfaces are associated with this feature:

• SPF

Data/level profiles for SPF integration interface:

• IMPORT_SPF_DATA
• IMPORT_SPF_SALES_FORECAST_DATA
• IMPORT_SPF_SHIPMENT_HISTORY
• IMPORT_SPF_BASE_MODEL
• IMPORT_SPF_CHILD
• IMPORT_SPF_LATEST_REVISION
• IMPORT_SPF_LEVEL
• SPF Upload Forecast Data & Metrics

Data/level profiles for SPF Upload Forecast Data & Metrics integration interface:

• SPF Upload Final Forecast
• SPF Upload Metrics

Changed Integration Interfaces

There are no changed integration interfaces that are associated with this feature.

Obsolete Integration Interfaces

There are no obsolete integration interfaces that are associated with this feature.

New and Changed Setup Steps

This section lists the setup steps that were added or changed for Oracle Demantra in Release 7.3.1. For additional details about performing the setup steps listed below, refer to the documentation described in the 2.1 Online Help and PDF Documentation.

If you plan to use the new SPF feature, then complete the following steps:

• Review any existing engine profiles to ensure they are not referencing init_params_XXX tables used by some of the new seeded engine profiles
• Enable the seeded "SPF" Rolling Profile Group

For details about performing these tasks, please refer to "Additional Upgrade Steps" in the Oracle Demantra Installation Guide, My Oracle Support Document 1226023.1.

Upgrade Considerations

Refer to New and Changed Setup Steps.

Sizing

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

In this release, all analytical engine settings can be configured for each engine profile. These changes support various business processes, increase configuration flexibility, and support forecasting for service parts (SPF) and manufacturing options. When configuring the forecast tree and causal factors, users can now choose which engine profile to which the settings apply.

For details, refer to the "Configuring Rolling Data" chapter in the Oracle Demantra Implementation Guide.

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Demantra in Release 7.3.1. These components may include the following: worksheets, series, levels, methods, workflows, system parameters, reports, alerts, APIs, programs, tables, views, profile options, and integration interfaces.

Technical reference material is planned for the release 7.3.1 time frame. Please check the Oracle Demantra Documentation Library, Document 443969.1, frequently for updates.

New Worksheets

There are no new worksheets that are associated with this feature.

Changed Worksheets

There are no changed worksheets that are associated with this feature.

Obsolete Worksheets

There are no obsolete worksheets that are associated with this feature.

New Series

There are no new series that are associated with this feature.

Changed Series

There are no changed series that are associated with this feature.

Obsolete Series

There are no obsolete series that are associated with this feature.

New Levels

There are no new levels that are associated with this feature.

Changed Levels

There are no changed levels that are associated with this feature.

Obsolete Levels

There are no obsolete levels that are associated with this feature.

New Methods

There are no new methods that are associated with this feature.

Changed Methods

There are no changed methods that are associated with this feature.

Obsolete Methods

There are no obsolete methods that are associated with this feature.

New Workflows

There are no new workflows that are associated with this feature.

Changed Workflows

There are no changed workflows that are associated with this feature.

Obsolete Workflows

There are no obsolete workflows that are associated with this feature.

New System Parameters

The following new system parameters are associated with this feature:

• EngTabDef_Parameters
• EngTabDef_HistoryForecast
• EngTabDef_Matrix
• EngDimDef_ItemOrLoc
• EngKeyDefPK
• EngTabDef_Inputs

Changed System Parameters

There are no changed system parameters that are associated with this feature.

Obsolete System Parameters

There are no obsolete system parameters that are associated with this feature.

New Windows or Pages

There are no new windows or pages that are associated with this feature.

Changed Windows or Pages

There are no changed windows or pages that are associated with this feature.

Obsolete Windows or Pages

There are no obsolete windows or pages that are associated with this feature.

New Reports

There are no new reports that are associated with this feature.

Changed Reports

There are no changed reports that are associated with this feature.

Obsolete Reports

There are no obsolete reports that are associated with this feature.

New Alerts

There are no new alerts that are associated with this feature.

Changed Alerts

There are no changed alerts that are associated with this feature.

Obsolete Alerts

There are no obsolete alerts that are associated with this feature.

New Public APIs

There are no new public APIs that are associated with this feature.

Changed Public APIs

There are no changed public APIs that are associated with this feature.

Obsolete Public APIs

There are no obsolete public APIs that are associated with this feature.

New Programs

There are no new programs that are associated with this feature.

Changed Programs

There are no changed programs that are associated with this feature.

Obsolete Programs

There are no obsolete programs that are associated with this feature.

New Tables

There are no new tables that are associated with this feature.

Changed Tables

The following changed tables are associated with this feature:

• CAUSAL_FACTORS
• ENGINE_CACHES
• FORECAST_TREE
• FORECAST_TREE_STRATEGY
• ITEMS_LEVELS
• LOC_LEVELS
• M3_CAUSAL_FACTORS
• MODEL
• MODEL_MATRIX
• PARAM_MATRIX
• PROPORT_JOB_LIST
• PROPORT_LEVELS

Obsolete Tables

There are no obsolete tables that are associated with this feature.

New Views

There are no new views that are associated with this feature.

Changed Views

There are no changed views that are associated with this feature.

Obsolete Views

There are no obsolete views that are associated with this feature.

New Profile Options

There are no new profile options that are associated with this feature.

Changed Profile Options

There are no changed profile options that are associated with this feature.

Obsolete Profile Options

There are no obsolete profile options that are associated with this feature.

New Integration Interfaces

There are no new integration interfaces that are associated with this feature.

Changed Integration Interfaces

There are no changed integration interfaces that are associated with this feature.

Obsolete Integration Interfaces

There are no obsolete integration interfaces that are associated with this feature.

New and Changed Setup Steps

This section lists the setup steps that were added or changed for Oracle Demantra in Release 7.3.1. For additional details about performing the setup steps listed below, refer to the documentation described in the 2.1 Online Help and PDF Documentation.

To enable this feature, the New Parameters listed in the previous section must be defined.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

The Proport mechanism typically processes a large amount of data and can require substantial amount of time and resources. In this release, several new system parameters can improve Proport runtime performance by enabling parallel processing and by grouping the Proport process into several iterations.

For details, see the "Fine Tuning and Scaling Demantra" chapter in the Oracle Demantra Implementation Guide.

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Demantra in Release 7.3.1. These components may include the following: worksheets, series, levels, methods, workflows, system parameters, reports, alerts, APIs, programs, tables, views, profile options, and integration interfaces.

Technical reference material is planned for the release 7.3.1 time frame. Please check the Oracle Demantra Documentation Library, Document 443969.1, frequently for updates.

New Worksheets

There are no new worksheets that are associated with this feature.

Changed Worksheets

There are no changed worksheets that are associated with this feature.

Obsolete Worksheets

There are no obsolete worksheets that are associated with this feature.

New Series

There are no new series that are associated with this feature.

Changed Series

There are no changed series that are associated with this feature.

Obsolete Series

There are no obsolete series that are associated with this feature.

New Levels

There are no new levels that are associated with this feature.

Changed Levels

There are no changed levels that are associated with this feature.

Obsolete Levels

There are no obsolete levels that are associated with this feature.

New Methods

There are no new methods that are associated with this feature.

Changed Methods

There are no changed methods that are associated with this feature.

Obsolete Methods

There are no obsolete methods that are associated with this feature.

New Workflows

There are no new workflows that are associated with this feature.

Changed Workflows

There are no changed workflows that are associated with this feature.

Obsolete Workflows

There are no obsolete workflows that are associated with this feature.

New System Parameters

The following new system parameters are associated with this feature:

• ProportParallelJobs
• ProportRunsInCycle
• ProportTableLabel

For details, see the "Fine Tuning and Scaling Demantra" chapter in the Oracle Demantra Implementation Guide.

Changed System Parameters

There are no changed system parameters that are associated with this feature.

Obsolete System Parameters

There are no obsolete system parameters that are associated with this feature.

New Windows or Pages

There are no new windows or pages that are associated with this feature.

Changed Windows or Pages

There are no changed windows or pages that are associated with this feature.

Obsolete Windows or Pages

There are no obsolete windows or pages that are associated with this feature.

New Reports

There are no new reports that are associated with this feature.

Changed Reports

There are no changed reports that are associated with this feature.

Obsolete Reports

There are no obsolete reports that are associated with this feature.

New Alerts

There are no new alerts that are associated with this feature.

Changed Alerts

There are no changed alerts that are associated with this feature.

Obsolete Alerts

There are no obsolete alerts that are associated with this feature.

New Public APIs

There are no new public APIs that are associated with this feature.

Changed Public APIs

There are no changed public APIs that are associated with this feature.

Obsolete Public APIs

There are no obsolete public APIs that are associated with this feature.

New Programs

There are no new programs that are associated with this feature.

Changed Programs

There are no changed programs that are associated with this feature.

Obsolete Programs

There are no obsolete programs that are associated with this feature.

New Tables

There are no new tables that are associated with this feature.

Changed Tables

There are no changed tables that are associated with this feature.

Obsolete Tables

There are no obsolete tables that are associated with this feature.

New Views

There are no new views that are associated with this feature.

Changed Views

There are no changed views that are associated with this feature.

Obsolete Views

There are no obsolete views that are associated with this feature.

New Profile Options

There are no new profile options that are associated with this feature.

Changed Profile Options

There are no changed profile options that are associated with this feature.

Obsolete Profile Options

There are no obsolete profile options that are associated with this feature.

New Integration Interfaces

There are no new integration interfaces that are associated with this feature.

Changed Integration Interfaces

There are no changed integration interfaces that are associated with this feature.

Obsolete Integration Interfaces

There are no obsolete integration interfaces that are associated with this feature.

New and Changed Setup Steps

This section lists the setup steps that were added or changed for Oracle Demantra in Release 7.3.1. For additional details about performing the setup steps listed below, refer to the documentation described in the 2.1 Online Help and PDF Documentation.

To enable this feature, the new system parameters listed above must be defined.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

Some worksheets access a large amount of data which can cause them render slowly. A parallel hint can be implemented to improve the performance for specific worksheets and users. A hint specifies the number of threads used by the worksheet query and can be applied to two parts of the worksheet: generation of the combinations and retrieval of data to be displayed.

Note: Setting a hint requires manually adding a row to the WORKSHEET_HINTS table using SQL Developer or similar tool. Therefore, this task should be performed only by an experienced system or database administrator.

For details, see the "Fine Tuning and Scaling Demantra" chapter in the Oracle Demantra Implementation Guide.

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Demantra in Release 7.3.1. These components may include the following: worksheets, series, levels, methods, workflows, system parameters, reports, alerts, APIs, programs, tables, views, profile options, and integration interfaces.

Technical reference material is planned for the release 7.3.1 time frame. Please check the Oracle Demantra Documentation Library, Document 443969.1, frequently for updates.

New Worksheets

There are no new worksheets that are associated with this feature.

Changed Worksheets

There are no changed worksheets that are associated with this feature.

Obsolete Worksheets

There are no obsolete worksheets that are associated with this feature.

New Series

There are no new series that are associated with this feature.

Changed Series

There are no changed series that are associated with this feature.

Obsolete Series

There are no obsolete series that are associated with this feature.

New Levels

There are no new levels that are associated with this feature.

Changed Levels

There are no changed levels that are associated with this feature.

Obsolete Levels

There are no obsolete levels that are associated with this feature.

New Methods

There are no new methods that are associated with this feature.

Changed Methods

There are no changed methods that are associated with this feature.

Obsolete Methods

There are no obsolete methods that are associated with this feature.

New Workflows

There are no new workflows that are associated with this feature.

Changed Workflows

There are no changed workflows that are associated with this feature.

Obsolete Workflows

There are no obsolete workflows that are associated with this feature.

New System Parameters

There are no new system parameters that are associated with this feature.

Changed System Parameters

There are no changed system parameters that are associated with this feature.

Obsolete System Parameters

There are no obsolete system parameters that are associated with this feature.

New Windows or Pages

There are no new windows or pages that are associated with this feature.

Changed Windows or Pages

There are no changed windows or pages that are associated with this feature.

Obsolete Windows or Pages

There are no obsolete windows or pages that are associated with this feature.

New Reports

There are no new reports that are associated with this feature.

Changed Reports

There are no changed reports that are associated with this feature.

Obsolete Reports

There are no obsolete reports that are associated with this feature.

New Alerts

There are no new alerts that are associated with this feature.

Changed Alerts

There are no changed alerts that are associated with this feature.

Obsolete Alerts

There are no obsolete alerts that are associated with this feature.

New Public APIs

There are no new public APIs that are associated with this feature.

Changed Public APIs

There are no changed public APIs that are associated with this feature.

Obsolete Public APIs

There are no obsolete public APIs that are associated with this feature.

New Programs

There are no new programs that are associated with this feature.

Changed Programs

There are no changed programs that are associated with this feature.

Obsolete Programs

There are no obsolete programs that are associated with this feature.

New Tables

The following new tables are associated with this feature:

• WORKSHEET_HINTS

Changed Tables

There are no changed tables that are associated with this feature.

Obsolete Tables

There are no obsolete tables that are associated with this feature.

New Views

There are no new views that are associated with this feature.

Changed Views

There are no changed views that are associated with this feature.

Obsolete Views

There are no obsolete views that are associated with this feature.

New Profile Options

There are no new profile options that are associated with this feature.

Changed Profile Options

There are no changed profile options that are associated with this feature.

Obsolete Profile Options

There are no obsolete profile options that are associated with this feature.

New Integration Interfaces

There are no new integration interfaces that are associated with this feature.

Changed Integration Interfaces

There are no changed integration interfaces that are associated with this feature.

Obsolete Integration Interfaces

There are no obsolete integration interfaces that are associated with this feature.

New and Changed Setup Steps

This section lists the setup steps that were added or changed for Oracle Demantra in Release 7.3.1. For additional details about performing the setup steps listed below, refer to the documentation described in the 2.1 Online Help and PDF Documentation.

Some manual setup is required to implement worksheet hints. For details, refer to the "Fine Tuning and Scaling Demantra" chapter in the Oracle Demantra Implementation Guide.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

In this release, Demantra users can create groups of rolling data profiles and assigned each an ID. All profiles within the group can then be executed by calling the profile group ID from a workflow.

For details, refer to the "Configuring Rolling Data" chapter in the Oracle Demantra Implementation Guide.

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Demantra in Release 7.3.1. These components may include the following: worksheets, series, levels, methods, workflows, system parameters, reports, alerts, APIs, programs, tables, views, profile options, and integration interfaces.

Technical reference material is planned for the release 7.3.1 time frame. Please check the Oracle Demantra Documentation Library, Document 443969.1, frequently for updates.

New Worksheets

There are no new worksheets that are associated with this feature.

Changed Worksheets

There are no changed worksheets that are associated with this feature.

Obsolete Worksheets

There are no obsolete worksheets that are associated with this feature.

New Series

There are no new series that are associated with this feature.

Changed Series

There are no changed series that are associated with this feature.

Obsolete Series

There are no obsolete series that are associated with this feature.

New Levels

There are no new levels that are associated with this feature.

Changed Levels

There are no changed levels that are associated with this feature.

Obsolete Levels

There are no obsolete levels that are associated with this feature.

New Methods

There are no new methods that are associated with this feature.

Changed Methods

There are no changed methods that are associated with this feature.

Obsolete Methods

There are no obsolete methods that are associated with this feature.

New Workflows

There are no new workflows that are associated with this feature.

Changed Workflows

There are no changed workflows that are associated with this feature.

Obsolete Workflows

There are no obsolete workflows that are associated with this feature.

New System Parameters

There are no new system parameters that are associated with this feature.

Changed System Parameters

There are no changed system parameters that are associated with this feature.

Obsolete System Parameters

There are no obsolete system parameters that are associated with this feature.

New Windows or Pages

There are no new windows or pages that are associated with this feature.

Changed Windows or Pages

There are no changed windows or pages that are associated with this feature.

Obsolete Windows or Pages

There are no obsolete windows or pages that are associated with this feature.

New Reports

There are no new reports that are associated with this feature.

Changed Reports

There are no changed reports that are associated with this feature.

Obsolete Reports

There are no obsolete reports that are associated with this feature.

New Alerts

There are no new alerts that are associated with this feature.

Changed Alerts

There are no changed alerts that are associated with this feature.

Obsolete Alerts

There are no obsolete alerts that are associated with this feature.

New Public APIs

There are no new public APIs that are associated with this feature.

Changed Public APIs

There are no changed public APIs that are associated with this feature.

Obsolete Public APIs

There are no obsolete public APIs that are associated with this feature.

New Programs

There are no new programs that are associated with this feature.

Changed Programs

There are no changed programs that are associated with this feature.

Obsolete Programs

There are no obsolete programs that are associated with this feature.

New Tables

The following new tables are associated with this feature:

• ROLLING_GROUP_PROFILES
• ROLLING_GROUPS

Changed Tables

There are no changed tables that are associated with this feature.

Obsolete Tables

There are no obsolete tables that are associated with this feature.

New Views

There are no new views that are associated with this feature.

Changed Views

There are no changed views that are associated with this feature.

Obsolete Views

There are no obsolete views that are associated with this feature.

New Profile Options

There are no new profile options that are associated with this feature.

Changed Profile Options

There are no changed profile options that are associated with this feature.

Obsolete Profile Options

There are no obsolete profile options that are associated with this feature.

New Integration Interfaces

There are no new integration interfaces that are associated with this feature.

Changed Integration Interfaces

There are no changed integration interfaces that are associated with this feature.

Obsolete Integration Interfaces

There are no obsolete integration interfaces that are associated with this feature.

New and Changed Setup Steps

This section lists the setup steps that were added or changed for Oracle Demantra in Release 7.3.1. For additional details about performing the setup steps listed below, refer to the documentation described in the 2.1 Online Help and PDF Documentation.

Some manual setup is required to implement rolling profile groups. For details, refer to the "Configuring Rolling Data" chapter in the Oracle Demantra Implementation Guide.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Demantra in this release. These components may include the following: worksheets, series, levels, methods, workflows, system parameters, reports, messages, APIs, programs, tables, views, profile options, and integration interfaces.

Technical reference material is planned for the release 7.3.1 time frame. Please check the Oracle Demantra Documentation Library, Document 443969.1, frequently for updates.

For details, refer to Oracle Demantra Demand Management User's Guide Supplement and Oracle Demantra Implementation Guide Supplement.

Changed Windows or Pages

This table lists the changed windows and pages.

New and Changed Setup Steps

There are no new or changed setup steps for this feature.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

Tablespace Considerations

There are no tablespace considerations for this feature.

Performance Considerations

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

In this release, Demantra provides integration with Oracle Complex Maintenance, Repair, and Overhaul (cMRO) as well as Enterprise Asset Management (eAM). These integrations enable an organization to plan for complex maintenance activities and spare parts usage. Such implementations must be able to project material and resource usage and manage the entire maintenance lifecycle for complex assets, such as aircraft engines and component assemblies.

For details, refer to the Oracle Demantra Implementation Guide Supplement.

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Demantra in this release. These components may include the following: worksheets, series, levels, methods, workflows, system parameters, reports, alerts, APIs, programs, tables, views, profile options, and integration interfaces.

New Series

• Available Resource Plan
• Beginning On Hand Defectives
• Constrained Forecast Archived
• Demand Variability
• Fleet Flight Hours
• Fleet Size
• Fleet Times Used
• Intransit Defectives
• Personnel in Organization
• Plan Purchase Cost Per Unit
• Plan Repair Cost Per Unit
• Plan Resource Cost Per Hour
• Production Cost Per Unit
• Purchase Cost Per Unit
• Repair Cost Per Unit
• Repair Plan
• Required Capacity Archived
• Required Resource Plan
• Resource Cost Per Hour
• SPF Fleet Size
• SPF Fleet Times Used
• SPF Fleet Usage Hours
• SPF Item Usage Final
• SPF Total Independent Demand
• SPF Weighted Failure Rates
• SPF Work Order History
• Total Demand
• Work Order Demand
• Work Order Demand Approved
• Work Order Demand Archive
• Work Order Demand MAPE

New Series Group

• SPF-cMRO

New Profile Options

• MSD_DEM: Include organization in CMRO Data Load
• MSD_DEM: Simulation Set Name
• MSD_DEM: Enable Supply Plan Download for work orders

New Tables

• BIIO_SPF_VISIT_TYPE
• BIIO_SPF_VISIT_STAGE_TYPE
• BIIO_SPF_MAINTENANCE_TYPE
• BIIO_SPF_CMRO_DATA
• T_SRC_SALES_TMPL
• BIIO_SPF_CMRO_DATA
• T_SRC_SALES_TMPL
• BIIO_SPF_CMRO_DATA
• BIIO_SPF_CMRO_FLEET_DATA
• BIIO_SPF_CMRO_FLEET_DATA
• BIIO_SPF_CMRO_FLEET_DATA
• BIEO_SPF_PLNFCT
• BIEO_SPF_NUWO_FCST
• BIEO_NM_FCST_V
• BIEO_TOTAL_DEMAND_V
• BIEO_WORK_ORDER_DEMAND_ORG

New Workflows

• SPF - cMRO - Import cMRO Data
• SPF - cMRO - Import cMRO Fleet Data
• SPF - cMRO Export Failure Rates
• SPF - cMRO - Generate non-Routine Maintenance Forecast
• SPF - cMRO Export non-Routine Maintenance Forecast
• SPF - cMRO - Import cMRO or EAM Costs
• SPF - cMRO - Export Non- Maintenance Forecast
• SPF - cMRO - Calculate Demand Variability
• SPF - cMRO Export Total Demand and Demand Variability

New Integration Interfaces

• Export Planning Factors
• SPF Upload Forecast Data & Metrics
• Unit Cost

New Index

• Cost Adjustment Factor

New Engine Profiles

• Forecast non-UMP Work Orders

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Demantra in this release. These components may include the following: worksheets, series, levels, methods, workflows, system parameters, reports, alerts, APIs, programs, tables, views, profile options, and integration interfaces.

New System Parameters

• IGLIndirectLimit

Changed System Parameters

• UseEnvelope - This parameter now accepts a value of '3'.

New and Changed Setup Steps

There are no new or changed setup steps for this feature.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

There are no tablespace considerations for this feature.

Performance Considerations

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Demantra in this release. These components may include the following: worksheets, series, levels, methods, workflows, system parameters, reports, alerts, APIs, programs, tables, views, profile options, and integration interfaces.

Changed Windows or Pages

• Series Display properties window - Tthe Hyperlink option has been added to the Display Format setting.

New and Changed Setup Steps

There are no new or changed setup steps for this feature.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

There are no tablespace considerations for this feature.

Performance Considerations

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Demantra in this release. These components may include the following: worksheets, series, levels, methods, workflows, system parameters, reports, alerts, APIs, programs, tables, views, profile options, and integration interfaces.

For details, refer to the Oracle Demantra Implementation Guide Supplement.

New Procedures

• run_table_reorg.sql

New System Parameters

• MIN_NUMROWS_FOR_REORG
• QUICK_CHECK_TIMEOUT
• THOROUGH_CHECK_INTERVAL
• THOROUGH_CHECK_TIMEOUT

New and Changed Setup Steps

There are no new or changed setup steps for this feature.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

There are no tablespace considerations for this feature.

Performance Considerations

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

This release provides the following enhancements to the Trade Promotion Optimization (TPO) module:

• Exclusion rules: Users will be able to define a set of conditions that should not occur together in a solution. For example, you should not run a TPR simultaneously with an Ad, and discount should exclude discounts in a certain range.
• Optimized buydown: Buydown is now optimized like other variables in the optimizer. In previous releases, the buydown calculation was deterministic and calculated using the minimum retailer margin constraint. In this version, buydown is now part of the optimization problem and the value is selected by the optimization process.
• Vehicle cost overrides: The vehicle_cost expression has been changed to allow cost event overrides per causal and per transpose.
• Control over impact of financial constraints: Provide the ability to turn off financial constraints such as minimum manufacturer or retail margins.
• Define baseline: If a manual override was done to the baseline forecast, customers might require that value be used as the baseline for the promotion when calculating Revenue and Profit. In this release, we provide control over the expression denoting baseline.

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Demantra in this release. These components may include the following: worksheets, series, levels, methods, workflows, system parameters, reports, messages, APIs, programs, tables, views, profile options, and integration interfaces.

Refer to the "Oracle Demantra Release 12.1.3.7 (7.3.1.3) Transfer of Information" for more information. Please check the Oracle Demantra Documentation Library, Document 443969.1, frequently for updates.

New Tables

This table lists the new tables.

New and Changed Setup Steps

There are no new or changed setup steps for this feature.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

Tablespace Considerations

There are no tablespace considerations for this feature.

Performance Considerations

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

In release 7.3.1.4, using Demantra Anywhere, Value Chain Planning (VCP) applications allow users to access Demantra applications and worksheets from the VCP application. A separate log in is not required, and the user does not need to open a second browser instance.

This enhancement also provides additional support for the following mobile technology applications:

• Apple iPad

For details, refer to "Embeddable Worksheets" in the Oracle Demantra Implementation Guide Supplement.

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Demantra in this release. These components may include the following: worksheets, series, levels, methods, workflows, system parameters, reports, alerts, APIs, programs, tables, views, profile options, and integration interfaces.

Please check the Oracle Demantra Documentation Library, Document 443969.1, frequently for updates.

New and Changed Setup Steps

This section lists the setup steps that were added or changed in Oracle Demantra in this release. For additional details about performing the setup steps listed below, refer to the documentation described in 2.1 Online Help and PDF Documentation.

To enable this feature, communication is established via a URL with specified parameters. The login process requires Oracle Single Sign On, and both applications must be registered with the same SSO server. The Demantra application must be configured to use Demantra Anywhere (go to Security > Create/Modify User, select a user, go to Modules, and enable Demantra Anywhere).

Refer to the following:

• See "Access to Embedded Demantra Worksheets" in the Oracle Advanced Planning Command Center User's Guide Supplement.
• See "Embeddable Worksheets" in the Oracle Demantra Implementation Guide Supplement.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

Tablespace Considerations

There are no tablespace considerations for this feature.

Performance Considerations

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

Promotion calendars graphically display promotions in an interactive calendar. In a promotion calendar, levels, table and calendar are combined into a single graphical representation. The left side displays aggregative levels and summary information. The right side displays promotions across time as part of a promotional calendar.

Each promotion appears as a separate box in the calendar, and each may display several series and their values (for example, Vehicle Type, Start and End Event dates, Event Spend).

The ability to define a Promotion Calendar is available in release 7.3.1.4. For details, refer to the Oracle Demantra Implementation Guide Supplement.

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Demantra in this release. These components may include the following: worksheets, series, levels, methods, workflows, system parameters, reports, alerts, APIs, programs, tables, views, profile options, and integration interfaces.

Please check the Oracle Demantra Documentation Library, Document 443969.1, frequently for updates.

New System Parameters

This table lists system parameters that are new.

Changed Windows or Pages

This table lists the changed windows and pages.

New Tables

This table lists the new tables.

New Views

This table lists the new views.

New and Changed Setup Steps

This section lists the setup steps that were added or changed in Oracle Demantra in this release. For additional details about performing the setup steps listed below, refer to the documentation described in 2.1 Online Help and PDF Documentation.

Define your promotion calendars using the new tables and system parameters mentioned above. Refer to "Defining Promotion Calendar" in the Oracle Demantra Implementation Guide Supplement for details.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

Tablespace Considerations

There are no tablespace considerations for this feature.

Performance Considerations

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

As part of Asset Intensive Planning (AIP) projected use of material and resources coming from eAM and cMRO is loaded into Demantra striped by key work order attributes.

Processing a large volume of work orders individually in ASCP for the entire projection horizon may adversely affect performance.

In EBS release 12.1.3.8, work orders may be aggregated when loaded into ASCP. This aggregation level is higher than the aggregation used in Demantra. Demantra release 7.3.1.4 supports this aggregation. Detailed work order information is loaded from ASCP to Demantra (as in previous releases) while aggregate information is imported directly from ODS.

For details, refer to the Oracle Demantra Implementation Guide Supplement.

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Demantra in this release. These components may include the following: worksheets, series, levels, methods, workflows, system parameters, reports, alerts, APIs, programs, tables, views, profile options, and integration interfaces.

Please check the Oracle Demantra Documentation Library, Document 443969.1, frequently for updates.

New and Changed Setup Steps

This section lists the setup steps that were added or changed for Oracle Demantra in this release. For additional details about performing the setup steps listed below, refer to the documentation described in 2.1 Online Help and PDF Documentation.

Set the Maintenance Work Order options for the appropriate time periods in the Aggregation tab of the Plan Options page. Refer to "Understanding Aggregate Work Orders" in the Oracle Demantra Implementation Guide Supplement for details.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

Tablespace Considerations

There are no tablespace considerations for this feature.

Performance Considerations

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

In release 7.3.1.4, the Demantra user interface has been enhanced to provide a better user experience and enhanced security. The application interface "look and feel" has been updated to match other Oracle applications. The application has also been streamlined to reduce the number of steps or clicks to perform tasks.

User Interface Enhancements

In this release, Demantra provides the following user interface enhancements:

• Enhanced visuals including gradients and 3D graphs.
• Ability to access level methods from toolbar
• Configurable colors and fonts
• Hide frame - Each worksheet tab has a frame around it. This frame allows you to minimize, maximize, and re-size the worksheet tab. To hide these frames, click Hide Frames in the Options menu.
• Drag and drop levels and series in a table - Levels and series within a worksheet can be moved using drag and drop.
• Graph display enhancements - New graph display styles are available by right-clicking a graph and selecting an option. Graphs can now display as 3-D and the angle of the 3-D appearance can be altered by clicking and holding mouse over over the graph. Moving the pointer over the graph changes the angle of the 3-D graph highlight.
• New toolbar icons - More consistent appearance and improved usability.
• Display Methods in the Toolbar - New setting allows methods to be displayed as an icon on the toolbar.

For information about the toolbar and interface changes, refer to the Demantra Predictive Trade Planning User's Guide.

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Demantra in this release. These components may include the following: worksheets, series, levels, methods, workflows, system parameters, reports, alerts, APIs, programs, tables, views, profile options, and integration interfaces.

Please check the Oracle Demantra Documentation Library, Document 443969.1, frequently for updates.

New System Parameters

This table lists system parameters that are new.

Changed Windows or Pages

This table lists the changed windows and pages.

New and Changed Setup Steps

This section lists the setup steps that were added or changed for Oracle Demantra in this release. For additional details about performing the setup steps listed below, refer to the documentation described in 2.1 Online Help and PDF Documentation.

Set the Level Method Edit Promotion - General Properties Window - Configure Methods dialog in Business Modeler to display Level Method in the toolbar.

Upgrade Considerations

There are no upgrade considerations for this feature.

Sizing

Tablespace Considerations

There are no tablespace considerations for this feature.

Performance Considerations

XMLDB Usage

There are no XMLDB usages for this feature.

Load Balancing

There is no load balancing information for this feature.

New Bulk Interfaces

There are no new bulk interfaces for this feature.

July 1, 2009

When using the Mozilla Firefox browser, if a Demantra user closes the browser using the X icon, it is possible to restore the session by re-launching a new Firefox browser. In this scenario, the login page is not displayed and the user is not required to enter a username and password.

Modify Mozilla Firefox configuration settings as follows:

1. Select Tools > Options > Startup > tab Main.
2. Verify that when Firefox starts, it is not set to Show my windows and tabs from last time. Change this setting as required.
3. Navigate to tab Security and verify that Remember password for sites is not selected.
4. Save your changes.

Fix not yet available.

July 1, 2009

Oracle Demantra may create database tables in a single table space rather than the table spaces that you specified when you installed Oracle Demantra. This may affect system performance.

The database administrator can manually create key tables and indexes with the desired table spaces after running the Oracle Demantra Installer.

Fix not yet available.

June 1, 2010

A Demantra user wants to review and/or simulate only General Level data, such as CTO Base Model demand, in a worksheet. If you include only General Levels in a worksheet, meaningful results for sales_data series such as Adjusted History, Simulation, and Consensus Forecast cannot be viewed. The values are displayed as the total across the entire system population, which is not expected behavior and can negatively affect system performance. It also does not provide sufficient context for simulation.

Follow these steps to review data with only a CTO level, such as the Base Model:

1. If the data is exclusively General Level data series, construct a worksheet using only General Levels, such as CTO or promotion levels.
2. If the data includes a mix of General Level and sales data series, include an item level in the hierarchy.

For example, if you want to review, adjust, and simulate independent demand for your base model, construct a worksheet with the item level, Parent Item level and filter on Demand Type = Base Model. If you want to review, adjust and simulate promotions, you must construct a worksheet with an item level, such as Promotion Group, in addition to promotion levels.

Fix not yet available.

November 2010

Failure Rate Calculation

As implemented in Demantra 7.3.1, the following series currently use straight average, not weighted average:

• SPF Calculated Forecast
• SPF Failure Rate % Calculated
• SPF Failure Rate % Final
• SPF Failure Rate % Override
• SPF Final Forecast

The user can see a discrepancy between client propagation (based on straight average) and update hook calculation (performed at lowest level).

This issue can cause these series to give incorrect values at aggregate levels, and cause client expressions to perform incorrect propagations. The back-end hook will always calculate and store the correct values.

Use two sets of series. One set will be used for client expression failure rates. These can use weighted averages. The other set will be used for SPF Batch and hook calculations. These will not have weighting. Since batch and hook calculations always run on lowest-level data, there is no need for any weighting.

The series that drive edit propagation can be changed. For back-end, worksheet hook and batch calculations, modify the spf_series_definition table. For front end, client-expression calculations, modify the tree_view_edit_propagation table.

Fix not yet available.

November 2010

When running the engine in PE mode, rows in the PROMOTION_DATA table that contain non-null records for another engine profile may be deleted.

To ensure that the non-null rows are not deleted when the engine runs with a different engine profile, set the engine parameter DeleteIsSelfCondition to "0" for that profile.

Fix not yet available.

November 2010

(Known issue with Demantra documentation - This information was not included in the release 7.3.1 Oracle Demantra Implementation Guide.)

The system parameter "SimNotification", which is defined in the APS_PARAMS table, is available in release 7.3.1 but was not included in the release 7.3.1 Oracle Demantra Implementation Guide.

This parameter controls whether Demantra displays a message in the following scenario:

• A simulation that has not yet been accepted or rejected already exists for the current user and worksheet.
• The Accept Simulation, Reject Simulation, or both options are disabled for the current user.
• The user chooses to create a new simulation.

If this option is set to True (the default), Demantra displays a message indicating that a simulation already exists. The user can then either accept or reject it based on their privileges.

If this option is set to False, Demantra does not display a message and automatically accepts or rejects the simulation based on the user's privileges.

November 2010

(Known issue with Demantra documentation - This information was not included in the release 7.3.1 Oracle Demantra Implementation Guide.)

Flagging a new User Group as a "Collaboration Group" does not provide access to the Workflow Manager.

To enable a new User Group to access Workflow Manager:

1. Determine the application_id of the new group from the APS_PARAMS table.
2. In Business Modeler, navigate to Parameters > System Parameters > Application Server > Workflow (tab).
3. Add the application ID of the new User Group to the existing list of values for the "workflow group" parameter (separate values with a comma).
4. Save the changes, and then restart the application server.

To use SSL mutual authentication (client authentication), use Java 1.6.0_19 and perform the following:

In the Java control panel, go to the Java tab, and then click View. In the Java Runtime Environment Settings window, enter the following in the Runtime Parameters field and then save the change:

August 2011

On the Windows Vista platform, if the Demantra user does not have administrator privileges:

• The Export Worksheet to Excel features does not work
• Worksheets will not open when Mutual SSL authentication is enabled

Disable the Windows Vista "User Account Control" (UAC) feature.

Fix not yet available.

August 2011

An issue with the httpOnly cookie attribute and Java 5 code base causes logging issues in Demantra worksheets.

Set the 'httpOnly' parameter in the application server configuration file to False, or delete it. For example, if using Tomcat, the parameter 'useHttpOnly' is defined in server.xml. If using Web Logic, 'cookie-http-only' is defined in weblogic.xml.

Fix not yet available.

Select Data > Reset Manual Changes, or rerun the worksheet without saving the changes; either action will reset all changed values.

Also note that if the 'Same Value Update' setting for a modified series is set to Yes, then the user will see that the change has not been "undone."

The Oracle Demantra documentation does not address the restrictions for using special characters when entering or updating series names.

You can use any combination of letters, numbers, and characters when naming series, but the following characters should not be used:

• .
• =
• +
• |
• :
• -
• *
• /
• \
• <
• >

These characters are all valid Operators that can be used when defining a client or server expression. Using any of these characters in a series name can result in unexpected worksheet behavior and is therefore not recommended.

(Known issue with Demantra documentation - This information was not included in the release 7.3.1 Oracle Demantra Implementation Guide and Oracle Demantra User's Guide. )

Description of the 'Full Context' Open With option.

The 'Open with Context' feature specifies how a worksheet should be filtered when a user opens it through the Open or Open With menu options on the right-click menu.

Selecting Full Context (for Sub-Tab worksheets) generates the full context for all Levels in the calling worksheet. For the Open-With worksheets, this is the same as choosing the Selected Context option.

(Known issue with Demantra documentation - This information was not included in the release 7.3.1 Oracle Demantra Implementation Guide.)

Description of new log category in the logconf.lcf file.

The parameter collaborator.login.user can be set in the logconf.lcf file. When this log category is enabled, the following information will print out to the collaborator.log file:

• date/time : User "username" logged in, "number" users online.
• date/time : User "username" has been brutally logged out, "number" users online.
• date/time : User "username" logged out, "number" users online.

For additional information, refer to "Logging Messages of the Application Server" in the Oracle Demantra Implementation Guide.

Documentation updated for Demantra 12.2 release.

Before loading CMRO data:

1. Log in to workflow manager as user 'dm'.
2. Open the the "SPF-cMRO - Import cMRO Data" WF Schema.
3. Go to the Proport Procedure Step (3rd step from the end).
4. Change 2nd Parameter value to 1.
5. Run the WF to load the CMRO data.
6. Run the NON UMP Forecast engine and review engine results.