Manipulating Orgs For The Demantra Data Load

(Doc ID 789477.1)

Last updated on MARCH 09, 2017

Applies to:

Oracle Demantra Demand Management - Version: 7.1.1 to 7.2
Information in this document applies to any platform.
Demantra Data Load

Symptoms

The business scenario is that  the ISOs are not collected into Demantra when the destination orgs, i.e. the orgs for which ISOs are created, are not 'planning enabled'.  It was observed that the ShipTo Site Code (of internal customer) in the sales staging table is suffixed with the org code of the IPS/CS destination org, but the location staging table does not have the suffix for the same shipto. Hence while data is pushed into Demantra internal tables, it errors out in the T_SRC_SALES_TMPL_ERR table.

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