SDE_RetailSupplierCompliance Incorrect Mapping
Last updated on AUGUST 17, 2016
Applies to:Oracle Retail Merchandising Analytics - Version 13.3.6 and later
Information in this document applies to any platform.
Interface SDE_RetailSupplierComplianceTempLoad_G2 has an incorrect mapping for PROD_IT_NUM in the target table.
This is based on the following:
- The component item number should be mapped instead of pack number. Quantities are blown down to component level, but the PROD_IT_NUM is pack number which gives incorrect information. Hence the component item number should be mapped to PROD_IT_NUM.
- The mapping for PROD_IT_NUM should be V_PACKSKU_QTY.ITEM or W_RTL_SUPP_A_TMP.PROD_IT_NUM.
Steps to Reproduce:
- Run interface SDE_RetailSupplierComplianceTempLoad_G2
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