My Oracle Support Banner

"Item Level 3 Number" Column Not Showing Correct Value (Doc ID 2087398.1)

Last updated on DECEMBER 03, 2019

Applies to:

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


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
  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?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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