"Item Level 3 Number" Column Not Showing Correct Value

(Doc ID 2087398.1)

Last updated on DECEMBER 18, 2015

Applies to:

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

Goal

The purpose of this document is to understand the limitations of Retail Analytics in displaying UPC/Barcode information on the Sales Reports/Metrics.


Sample Scenario

Create a report with the following columns in the "Retail Merchandising Analytics As-Was" Subject Area:
  Fiscal Date
  Loc
  Item
  Item Level 1 Number
  Item Level 2 Number
  Item Level 3 Number
  Net Sales Qty
  Net Sales Amt
  EOH Qty

Here the Item Level 3 Number represents the UPC/Barcode.  Run the report and notice that '-1' is displayed for "Item Level 3 Number". Why is RA not displaying the Item Level 3 Number?

Solution

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