My Oracle Support Banner

Unable To Consume Demantra Global Forecast With Ascp Inline Forecast Consumption (Doc ID 560953.1)

Last updated on AUGUST 19, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0.4 and later
Information in this document applies to any platform.
FORM:MSCFNSCW.FMB - Planner Workbench


-- Problem Statement:
On EBS R12.0.4 in Test:
Find in ASCP Unconstrained Plan, the Sales Orders do not consume the global forecast loaded from ODP/Demantra. These are for standard finished goods.  They can successfully consume a forecast generated in MRP and picked up by data collections. Please note that the sales order data is loaded via Legacy collections and not through standard ASCP collections

Things we tried:
1. Initially found that profile option MRP:Compute Sales Order Changes was not set. So we set it to yes but the issue is not resolved

2. We tried with only backward and forward days set (10 for both) in the ASCP plan options and reran the plan making sure Consume by Forecast Bucket was disabled. No consumption occured

3. We tried the same in step 2 but also enabled and disabled Consume by Forecast Bucket in the plan options - neither way worked with or without backward/forward days selected

Profile Options and settings:
1. Source instance Item's Forecast Control is "Consume and Derive".
2. Source instance Profile option MRP:Compute Sales Order Changes : Yes
3. Source instance Profile option MRP:Consume Fcst Set Summary : NULL
4. Source instance Profile MRP:Consume Forecast : Yes
5. Source instance Sales Order schedule ship date falls within the Backward/Forward days on the forecast set
6. Plan Option CONSUME BY FORECAST BUCKET: Currently disabled
7. Plan Option Backward Consumption Days: 10
8. Plan Option Forward Consumption Days: 10
9. Plan Option Include Sales Orders: Yes
10. Destination profile MSC: Consume Forecast Inside Demand = Yes
11. Destination profile MSC: Consume Forecast with No Demand = Within each bucket
12. Destination profile MSC: Consume Forecast using Internal = No 

Expect plan to consume forecasts from Demantra

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Load Demantra Global Forecast
2. Load sales orders to ASCP using Legacy collections and not ASCP Standard Collections
3. Run ASCP Plan
4. Notice that Plan does not consume forecast loaded


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.