There Is No Placeholder in Retail Analytics (RA) to Identify the Primary Supplier for an Item

(Doc ID 2049946.1)

Last updated on JUNE 13, 2017

Applies to:

Oracle Retail Merchandising Insights - Version 13.2.4 and later
Information in this document applies to any platform.


There is no placeholder in Retail Analytics (RA) to identify a particular primary supplier.

Steps to Recreate:

  1. In RMS, create a new item and attach a primary supplier.
  2. Run the batches ( SDE_RETAILITEMSUPPLIERDIMENSION, SIL_RETAILITEMSUPPLIERDIMENSION ) and confirm that the supplier details are passed to RA by verifying data in W_RTL_IT_SUPPLIER_D table.
  3. Log in to RMS and add another supplier to the item and make it as primary supplier.
  4. Run the batches again and notice that there will be 2 records in RA; however, there is no placeholder to identify the primary supplier.


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