:Duplicate Qty Lines When Published From Demantra To ASCP Denorm Table (Doc ID 1912187.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.3.1.5 to 7.3.1.5 [Release 7.3.0]
Information in this document applies to any platform.

Symptoms

Demantrra 7315 and Oracle VCP 12.1.3.9

We have an export integration interface with levels
Item, Demand Class, Organization and Ship to Site.

In the export integration interface we have one line for all the lowest levels in the Demantra materialized view.
When it is published to ASCP denorm table we are having 2 lines. This seems to because of the dkey_site from the materilaized view joined to msc_tp_site_id_lid.tp_site_id. In this table msc_tp_site_id_lid we have 2 records for the tp_site_id. Is this logic correct of joining dkey_site to msc_tp_site_id_lid.tp_site_id

Please see screenshots attached

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