Generate Forecast Calculations Are Incorrect (Doc ID 790176.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Materials Requirement Planning - Version: 11.5.10.2

Symptoms

-- Problem Statement:
Testing the Forecasting Calculations using data from a Legacy system and use this to generate
Forecasts. Load historical usage data into the MTL_DEMAND_HISTORIES table and run the
Forecast generation using a variety of Alpha, Trend, and Seasonality factors - but were unable to
reconcile the results.

To this end we created and loaded a Test Item with controlled period values, but are unable to resolve the calculations for Alpha smoothing only, nor Trend or
Seasonality.

We then loaded the examples from Appendix G in the MRP/Supply Chain Manual running 8 periods with
the examples quoted but got drastically different results.

We know from Appendix G what the Calculations are and can build Excel models to mirror these, but
cannot get the Actual forms to products the same results.

-- Steps To Reproduce:
1. Load historic data into MTL_DEMAND_HISTORIES.
2. Setup the forecast rules for Alpha only.
3. Run Statistical forecast.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms