My Oracle Support Banner

V24 UAT - Retail Home Dashboard Not Showing The Subscription Metrics (Doc ID 3048639.1)

Last updated on SEPTEMBER 23, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Goal

Retail Home dashboard 

select count(*) from item_loc il, item_master im where il.status = 'A' and il.item = im.item and im.tran_level = im.item_level; --14 037 358

So the query is returning more than 14 million records, when the Retail Home screen is showing 281. What is the reason the screen is displaying incorrectly?

Solution

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
Goal
Solution
References


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