My Oracle Support Banner

Web Report Gen2 Issue When Adding Item Category, Report Never Ends In Execution Or It Pops Up Error Message 'No Data Qualified'. (Doc ID 2718062.1)

Last updated on JULY 16, 2021

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 20.2 and later
Information in this document applies to any platform.

Symptoms

On : 20.2 version, Gen2 Web Reports

ACTUAL BEHAVIOR
---------------

When trying to replicate a gen1 report in the gen2 report, but when adding category the joins between the tables is not working as expected.


categories:
batch_number:

allocation
container
load
ob_stop
ob_stop_dtl
order_dtl
to_inventory
item
batch_number

report is no joining in the right way the tables,
item and batch categories not working properly.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Oracle Warehouse on Cloud > Company/Facility>
2. Navigation Path: UI > Gen2 Web Reports >
3. > OB load >

categories: batch_number:

allocation
container
load
ob_stop
ob_stop_dtl
order_dtl
to_inventory
item
batch_number

Cause

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
Symptoms
Cause
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.