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 18.104.22.168 to 22.214.171.124 [Release 7.3.0]
Information in this document applies to any platform.
Demantrra 7315 and Oracle VCP 126.96.36.199
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
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