SDE_RetailSupplierCompliance Incorrect Mapping

(Doc ID 1943721.1)

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:

  1. 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.
  2. The mapping for PROD_IT_NUM should be V_PACKSKU_QTY.ITEM or W_RTL_SUPP_A_TMP.PROD_IT_NUM.

Steps to Reproduce:

  1. 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