My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

On : 12.1.3 version, Memory Based Planner in TEST:

Users are on 12.1.3 and have applied VCP 12.1.3.8 Patch 14247039 - using 64 bit Linux Snapshot with version MSCNPL64.ppc 120.2.12010000.58.1201010.12 from one off patch 27550339 applied 21-APR-2018. Users are testing inline forecast consumption in ASCP. However it does not appear to be working. Example data:

Forecast Setup is in old MRP in EBS source:
Forecast Set = TOL_FORSET
Forecast = TOLK_BRL
Backward/Forward days both = 5
Consume and Advanced Planning Collections are both enabled on forecast set
For item = VA127435-040 they setup 1 daily bucket qty = 30 due 01-DEC-2018

item = VA127435-040
Org = BSY:TOL
Pegging is End Assembly/Soft Pegging
Forecast Control = Consume and Derive
Bom item type = Standard
In ASCP workbench for plan name = TODAY_UNA - 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
sales order demand id = 169346149 and origination type = 30 which is regular sales order

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
 

EXPECTED BEHAVIOR
-----------------------
Expect the forecast to be consumed by the sales order

STEPS
-----------------------
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

Changes

 

Cause

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
Symptoms
Changes
Cause
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.