My Oracle Support Banner

Forecast Consumption Not Occurring For Specific Items During ASCP Plan Run (Doc ID 2458701.1)

Last updated on MARCH 06, 2023

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.


On :

 Example data:

Forecast Setup is in old MRP in EBS source:
Forecast Set = FORSET
Forecast = FSET
Backward/Forward days both = 5
Consume and Advanced Planning Collections are both enabled on forecast set
For itemA they setup 1 daily bucket qty = 30 due 01-DEC-2018
Pegging is End Assembly/Soft Pegging
Forecast Control = Consume and Derive
Bom item type = Standard
In ASCP workbench There's forecast qty = 30 due 01-DEC-2018 and Sales Order qty = 1 due 01-DEC-2018 which did not consume the forecast as the field Consumed forecast is NULL

Plan options -
Spread forecast evenly - enabled
Consume by Forecast bucket - disabled
Backward and Forward Days are NULL - This is ONLY for Demantra forecasts and we're not using Demantra in this example. We did try with consume by forecast bucket and this did not help. It appears to be happening for this one org only

Expect the forecast to be consumed by the sales order

The issue can be reproduced at will with the following steps:
1. Setup MRP source Forecast with backward/forward days
2. Create sales order with same due date as forecast
3. Run data collections
4. Setup and run ASCP plan
5. After reviewing supply demand for the item in the workbench there is no Consumed Forecast even though the Forecast and Sales order show the same due date


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

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