Oracle Inventory Optimization Release Notes for Release 12.1.3.9

Part #: E21884-04, July 2013

This document provides delta information from Oracle E-Business Suite Release 12.1.3 to Value Chain Planning Cumulative Patch 12.1.3.9, Patch 16974659.

The information included in this document assumes that you have already installed Oracle Inventory Optimization Release 12.1.3, according to the relevant instructions in the following documents:

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 the following locations:


In this Document

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

1. What's New

In Release 12.1.3, Oracle Inventory Optimization has added or changed the following features since its last release. For a complete list of new features within Oracle E-Business Suite Release 12.1.3, refer to Document 561580.1, Release Content Document.

Feature Name Description
Enhanced Budget Constraints
(Release 12.1.3)

Prior to this release, IO did not have the ability to ensure integer valued safety stock solutions within input budget constraints. A new heuristic ensures integer valued safety stocks while respecting input budget constraints. This new heuristic is enabled by setting the profile option "MSR: Budget Heuristic" to Yes. The default value is No.

A few points about the new heuristic:

  • It is applicable only for a single level supply chain
  • It is applicable only for plan level and organization level budgets
  • It is applicable for both intermittent and non-intermittent demand streams
Oracle Inventory Optimization and Asset Intensive Planning
(Release 12.1.3.7)

The purpose of this functionality is to enable Inventory Optimization to compute safety stock for consumables and rebuildables that will be required for maintenance in an asset intensive industry.

To support asset intensive planning, Inventory Optimization was modified to perform the following:

  • Compute total demand. Total demand includes demand from maintenance needs as well as other needs in the supply chain for the same item.
  • Understand the Oracle Enterprise Asset Management (eAM) activity definitions to understand the Maintenance BOM and Routing that in turn determines material and capacity needs associated with Maintenance. Use Repair Lead time and Lead time variability to drive safety stock needs for rebuildable items.
  • Understand and use a new Item Attribute Mass Maintenance (IMM) field, Rebuild Activity. This new IMM attribute needs to be set for each organization that is used in creating Planned Repair Work Orders as well as during the release process of these work Orders. IO looks at the rebuild activity to determine a rebuild BOM and routing.
Warehouse Capacity Constraints

Oracle Inventory Optimization has added a new IO constraint set to implement warehouse capacity. These warehouse constraints are considered as hard constraints when combined with budget or capacity constraints. They are considered as soft constraints when combined with service level constraints. These constraints are defined either at the organization level or at the category org. level, depending on the value you specify for the profile option MSO: Warehouse Capacity Granularity.

Accounting for Cycle Inventory in Safety Stock Calculation

You can achieve your target service levels with lower safety stock quantities when you have cycle inventories.

This implies that the actual service levels could be higher in the early time buckets of a cycle than the service level in the later time buckets. Consequently to achieve a target average service level during the cycle a lower safety stock inventory could be required in a cycle inventory system.

Enforcing Group Service Level Targets

Oracle Inventory Optimization (IO) currently allows specifying target service levels at multiple levels. It picks the most granular target applicable for an item-organization and interprets that as the target for those item-organizations.

Customers often track service levels at more aggregate levels. For example, where there are several member variants within a particular product category, they may want to track the service level for the product category as a whole rather than for each item variant.

In release 12.1.3.9, Oracle Inventory Optimization has been enhanced to support enforcing service levels at a Group (Category or Category-Demand Class) level. When a planner specifies a service level target at a Group level, the planner can also specify whether the target should be applied at the group level, or for the individual item-organizations within the group. If the planner chooses the former, IO will ensure that service levels are met at the group level, and individual item-organizations below it may exceed or fall short of the target service level. If the planner chooses the latter, each item-organization will be planned to attain the target service level.

This feature applies only to Enforce Service Level plans.

Using Negative Binomial Distribution in Inventory Optimization

In release 12.1.3.9, you can instruct Inventory Optimization to use the Negative Binomial distribution as the forecast error distribution for items with high variability intermittent demands when calculating safety stock levels.

