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