Location ID Is Present In Sales Data But Not Present In Neither MDP_MATRIX Nor LOCATION Tables

(Doc ID 2347758.1)

Last updated on JANUARY 11, 2018

Applies to:

Oracle Demantra Demand Management - Version 12.2.3 and later
Information in this document applies to any platform.

Goal

We have identified few location ids in sales data which are not present in MDP_MATRIX or LOCATION table and neither they are visible in any worksheets. these locations had some forecast quantity after the previous engine run and now as the locations are not there in MDP_MATRIX or LOCATION they do not depict in worksheets as well, causing wrong forecast quantity to be shown. Can you please help determining why the location ids are present in SALES_DATA but not in MDP_MATRIX or LOCATION tables as seen in database.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms