Generate Forecast Calculations Are Incorrect
Last updated on JUNE 28, 2017
Applies to:Oracle Materials Requirement Planning - Version 18.104.22.168 to 22.214.171.124 [Release 11.5]
Information in this document applies to any platform.
Materials Requirement Planning - Version: 126.96.36.199
-- 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
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.
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