This is achieved by using the following new profile option, MSR: Variance to Mean Threshold for Use of Negative Binomial Distribution.

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 consolidated documentation patch for Oracle E-Business Suite Release 12.1.3 is Patch 9239095. For the product families that are included in Release 12.1.3, the consolidated documentation patches are listed below:

Patch Product Family
Patch 9400185 Applications Technology (ATG_PF)
Patch 9403775 Customer Relationship Management (CC_PF)
Patch 9403767 Financials (FIN_PF)
Patch 9401789 Human Resources (HR_PF)
Patch 9403759 Procurement (PRC_PF)
Patch 9403770 Projects (PJ_PF)
Patch 9403704 Supply Chain Management (SCM_PF)
Patch 9403751 Value Chain Planning (SCP_PF)

We strongly recommend the installation of these patches.

In addition, the following Oracle Inventory Optimization documentation is available as part of the Online Documentation Library on My Oracle Support (formerly MetaLink) and Oracle Technology Network for this release:

Documentation patches and Adobe Acrobat PDFs are cumulative; they include updated documentation for all Oracle Inventory Optimization 12.1.3 changes.

Return to Documentation

Top

2.2 Technical Documentation

The following technical documentation is available:

2.2.1 Data Model Comparison Report

The EBS Data Model Comparison Report lists the database object definition changes between two Oracle E-Business Suite releases to help users to preview the database object definition changes before upgrading their instances from one release to another and understand the impact of the database object changes that may affect the customization or business flows.

For more information about the EBS Data Model Comparison report, see Document 1290886.1, EBS Data Model Comparison Report Overview.

2.2.2 EBS ATG Seed Data Comparison Report

The EBS ATG Seed Data Comparison Report lists the differences between two Oracle E-Business Suite releases by documenting the seed data changes delivered by the product data loader files (.ldt extension) based on the ATG loader control files (.lct extension). This report enables advanced users to review changes prior to an upgrade.

For more information about the EBS ATG Seed Data Comparison Report, see Document 1327399.1, EBS ATG Seed Data Comparison Report.

Return to Documentation

Top

2.2.3 EBS File Comparison Report

The EBS File Comparison Report provides a comprehensive comparison of file system artifacts between different Oracle E-Business Suite releases for important file types. As part of Oracle E-Business Suite upgrade planning, this report helps customers to get a clear idea of what is different in a new release (additions, removals and modifications for Oracle E-Business Suite delivered files). The report also covers some special artifacts that span the file system and database (for example, Oracle E-Business Suite delivered Oracle Application Framework (OAF) personalizations, Oracle Application Framework (OAF) based pages, Oracle Business Intelligence Publisher reports and so on).

For more information about the EBS File Comparison Report, see Document 1446430.1, EBS File Comparison Report Overview.

Return to Documentation

Top

2.3 Integration Repository

The Oracle Integration Repository is a compilation of information about the service endpoints displayed by the Oracle E-Business Suite of applications. It provides a complete catalog of Oracle E-Business Suite's business service interfaces. The tool enables users to easily discover and deploy the appropriate business service interface for integration with any system, application, or business partner.

The Oracle Integration Repository is shipped as part of Oracle E-Business Suite. As your instance is patched, the repository is automatically updated with content appropriate for the precise revisions of interfaces in your environment.

You can navigate to the Oracle Integration Repository through Oracle E-Business Suite Integrated SOA Gateway.

Return to Documentation

Top

2.4 Release Content Document

Refer to Document 561580.1, Release Content Document for information about the features and enhancements for Oracle E-Business Suite Release 12.1.3.

Return to Documentation

Top

2.5 White Papers

There are no relevant white papers for this product in this release.

Return to Documentation

Top


3. New and Changed Features

In Release 12.1.3, Oracle Inventory Optimization has added or changed the following features since its last release. For a complete list of new features within Oracle E-Business Suite Release 12.1.3, refer to the Document 561580.1, Release Content Document.

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

This release provides the following new features and enhancements:

Top


3.1 Enhanced Budget Constraints

Description

