Oracle Demantra Release Notes for Release 7.3.1

This document provides release information for Oracle Demantra Release 7.3.1. This document has been updated to provide additional information for release 7.3.1.5.

The information included in this document assumes that you have already installed Oracle Demantra 7.3.1 according to the instructions in the following document:

Note: This document - especially Section 5, Known Issues - may be updated after initial release. Any changes are listed in Section 6, Change Record. If you print this document, periodically check to ensure you have the most recent version.

The latest version of this document is available from My Oracle Support:


In this Document

  1. What's New
  2. Documentation
  3. New and Changed Features
  4. Diagnostics and Logging
  5. Known Issues in Oracle Demantra Release 7.3.1.5
  6. Change Record
  7. Documentation Accessibility

1. What's New

In Release 7.3.1, Oracle Demantra has added or changed the following features since its last release.

Feature Name
Description
Service Parts Forecasting (SPF)

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 1547149.1, for important pre- and post-installation tasks.

Database Performance Improvements

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.

Forecasting for Multiple Business Processes

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.

Proport Enhancements

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.

Parallel Hints on Worksheets

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.

Rolling Data Profile Groups

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.

Subset Forecasting Subset forecasting allows customers who have large data sets which cannot be completed in a single processing cycle to generate a batch forecast for a filtered subset of combinations. This run will not advance forecast versioning and will simply override the latest forecast for the specified subset. This process is similar to executing and accepting a simulation but without the need to open a worksheet and with the benefit of processing parallelization. Subset forecasting does not entirely replace full batch runs, as they are required to drive forecast versioning.
Engine Performance Improvements

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.

Data Preservation Setting for General Levels

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.

Demantra Web Service Namespace Change

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.

Launch URL from Worksheet

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.

Enhancements to PTP Engine

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.

Integration with Asset Intensive Planning

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.

Demantra Trade Promotion Optimization - Enhancements to Optimization

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.
Embedded Demantra Worksheets in VCP Applications

In this release, 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.

Demantra Predictive Trade Planning (PTP) Promotion Calendar

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 this release. For details, refer to the Oracle Demantra Implementation Guide Supplement.

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.

Aggregate Work Orders

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.

Demantra User Interface (UI) Enhancements

In this release, 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 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.

Oracle In-Memory Consumption-Driven Planning

Oracle Demantra release 7.3.1.5 introduces an entirely new module, Oracle In-Memory Consumption-Driven Planning (CDP). Use CDP to generate forecasts at different levels, calculate safety stock and replenishment order calculations, and generate various kinds of exceptions.

Note: Oracle In-Memory Consumption-Driven Planning is a distinct and separately licensed and installed Demantra product. It leverages the high scalability of the Exadata or SPARC SuperCluster machines, the only platforms supported, to support data volumes previously not considered feasible. Demantra system performance and batch processing is dramatically improved when deploying on either an Exadata or SPARC SuperCluster machine.

Demantra Enhancements

In this release, Demantra provides the following enhancements to support CDP:

  • Use of detailed consumption data at Item/Store/Day granularity for the CDP process without impacting data volumes and processing for Demand Management.
  • New batch and simulation engine profiles for the Analytical Engine to generate a sell-through forecast at the store and site levels as well as a sell-in forecast.
  • New Business Logic Engine (BLE) cluster profiles to run CDP workflows and worksheets that calculate suggested replenishment orders, safety stock, and store sell-in forecast. BLE can be called from a worksheet with the worksheet context.
  • Leverages Exadata and SPARC to process and store amounts of data previously not feasible.

For information about CDP, refer to the Oracle In-Memory Consumption-Driven Planning User's Guide.

64-bit Analytical Engine

In release 7.3.1.5, customers with a Demand Management (DM) license will have access to two analytical engines: the existing Oracle Demantra Analytical Engine in 32-bit as well as a new 64-bit Analytical Engine for Linux and Solaris. All engine versions contain the same analytical capabilities, functionality, and features, but the 64-bit engine more efficiently utilizes system resources. Due to changes in math libraries and optimizations in some of the underlying processing, individual results may slightly vary between the two engines, but there is no expected loss of accuracy. Deployment of the 64-bit engine is performed in the same manner as the 32-bit engine. For deployment details, please refer to the 7.3.1.5 Oracle Demantra Installation Guide.

