Integration Of Non Merchandising Sales is Missing in Retail Insights (Doc ID 2525097.1)

Last updated on AUGUST 16, 2022

Applies to:

Goal

Users  are trying to load the Transactions for  Non Merchandise Items from Retail Sales Audit (ReSA) RDWT file to Retail Insights (RI/RA), but these transactions Data is getting dropped in Sales Fact table because such Items are missing /not loaded in  RMS ITEM_MASTER and Item Dimension - W_PRODUCT_D . 
  
Users perform a lookup of  FS table on W_PRODUCT_D Dimension to populate the Fact table , and at that point since these Items (Non Merchandise Items )are not present in W_PRODUCT_D , the Sales related to it is getting dropped. And, also ITEM_LOC, ITEM_LOC_SOH and ITEM_SUPPLIER are joined as well while loading to RA. 

How should user load these data into RI?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.