Prior to this release, IO did not have the ability to ensure integer valued safety stock solutions within input budget constraints. A new heuristic ensures integer valued safety stocks while respecting input budget constraints. This new heuristic is enabled by setting the profile option "MSR: Budget Heuristic" to Yes. Tthe default value is No.

A few points about the new heuristic:

  • It is applicable only for a single level supply chain
  • It is applicable only for plan level and organization level budgets
  • It is applicable for both intermittent and non-intermittent demand streams
New, Changed, Obsolete Components

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Inventory Optimization in Release 12.1.3. These components may include the following: forms, windows, reports, C programs, SQL*Loader programs, workflows, alerts, tables, or APIs.

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

This table lists the changed programs.

Program Name Feature Area
MSRNEW If the profile option MSR:BUDGET HEURISTIC is turned on then an integer valued interval level is output. If not the current existing Enhanced Budget optimization routine is executed.
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 Business Intelligence Publisher Components

There are no new Business Intelligence Publisher Components that are associated with this feature.

Changed Business Intelligence Publisher Components

There are no changed Business Intelligence Publisher Components that are associated with this feature.

Obsolete Business Intelligence Publisher Components

There are no obsolete Business Intelligence Publisher Components that are associated with this feature.

New SQL Loader Files

There are no new SQL loader files that are associated with this feature.

Changed SQL Loader Files

There are no changed SQL loader files that are associated with this feature.

Obsolete SQL Loader Files

There are no obsolete SQL loader files that are associated with this feature.

New Flexfields

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

Changed Flexfields

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

Obsolete Flexfields

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

New Profile Options

This table lists the new profile options.

Profile Option Name Feature Area Description
MSR:BUDGET HEURITIC Budget Constraint Enhancement Provides the ability to compute an integer valued inventory level in the presence of a budget constraint that is bound by the target budget.
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.

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 sizing considerations for this feature.

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

There are no performance considerations for this feature.

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

Make sure you check the profile option is correctly defined:

  • "MSR: Budget Heuristic" to Yes (the default value is No).

Return to New and Changed Features

Top

3.2 Oracle Inventory Optimization and Asset Intensive Planning

Description

The purpose of this functionality is to enable Inventory Optimization to compute safety stock for consumables and rebuildables that will be required for maintenance in an asset intensive industry.

To support asset intensive planning, Inventory Optimization was modified to perform the following:

  • Compute total demand. Total demand includes demand from maintenance needs as well as other needs in the supply chain for the same item.
  • Understand the Oracle Enterprise Asset Management (eAM) activity definitions to understand the Maintenance BOM and Routing that in turn determines material and capacity needs associated with Maintenance. Use Repair Lead time and Lead time variability to drive safety stock needs for rebuildable items.
  • Understand and use a new Item Attribute Mass Maintenance (IMM) field, Rebuild Activity. This new IMM attribute needs to be set for each organization that is used in creating Planned Repair Work Orders as well as during the release process of these work Orders. IO looks at the rebuild activity to determine a rebuild BOM and routing.

For more information, refer to Oracle Inventory Optimization User's Guide Supplement.

New, Changed, Obsolete Components

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Inventory Optimization in Oracle E-Business Suite Release 12.1.3.7. These components may include the following: forms, windows, reports, C programs, SQL*Loader programs, workflows, alerts, tables, or APIs. Any new, changed, or obsolete components of any of these types are listed below.

Changed Windows or Pages

This table lists the changed windows and pages.

Changed Window or Page Name Technical Name Description

Item Attribute Mass Maintenance (IMM) - Rebuild Activity field

-

The "Rebuild Activity" is a new item attribute, but it is not available in ERP. It is a destination-only attribute and will be added to the Item Attribute Mass Maintenance (IMM) form. This attribute is populated with the Rebuild Activity setup in eAM as the Maintenance BOM and Routes that will be used to plan for the items rebuild process. The new attribute needs to set for each repairable item that needs to have resource and material requirements generated as part of the planned repair work orders which are subsequently released back to ERP. If you do not specify this attribute, then planned repair work orders will be planned based on the item attribute repair lead time and will not have associated resource or material requirements. IO looks at the rebuild activity to understand the associated resources and materials for the repair process but it still looks at the repair lead time / lead time variability to determine the safety stock needs of the rebuildable items.

