How To Keep Forecast Entries For Past Dates When Loading A New Forecast (Doc ID 1064083.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version: 11.5.10.2 to 12.1 - Release: 11.5 to 12.1
Information in this document applies to any platform.
***Checked for relevance on 21-DEC-2011***

ConcurrentProgram:MRCFAL1 - Copy/Merge Forecast
Form:MRPFFDIF.FMB - Enter Forecast Entries

Goal

We need to keep past forecast entries when creating new forecast for the future.
We use Forecast Generation tool in Inventory application to generate our forecasts, but this could also apply to entering forecast via an interface or loading forecast via another method.

We realize that there is an OVERWRITE OPTIONS in Generate forecast or in Copy/Merge Foreast: but my concerns are:
Overwrite Option # 1: All entries
-- Not acceptable as All entries of forecast set are deleted before loading new forecast on them.
Overwrite Option # 2: No
-- Not acceptable as deleting nothing from forecast day onwards will result to duplication of forecast entries.
Overwrite Option # 3: Same Source
-- This will overwrite all entries loaded from the same source.
Example:
Forecast Set DGSET has forecast DGfcstA and DGfcstB
You go to reload entries in DGSET for DGfcstA, and want to keep entries from DGfcstB, then use Same Source only and only entries from DGfcstA will be overwritten.

HOWEVER, none of these options addresses the following concern:
DGfcstA was loaded with forecast from JAN-2010 to JUN-2010 in January
Then in February we have new entries for FEB-2010 to JUN-2010, plus we are loading entries for JUL-2010
AND we want to keep the entries for JAN-2010 in the new forecast.

How can this be accomplished?

Solution

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