Return to What's New

Top


2. Documentation

This section provides information on the following topics:

Top


2.1 Online Help and PDF Documentation

The Oracle Demantra Online help is installed when you upgrade or install release 7.3.1. In addition to English, all Demantra user guide content is available in the following languages:

In addition, the following Oracle Demantra documentation in U.S. English is available as part of the Installer process:

Online documentation and Adobe Acrobat PDF's are cumulative; they include updated documentation for all Oracle Demantra 7.3.1 changes.

Return to Documentation

Top

2.2 Technical Documentation

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.

Return to Documentation

Top

2.3 White Papers

Please refer to the Demantra Documentation Library, Document 443969.1, on My Oracle Support or contact Oracle Support Services.

Return to Documentation

Top


3. New and Changed Features

In Release 7.3.1, the Oracle Demantra products have added or changed the following features since the last release.

Use this section to access the following information for each feature:

This document contains information on the following new product features:

Top


3.1 Service Parts Forecasting (SPF)

Description

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 1547149.1, for important pre- and post-installation tasks.

New, Changed, Obsolete Components

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.

Implementation Considerations
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 1547149.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.

Customizations and Extensions Customizations and extensions are not possible for this feature.
Minimum Level Requirements There are no minimum level requirements for this feature.
Technology Stack Incompatibilities There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations There are no technology architecture considerations for this feature.
Troubleshooting Tips There are no troubleshooting tips for this feature.

Return to New and Changed Features

Top


3.2 Forecasting for Multiple Business Processes

Description

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.

New, Changed, Obsolete Components

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.

Implementation Considerations
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.

Customizations and Extensions Customizations and extensions are not possible for this feature.
Minimum Level Requirements There are no minimum level requirements for this feature.
Technology Stack Incompatibilities There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations There are no technology architecture considerations for this feature.
Troubleshooting Tips There are no troubleshooting tips for this feature.

Return to New and Changed Features

Top


3.3 Proport Enhancements

Description

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.

New, Changed, Obsolete Components

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.

Implementation Considerations
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.

Customizations and Extensions Customizations and extensions are not possible for this feature.
Minimum Level Requirements There are no minimum level requirements for this feature.
Technology Stack Incompatibilities There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations There are no technology architecture considerations for this feature.
Troubleshooting Tips There are no troubleshooting tips for this feature.

Return to New and Changed Features

Top


3.4 Parallel Hints on Worksheets

Description

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.

New, Changed, Obsolete Components

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.

Implementation Considerations
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.

Customizations and Extensions Customizations and extensions are not possible for this feature.
Minimum Level Requirements There are no minimum level requirements for this feature.
Technology Stack Incompatibilities There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations There are no technology architecture considerations for this feature.
Troubleshooting Tips There are no troubleshooting tips for this feature.

Return to New and Changed Features

Top


3.5 Rolling Data Profile Groups

Description

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.

New, Changed, Obsolete Components

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.

Implementation Considerations
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.

Customizations and Extensions Customizations and extensions are not possible for this feature.
Minimum Level Requirements There are no minimum level requirements for this feature.
Technology Stack Incompatibilities There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations There are no technology architecture considerations for this feature.
Troubleshooting Tips There are no troubleshooting tips for this feature.

Return to New and Changed Features

Top

3.6 Subset Forecasting

Description Subset forecasting allows customers who have large data sets which cannot be completed in a single processing cycle to generate a batch forecast for a filtered subset of combinations. This run will not advance forecast versioning and will simply override the latest forecast for the specified subset. This process is similar to executing and accepting a simulation but without the need to open a worksheet and with the benefit of processing parallelization. Subset forecasting does not entirely replace full batch runs, as they are required to drive forecast versioning.
New, Changed, Obsolete Components

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.