Note: This attribute was available in 12.1.3.6, but it is being used by IO only in 12.1.3.7.

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.3 Warehouse Capacity Constraints

Description

Oracle Inventory Optimization has added a new IO constraint set to implement warehouse capacity. These warehouse constraints are considered as hard constraints when combined with budget or capacity constraints. They are considered as soft constraints when combined with service level constraints. These constraints are defined either at the organization level or at the category org. level, depending on the value you specify for the profile option MSO: Warehouse Capacity Granularity.

For more information, refer to Oracle Inventory Optimization User's Guide Supplement.

New, Changed, Obsolete Components

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Inventory Optimization in Release 12.1.3. These components may include the following: forms, windows, reports, C programs, SQL*Loader programs, workflows, alerts, tables, or APIs.

New Windows or Pages

This table lists the new windows and pages.

New Window or Page Name Technical Name Description
Storage Capacity - Use to define the capacities for different storage types in a warehouse.
New Profile Options

This table lists the new profile options.

Profile Option Name Feature Area Description
MSO: Warehouse Capacity Granularity -

Use to model the warehouse capacity granularity. Allows you to instruct the system to constrain the IO plan with the total warehouse capacity or the storage capacities of different storage types within the warehouse.

The following profile values are available:

  • Organization Level - Use to constrain your plan by the total warehouse capacity of each warehouse. This is the default value.
  • Category Organization Level - Use constrain your plan by the storage capacities of different storage types within each warehouse.
Changed Programs

This table lists the changed programs.

Program Name Feature Area
IO engine Updated to examine storage capacity while planning Safety Stocks.
Implementation Considerations
New and Changed Setup Steps

Perform the following when using the Warehouse Capacity Constraints feature:

  • Specify Safety Stock Days and Item Order Modifiers in the Item Attributes Mass Maintenance window, or Organization Item window.
  • Specify Order Period in the Item Attributes Mass Maintenance.
  • Specify Inventory Days Increment in the Item Attributes Mass Maintenance.
  • Define the total volume capacity available in a warehouse in the Inventory Parameters tab of the Organization Parameters window.
  • Define storage capacity. Define the capacities for different storage types in a warehouse in the Storage Capacity window under the Setup menu for the Inventory Planner responsibility.
  • Specify the item volume and its unit of measure at the item-org level in the Item Attributes Mass Maintenance window.
  • Select the Item Simulation Set specified in the Item Attributes Mass Maintenance window in the Plan Options window.
  • Enforce warehouse capacity constraints by selecting the plan option Enforce Warehouse Capacity Constraints.
Upgrade Considerations

You can use instruct the system to constrain the IO plan with the total warehouse capacity or the storage capacities of different storage types within the warehouse.

This attribute is used as the time horizon for calculating the Average Demand. Average Daily Demand for a Planning Bucket = Sum of item's independent and dependent demands from the start of the planning bucket to the Safety Stock Days working days after the start of the planning bucket, divided by Safety Stock Days.

To model the warehouse capacity granularity you can use a new profile option MSR: Warehouse Capacity Granularity. Valid values are:

  • Organization Level: This allows you to constrain your plan by the total warehouse capacity of each warehouse. This is the default value.
  • Category Organization Level: This allows you to constrain your plan by the storage capacities of different storage types within each warehouse.

For more information, refer to Setting Up Warehouse Constraints in the Oracle Inventory Optimization User's Guide Supplement.

Sizing

There are no sizing considerations for this feature.

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

There are no performance considerations for this feature.

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 Accounting for Cycle Inventory in Safety Stock Calculation

Description

You can achieve your target service levels with lower safety stock quantities when you have cycle inventories.

This implies that the actual service levels could be higher in the early time buckets of a cycle than the service level in the later time buckets. Consequently to achieve a target average service level during the cycle a lower safety stock inventory could be required in a cycle inventory system.

