My Oracle Support Banner

E1: 36: Understanding Detail Forecast Generation, R34650 (Doc ID 631350.1)

Last updated on APRIL 03, 2024

Applies to:

JD Edwards EnterpriseOne Requirements Planning - Version XE and later
Information in this document applies to any platform.

Purpose

This document is a supplement to existing documentation for all releases.  Refer to Requirements Planning (MRP/CRP), Forecasting & Project Manufacturing Implementation Guides Document 1109575.1.  The guide will provide more details on each forecast type. 

Overview

This application allows the detailed forecasting of individual items based on prior sales data.  Using a variety of forecasting methods (12 in all), material and finished goods needs can be planned more accurately into the future.  The key to success is testing with different methods to find what is best for individual business needs.  Testing with all 12 methods will not produce the desired results.  Test with those methods that best fit the business model.

In JD Edward EnterpriseOne, from releases Xe through the latest release, forecasts are not "spread."  Monthly amounts can be used when creating weekly buckets, but the application will not spread them over the weeks as World A.73 did.  A8. and A9 versions in World no longer automatically spread either.

Scope

Those responsible for forecasting and supporting MRP independent demand will benefit from this document.

Details

To view full details, sign in with your My Oracle Support account.

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


In this Document
Purpose
 Overview
Scope
Details
 Decimals
 Prerequisites
 Fiscal Date Patterns 
 Monthly Date Pattern
 Weekly Date Pattern
 Forecast Request for Daily Buckets
 Currency Implications 
 Actual Data
 Mean Absolute Deviation
 Mean Absolute Deviation (MAD)
 Percent of Accuracy (POA)
 Best Fit
 Gaps in Forecast
 Forecast Methods
 Second Degree Approximation Method 7
 Actual Forecast Sample Calculation
 Exponential Smoothing Alpha and Beta Calculations
 Exponential Smoothing with Trend/Seasonal Method 12
 Troubleshooting Tips
 Tip 1:  Cause of Insufficient Data
 Tip 2:  Error: Insufficient Fiscal Date Pattern error
 Tip 3:  Buckets combined into one period
 Tip 4:  Weekly forecasts are not generated
 Open Enhancement Requests
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.