Changed Window or Page Name Technical Name Description
Modify Engine Profiles page - New Subset Forecasting option available on page.
Implementation Considerations
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.

Customizations and Extensions Customizations and extensions are not possible for this feature.
Minimum Level Requirements There are no minimum level requirements for this feature.
Technology Stack Incompatibilities There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations There are no technology architecture considerations for this feature.
Troubleshooting Tips There are no troubleshooting tips for this feature.

Return to New and Changed Features

Top

3.7 Integration with Asset Intensive Planning

Description

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.

New, Changed, Obsolete Components

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
Customizations and Extensions Customizations and extensions are not possible for this feature.
Minimum Level Requirements There are no minimum level requirements for this feature.
Technology Stack Incompatibilities There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations There are no technology architecture considerations for this feature.
Troubleshooting Tips There are no troubleshooting tips for this feature.

Return to New and Changed Features

Top

3.8 Enhancements to PTP Engine

Description 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.
New, Changed, Obsolete Components

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'.
Implementation Considerations
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.

Customizations and Extensions Customizations and extensions are not possible for this feature.
Minimum Level Requirements There are no minimum level requirements for this feature.
Technology Stack Incompatibilities There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations There are no technology architecture considerations for this feature.
Troubleshooting Tips There are no troubleshooting tips for this feature.

Return to New and Changed Features

Top

3.9 Launch URL from Worksheet

Description 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.
New, Changed, Obsolete Components

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 - The Hyperlink option has been added to the Display Format setting.
Implementation Considerations
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.

Customizations and Extensions Customizations and extensions are not possible for this feature.
Minimum Level Requirements There are no minimum level requirements for this feature.
Technology Stack Incompatibilities There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations There are no technology architecture considerations for this feature.
Troubleshooting Tips There are no troubleshooting tips for this feature.

Return to New and Changed Features

Top

3.10 Database Performance Improvements

Description 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.
New, Changed, Obsolete Components

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
Implementation Considerations
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.

Customizations and Extensions

Customizations and extensions are not possible for this feature.

Minimum Level Requirements There are no minimum level requirements for this feature.
Technology Stack Incompatibilities There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations There are no technology architecture considerations for this feature.
Troubleshooting Tips There are no troubleshooting tips for this feature.

Return to New and Changed Features

Top

3.11 Demantra Trade Promotion Optimization - Enhancements to Optimization

Description

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.
New, Changed, Obsolete Components

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.

Table Name Description
TPO_EXCLUSION_RULES Stores the definition of exclusion rules which are used by the promotion optimization engine.
Implementation Considerations
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.

Customizations and Extensions Customizations and extensions are not possible for this feature.
Minimum Level Requirements There are no minimum level requirements for this feature.
Technology Stack Incompatibilities There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations There are no technology architecture considerations for this feature.
Troubleshooting Tips There are no troubleshooting tips for this feature.

Return to New and Changed Features

Top

3.12 Embedded Demantra Worksheets in VCP Applications

Description

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.

New, Changed, Obsolete Components

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.

Implementation Considerations
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.

Customizations and Extensions Customizations and extensions are not possible for this feature.
Minimum Level Requirements There are no minimum level requirements for this feature.
Technology Stack Incompatibilities There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations There are no technology architecture considerations for this feature.
Troubleshooting Tips There are no troubleshooting tips for this feature.

Return to New and Changed Features

Top

3.13 Demantra Predictive Trade Planning (PTP) Promotion Calendar

Description

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.

Event Calendar capabilities are available with PTP and AFDM licenses.

New, Changed, Obsolete Components

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.

New System Parameter Name Technical Name Description
AllowUpdatesfromCalendar - Control whether or not boxes can be moved/resized on the calendar. If "AllowUpdatesfromCalendar"="No" (default setting) for a Calendar View, then users cannot move or resize boxes on the calendar. If "AllowUpdatesfromCalendar"="Yes" for a Calendar View, then users can update dates by moving or resizing boxes on the Calendar in the same way the Activity Details/Gantt Chart works today.
Changed Windows or Pages