For more information, refer to Oracle Inventory Optimization User's Guide Supplement.

New, Changed, Obsolete Components

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Inventory Optimization in Release 12.1.3. These components may include the following: forms, windows, reports, C programs, SQL*Loader programs, workflows, alerts, tables, or APIs.

New Profile Options

This table lists the new profile options.

Profile Option Name Feature Area Description
MSR: Include Cycle Inventory in Safety Stock Calculations -

Use to calculate safety stock with respect to cycle stock you need to set the profile option MSR: Include Cycle Inventory in Safety Stock Calculations in your personal profile values.

The following values are available:

  • No - Set to prevent system from calculating safety stock considering cycle inventory. This is the default value.
  • Yes - Use to have system calculate safety stock considering cycle inventory.
Implementation Considerations
New and Changed Setup Steps

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

Upgrade Considerations

To enable the ability to calculate safety stock with respect to cycle stock you need to set the profile option MSR: Include Cycle Inventory in Safety Stock Calculations in your personal profile values. Valid values are:.

  • Yes: Calculate safety stock using cycle stock
  • No (default): Do not calculate safety stock using cycle stock
Sizing

There are no sizing considerations for this feature.

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

There are no performance considerations for this feature.

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 Enforcing Group Service Level Targets

Description

Oracle Inventory Optimization (IO) currently allows specifying target service levels at multiple levels. It picks the most granular target applicable for an item-organization and interprets that as the target for those item-organizations.

Customers often track service levels at more aggregate levels. For example, where there are several member variants within a particular product category, they may want to track the service level for the product category as a whole rather than for each item variant.

Oracle Inventory Optimization has therefore been enhanced to support enforcing service levels at a Group (Category or Category-Demand Class) level. When a planner specifies a service level target at a Group level, the planner can also specify whether the target should be applied at the group level, or for the individual item-organizations within the group. If the planner chooses the former, IO will ensure that service levels are met at the group level, and individual item-organizations below it may exceed or fall short of the target service level. If the planner chooses the latter, each item-organization will be planned to attain the target service level.

This feature applies only to Enforce Service Level plans.

New, Changed, Obsolete Components

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Inventory Optimization in Release 12.1.3. These components may include the following: forms, windows, reports, C programs, SQL*Loader programs, workflows, alerts, tables, or APIs.

New Windows or Pages

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

Changed Windows or Pages

This table lists the changed windows and pages.

Changed Window or Page Name Technical Name Description
Plan Options - Added a new "Enforce at Aggregate Level" option to the Constraints tab of the Plan Options form. This is enabled in case of an "Enforce Service Level Constraints" plan.
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 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 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

This table lists the changed programs.

Program Name Feature Area
MSRNEW The IO engine now considers the Plan Option "Enforce at Aggregate Level". If this is checked, it enforces service level targets at a Category or Category-Demand Class level, instead of rolling down the target to individual item-organizations under it.
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 Business Intelligence Publisher Components

There are no new Business Intelligence Publisher Components that are associated with this feature.

Changed Business Intelligence Publisher Components

There are no changed Business Intelligence Publisher Components that are associated with this feature.

Obsolete Business Intelligence Publisher Components

There are no obsolete Business Intelligence Publisher Components that are associated with this feature.

New SQL Loader Files

There are no new SQL loader files that are associated with this feature.

Changed SQL Loader Files

There are no changed SQL loader files that are associated with this feature.

Obsolete SQL Loader Files

There are no obsolete SQL loader files that are associated with this feature.

New Flexfields

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

Changed Flexfields

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

Obsolete Flexfields

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

New Profile Options

There are no new profile options 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.

Implementation Considerations
New and Changed Setup Steps

Check the "Enforce at Aggregate Level" option if service level targets are to be met at a Category / Category-Demand Class level instead of individual item-org level.

Upgrade Considerations

If you are upgrading to 12.1.3.9 and do not wish to enforce the service levels at an aggregate level, make sure that the Plan Option "Enforce at Aggregate Level" is not selected.

