My Oracle Support Banner

Forecast Data Getting Deleted From Forecast (Doc ID 2360057.1)

Last updated on FEBRUARY 12, 2018

Applies to:

Oracle Materials Requirement Planning - Version 11.5.10.2 and later
Information in this document applies to any platform.

Goal

We are facing issue where user uploading forecast data in Forecast set however that is getting deleted from Forecast and no demand showing in MRP workbench.

We have attached the screen shot for the forecast and MRP plan

When the nightly chain kicks off for the whole set of jobs for MPS/MRP - the first thing that is after the forecast set is in place is that the Consume Forecast process runs. Then once this Consume Forecast Process Runs, then the Load/Copy/Merge of MDS is done
so the steps are

1. Consume Forecast
2. Load/copy/merge MDS
- then runs MRP plans

When we review the Consume Forecast Log file - it appears that the consume process is deleting the forecast ??

MRCFCC module: Consume Forecast Set
.....
===================================================================
Debug Mode : Disabled
Output to Terminal : No
Argument Method : Database Fetch
Trace Mode : Disabled
===================================================================
Argument 1 (ORG_ID) = 465
Argument 2 (FORECAST_SET) = AAAA
Argument 3 (SALES_ORDERS) = 2
Argument 4 (DEMAND_TF) = 2
Argument 5 (START_DATE) =
===================================================================
Deleted from MRP_FORECAST_UPDATES 4,533 0:02
Deleted from MRP_FORECAST_DATES 4,533 0:03 <<<< HERE IT LOOKS LIKE DELETING FORECAST
Deleted from MRP_FORECAST_ITEMS 194 0:00
Updated MRP_FORECAST_DATES 0 0:00
 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.