MARKUP_CALC_TYPE_CODE Mapping Is Missing in SDE_RetailProductDimensionHierarchyDeptTempLoad
(Doc ID 1912906.1)
Last updated on FEBRUARY 15, 2019
Applies to:Oracle Retail Merchandising Insights - Version 14.0 and later
Information in this document applies to any platform.
The mapping of DEPS.MARKUP_CALC_TYPE_CODE to W_RTL_PROD_CAT_DH_TMP.MARKUP_CALC_TYPE_CODE is missing in interface SDE_RetailProductDimensionHierarchyDeptTempLoad.
Steps to Recreate:
- Execute the job PRDHIERSDE.KSH.
- Notice the column MARKUP_CALC_TYPE_CODE in the target table W_RTL_PROD_CAT_DH_TMP is loading NULL at the interface SDE_RetailProductDimensionHierarchyDeptTempLoad.
- Observe that the column PROD_ATTR5_NAME from W_RTL_PROD_HIER_ATTR_LKP_DHS was also loaded as NULL.
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