My Oracle Support Banner

Is There A Way To Find The Total Forecast (consumed + Unconsumed) For a given Item and Organization (Doc ID 1489002.1)

Last updated on MARCH 16, 2020

Applies to:

Oracle Advanced Planning Command Center - Version 12.1.1 and later
Information in this document applies to any platform.

Goal

Q1: Instead of getting the consensus forecast from MSC_DEMANTRA_F, we would like to see if it can be obtained by looking at the ASCP data archived in MSC_DEMANDS_F.
Is there a way to find the total forecast (consumed + unconsumed) for an item, organization in the archive of a given plan ?
 
Q2:  In addition, Order quantity with order type as forecast will show only the forecast that we see in the ASCP workbench which is the part of the forecast that is unconsumed.
We want to see the total forecast that is there in the denorm table. How do we do this?
 

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


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