My Oracle Support Banner

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

Last updated on AUGUST 27, 2018

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


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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