:Duplicate Qty Lines When Published From Demantra To ASCP Denorm Table
Last updated on SEPTEMBER 08, 2016
Applies to:Oracle Demantra Demand Management - Version 126.96.36.199 to 188.8.131.52 [Release 7.3.0]
Information in this document applies to any platform.
Demantrra 7315 and Oracle VCP 184.108.40.206
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
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