This table lists the changed windows and pages.

Changed Window or Page Name Technical Name Description
Worksheet Designer - Calendar View option - New right-click menu option, Calendar View, for Level in Layout page. Select Calendar View to display promotions on planning calendar in Promotion Calendar view.
New Tables

This table lists the new tables.

Table Name Description
CALENDAR_VIEW_DEF

Used to define general information about the Promotion Calendar.

Refer to "Defining a Promotion Calendar" in the Oracle Demantra Implementation Guide Supplement for more information.

CALANDER_SERIES_DEF

Used to define the series that will appear in the Promotion Calendar.

Refer to "Defining a Promotion Calendar" in the Oracle Demantra Implementation Guide Supplement for more information.

New Views

This table lists the new views.

View Name Feature Area Description
Promotion Calendar -

The Promotion Calendar graphically displays promotions in an interactive calendar.

Refer to "PMO: Promotion Calendar" in the Oracle Demantra Predictive Trade Planning User's Guide for more information.

Implementation Considerations
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.

Customizations and Extensions Customizations and extensions are not possible for this feature.
Minimum Level Requirements There are no minimum level requirements for this feature.
Technology Stack Incompatibilities There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations There are no technology architecture considerations for this feature.
Troubleshooting Tips There are no troubleshooting tips for this feature.

Return to New and Changed Features

Top

3.14 Aggregate Work Orders

Description

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.

New, Changed, Obsolete Components

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.

Implementation Considerations
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.

Customizations and Extensions Customizations and extensions are not possible for this feature.
Minimum Level Requirements There are no minimum level requirements for this feature.
Technology Stack Incompatibilities There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations There are no technology architecture considerations for this feature.
Troubleshooting Tips There are no troubleshooting tips for this feature.

Return to New and Changed Features

Top

3.15 Demantra User Interface (UI) Enhancements

Description

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.

New, Changed, Obsolete Components

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.

New System Parameter Name Technical Name Description
client.lookAndFeel.newIcons - Determines whether the application uses the new icons that are used by default in release 7.3.1.4. Valid values are 1 (use new icons) and 0 (use pre-7.3.1.4 icons).
Changed Windows or Pages

This table lists the changed windows and pages.

Changed Window or Page Name Technical Name Description

Level Method Edit Promotion (in Business Modeler)

-

This dialog has been modified to include the following:

  • Enable Toolbar Display - This check box is used to display Level Methods for toolbar. The default for this option is unchecked.
  • Toolbar Icon path - Used to the specify toolbar icon.

These settings will be global and apply to all Users and Worksheets that access the Method.

Implementation Considerations
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.

Customizations and Extensions Customizations and extensions are not possible for this feature.
Minimum Level Requirements There are no minimum level requirements for this feature.
Technology Stack Incompatibilities There are no technology stack incompatibilities for this feature.
Technical Architecture Considerations There are no technology architecture considerations for this feature.
Troubleshooting Tips There are no troubleshooting tips for this feature.

Return to New and Changed Features

Top


4. Diagnostics and Logging

Application Server Messages

The Application Server writes logs that record activity of the server and clients.

Server Logs

The default server log location is the Demantra_root/Collaborator/virtual_directory/portal/logs directory.

Follow the comments in the Demantra_root/Collaborator/virtual_directory/portal/conf/logconf.lcf file to specify this log file information:

You can also set log levels at runtime with the following URL:

http://Demantra_root/Collaborator/virtual_directory /admin/loggerManager.jsp

Client Logs

Client logs are written by Java Plugin into the Java Plugin console and/or log files according to the Java Plugin configuration.

The default log location is the following directory: Demantra_root/Collaborator/virtual_directory/portal/logs.

Follow the comments in the Demantra_root/Collaborator/virtual_directory/portal/conf/ClientLogConf.lcf file to specify which log categories are written during runtime.

Integration Failures

Integration (data upload) failures appear in these places:

Engine Failures

