My Oracle Support Banner

Creating Zero Forecast Records In Forecast Set Through Standard Interface (Doc ID 1635106.1)

Last updated on AUGUST 19, 2019

Applies to:

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

Goal

Qn1:We are loading/updating forecast by inserting the records into standard interface and they were not processing as expecting for the 0 Qty records.
If there is forecast for the same item in the forecast set, system processing making them as null (by deleting those records) since the new forecast quantity 0 for those buckets which is fine, but if there are no forecast records for the buckets which are going to be processed not being as null, those records being created with value 0.
We are expecting those records should not be created since there is Zero forecast even there are no existing combinations of item and buckets.
 
Qn2:One more thing the concurrent process was not processing/creating records if starting date of the bucket (for weeks and period) is non working day, actually it should create by push it to next available working day of the week/period. This is standard oracle functionality as we aware of this process but that is not happening over here. For example we have 5 day on and 2 day off calendar and when we process the forecast records by weekly buckets and monday is off for any one of the week that record not creating in forecast.
 

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!


In this Document
Goal
Solution
References


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