Sizing

There are no sizing considerations for this feature.

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

There are no performance considerations for this feature.

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

Issue: Items have Projected Service Levels below target.

Probable Cause: This is possible if service levels are enforced at aggregate level. In this case, service levels are achieved at the group level, but individual items under the group may be above or below target.

Solution: None.
If it appears that an item has a Projected Service Level below target, this is quite possible when "Enforce at Aggregate Level" has been enabled. In this case, the IO engine ensures that service levels are met at the aggregate level; individual item-organizations could well be above or below the target.

Issue: Aggregate Service level target not met.

Probable Cause: Items under the group may have different targets; in which case the more granular targets are met.

Solution: If group service level targets are to be enforced, do not specify service level targets for items under it unless really required.

Return to New and Changed Features

Top

3.6 Using Negative Binomial Distribution in Inventory Optimization

Description

In release 12.1.3.9, you can instruct Inventory Optimization to use the Negative Binomial distribution as the forecast error distribution for items with high variability intermittent demands when calculating safety stock levels.

This is achieved by using the a new profile option, MSR: Variance to Mean Threshold for Use of Negative Binomial Distribution.

New, Changed, Obsolete Components

This section lists the components that were added, changed, or made obsolete for this feature in Oracle Inventory Optimization in Release 12.1.3. These components may include the following: forms, windows, reports, C programs, SQL*Loader programs, workflows, alerts, tables, or APIs.

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

This table lists the changed programs.

Program Name Feature Area
MSRNEW Supports the use of Negative Binomial distribution as the forecast error distribution for items with high variability intermittent demands when calculating safety stock levels.
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 Business Intelligence Publisher Components

There are no new Business Intelligence Publisher Components that are associated with this feature.

Changed Business Intelligence Publisher Components

There are no changed Business Intelligence Publisher Components that are associated with this feature.

Obsolete Business Intelligence Publisher Components

There are no obsolete Business Intelligence Publisher Components that are associated with this feature.

New SQL Loader Files

There are no new SQL loader files that are associated with this feature.

Changed SQL Loader Files

There are no changed SQL loader files that are associated with this feature.

Obsolete SQL Loader Files

There are no obsolete SQL loader files that are associated with this feature.

New Flexfields

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

Changed Flexfields

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

Obsolete Flexfields

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

New Profile Options

This table lists the new profile options.

Profile Option Name Feature Area Description
MSR: Variance to Mean Threshold for Use of Negative Binomial Distribution -

If a value is specified for this profile option, then Inventory Optimization uses either the Negative Binomial Distribution or the Poisson Distribution for demand variability modeling when the item attribute Intermittent Flag is set to "Yes". The selection of the distribution is based on comparing the ratio of (Variance / Mean) of the demand with the profile option value as follows:

  • Negative Binomial Distribution is used when (Variance/Mean) > Profile Option Value
  • Poisson Distribution is used when (Variance/Mean) ≤ Profile Option Value

The default value for this profile option is "NULL". In this case, the Poisson Distribution is used when the item attribute Intermittent Flag is set to "Yes".

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.

Implementation Considerations
New and Changed Setup Steps

The profile option "MSR: Variance to Mean Threshold for Use of Negative Binomial Distribution" can (optionally) be set so that IO can use either a Poisson distribution or a Negative Binomial distribution as the forecast error distribution, depending on the profile value.

Upgrade Considerations

If you are upgrading to Inventory Optimization 12.1.3.9, you can use Negative Binomial distribution as the forecast error distribution while calculating safety stocks for items with intermittent demand and high variability.

Sizing

There are no sizing considerations for this feature.

Table Space Considerations

There are no table space considerations for this feature.

Performance Considerations

There are no performance considerations for this feature.

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

Issue: Safety Stock values calculated in IO appear wrong.

Probable Cause: Wrong safety stock calculation method chosen due to wrong settings.

Solution: Verify that the profile "MSR: Variance to Mean Threshold for Use of Negative Binomial Distribution" and the item attribute "Intermittent Demand" have been set correctly.