If the engine fails during execution, check the following logs:

To access file manager.log, perform the following:

To access file engine2k.log, perform the following:

Contact Oracle Support for instructions on the following issues:

Client Issue - Out of Memory

Verify memory settings: Windows Start menu > Settings > Control Panel > Java plug in the Plug-In Control Panel frame appears > tab Advanced > verify that the value of field Java Runtime Parameters is at least -Xmx256M and is based on the client machine hardware/RAM capacity. Oracle recommends value -Xmx512M for heavy duty client side use.

Check the physical memory on the machine on which the user interface is running. If the machine has other processes that consume operating system memory, the user interface may run out of memory even before it reaches the memory limitation because the operating system does not allocate more memory to the Java Virtual Machine process.

To view actual memory usage at runtime, use these Java console commands:

Oracle suggests executing command g three times in 30 seconds then executing command m once.

If the Plug-in Console window is not accessible from the System Tray, view the plug-in log file directly at $USER_HOME/Application Data/Sun/Java/Deployment/log directory/pluginXXX_XX.trace; XXX_XX is your Java version.

Client Issue - Java Threading

Use the -verbose option; which is a Java VM option in the Java Control Panel > Java Runtime Parameters > tab Advanced. Oracle recommends you use -verbose:gc to put as little spare text in the console as possible (explained below).

When you the verbose option every time an applet executes, a DOS console window opens in which the specified verbose information is required. Ignore the information and press Ctrl+Break to get the client stack trace.

The verbose options are as follows:

Installer Logging

For installation issues, turn on the debugging option.

Execute program setup.exe > a splash screen appears > select Configure Log > select custom settings >set the file name and location > select log level DEBUG.

Database Stored Procedure Logging

The DB_EXCEPTION_LOG and DB_WARNING_LOG tables contain diagnostics. The messages should be viewed with ORDER BY ERR_DATE.

Some of the Demantra Stored Procedures for the Oracle Databases have a logging mechanism. This mechanism is controlled by the LOG_IT_PARAMS table.

Notes:

Return to Diagnostics and Logging

Top


5. Known Issues in Oracle Demantra Release 7.3.1.5

This section provides information about known issues with Oracle Demantra in Release 7.3.1, and possible workarounds for those issues. This document has been updated to provide additional information for release 7.3.1.5.

The information provided below applies to all Oracle Demantra customers who are installing, or upgrading to, Oracle Demantra Release 7.3.1.

This section may be updated from time to time. Always check My Oracle Support for the most current version of this document before you begin to install or upgrade your system.

The table below displays the Known Issues.

Date Known Issue Resolution Fixed In

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.
  3. 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.

January 2011 Demantra cannot be used with SSL mutual authentication (client authentication) when using Java version 1.6.0_23.

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:


-Dsun.security.ssl.allowUnsafeRenegotiation = True
Fix not yet available.

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.

August 2011 The 'undo' action (Edit > Undo, or Ctrl + Z) does not work after using the 'Edit Cells' action to modify more than 25 rows at the same time.

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."

Fix not yet available.
August 2011 Oracle Deductions and Settlement Management (DSM) worksheets fail to load when using Oracle DB version 11.1.0.6 or earlier. Upgrade Oracle DB to 11.1.0.7 or later. Fix not yet available.
May 2012 NON UMP Forecast returns zero results.

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.
Fix not yet available.

Return to Known Issues

Top


6. Change Record

Date Description of Change
August 2013 Published document for 7.3.1.5 updates.
September 2012 Published document for 7.3.1.4 updates.
May 2012 Published document for 7.3.1.3 updates.
January 2012 Updated to address special character restrictions, Full Context Open With option, and new log category, collaborator.login.user.
January 2012 Published document for 7.3.1.2 updates.
September 2011 Published document for 7.3.1.1 updates.
August 2011 Published update.
January 2011 Published document.

Top


7. Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Copyright Notice

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

Hazardous Applications Notice

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

Third Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Revenue Recognition Notice

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your beta trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Software License and Service Agreement, which has been executed and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.