Download Plan Scenario Not Bringing All Items Into Demantra (Doc ID 1326092.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 7.3.0.1 to 7.3.0.1 [Release 7.3.0]
Information in this document applies to any platform.
***Checked for relevance on 16-Apr-2013***

Symptoms

PROBLEM
----------------------
Customer has upgraded from 7.2 to 7.3.0.1.
Supply Data Download is not collecting some items into Demantra that exist in the ASCP plans. Items have forecast and planned orders.

STEPS TO REPRODUCE
----------------------------------------
Customer did a comparative between 7.2 instance and 7.3.0.1 instance for 2 the plans as per details below:


1. Plan_A was run and downloaded into Demantra prior to the upgrade to 7.3.0.1 and 12.1.3.1.
select count(*) from msc_system_items where plan_id = Plan_A_ID
record count: 107496

2. Plan _B was run and downloaded into Demantra after the upgrade to 7.3.0.1 and 12.1.3.1.
select count(*) from msc_system_items where plan_id = Plan_A_ID
record count: 107355

3. Please note that though the item count is different between the two plans, one part number is in both the plans and is in the same organizations for both the plans.
However this part did not get downloaded into Demantra in Plan_B where as it was downloaded in Plan_A.

4. The below count on tables supply_plan_data reflects the same
select * from supply_plan_data where supply_plan_id=Plan_A_ID
record count: 6,137,880

select * from supply_plan_data where supply_plan_id=Plan_B_ID
record count: 5,731,089

Cause

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