Return to New and Changed Features

Top


4. Diagnostics and Logging

Oracle Inventory Optimization utilizes Oracle E-Business Suite Diagnostics, a tool to help standardize data gathering and troubleshooting. This tool (product code IZU) is delivered within the maintenance pack, and consists of two components:

It is highly recommended that following the successful installation of Oracle E-Business Suite Release 12.1.3 for Oracle Inventory Optimization, the following actions are taken:

  1. Verify that the latest Oracle E-Business Suite Diagnostics patch is applied (see Document 167000.1 for latest patch information) as this will ensure that the latest tools are available.
  2. Run the related product family pre-production test set(s) to verify existing product setups have not been compromised and all new, required setups are flagged for action.

After installation, review Document 783319.1, the diagnostic catalog, to identify other helpful tests that you can use for maintaining a healthy environment.

For questions about Oracle E-Business Suite Diagnostics or any issues using this tool, consult Document 235307.1, FAQ, in My Oracle Support for the latest answers and discussion.

E-Business Suite Diagnostics Quick Reference

My Oracle Support Document Title Purpose
Document 167000.1 Installation Guide

Use this note to download the latest Diagnostics patch.

Follow the installation instructions to eliminate common installation and usage problems.

A link to how to set up RBAC security for Oracle E-Business Suite Diagnostics is included.

Document 235307.1 FAQ

Do you have a problem installing Diagnostics?

Do you have a question about how Diagnostics works and what it can do for you? This Note is a great first-line resource to getting the information that you need.

Document 342459.1 Overview The Overview highlights Oracle E-Business Suite Diagnostics, and what this tool can do for you and your E-Business Suite applications.
Document 421245.1 Overview This Note lists all tests that are available for Release 12.
Document 368109.1 Pre-production test sets

Tests that are grouped together (known as test sets) by a product family, designed to aid in verifying that all included applications are set up correctly.

Designed to detect missing or incorrect setup and prevent corruption before implementation or usage of applications.

Document 232116.1 Training Viewlets and presentations, explaining the various aspects of Oracle E-Business Suite Diagnostics.
My Oracle Support Diagnosibility Community Diagnosibility link This is an open forum to discuss Oracle E-Business Suite Diagnostics, and is monitored by the Oracle E-Business Suite Diagnostics development team.

Oracle Inventory Optimization uses the common diagnostics features in Oracle E-Business Suite. This enables users and system administrators to use a centralized set of options to control logging level, as well as output destination. To run diagnostics, use the following profile options:

Setting the log level to Statement produces detail logging of code execution. To reduce the size of the output and make it more manageable, you can use msr% as a module to restrict messages to those coming from Oracle Inventory Optimization code.

The preceding profile options can be turned on at the user, function, responsibility, or site level. It is preferable, however, to set profiles at the user level to restrict the overhead they add to the system. If issues are experienced, logging profiles should be set at the user level experiencing the issue. For authorization servlet-related issues, you must set the diagnostics profile at the user level to ANONYMOUS.

To diagnose user interface issues, you can use the filter iby%,fnd.framework%,jbo% and set the diagnostics go-to screen by clicking the Diagnostics Global button. To enable this functionality, you must set the following profile option:

The FND: Diagnostics profile option controls whether the Diagnostics button is rendered. It also controls the display of the About this Page link.

For system issues, such as exceptions, timeouts, or unexpected behavior, you can turn on logging, based on where you are experiencing the issues, as follows:

You can also capture additional information about the system by printing the report from the About this Page link, as well as from the jsp: /OA_HTML/jsp/fnd/fndversion.jsp.

For more information on Logging, see the Oracle Applications System Administrator's Guide Documentation Set and the Oracle Applications Developer's Guide in the Release 12.1.3 Documentation Library.

Return to Diagnostics and Logging

Top


5. Known Issues in Oracle Inventory Optimization Release 12.1.3.9

There are no known issues for this product.

Return to Known Issues

Top


6. Change Record

Date Description of Change
July 2013 Initial publication

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.