FUSION : CST : Inventory Turns Report not Returning any data with message "The specified criteria didn't result in any data." (Doc ID 2957204.1)

Last updated on AUGUST 28, 2023

Applies to:

Symptoms

On : 11.13.23.01.0 version,

While attempting to execute the Report Inventory Turns report

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


Inventory Turns report is throwing error while giving date parameters across the months with following Error 

"The specified criteria didn't result in any data. This is often caused by applying filters and/or selection steps that are too restrictive or that contain incorrect values. Please check your analysis filters and selection steps, and try again. The filters or selection steps currently being applied are shown below.

Filters
Primary Book Flag is equal to / is in Yes
and ("- Inventory Valuation Details - Onhand"."As of Date" <= (date '2023-01-01') AND "- Inventory Valuation Details - Onhand"."End Date" > (date '2023-01-01') ) OR ("- Inventory Valuation Details - Onhand"."As of Date" <= (date '2023-04-30') AND "- Inventory Valuation Details - Onhand"."End Date" > (date '2023-04-30') )
and "Costing - COGS and Gross Margin Real Time"."Revenue Details"."Accounted Date" >= (date '2023-01-01') AND "Costing - COGS and Gross Margin Real Time"."Revenue Details"."Accounted Date" < (date '2023-04-30') anges the following error can be viewed"

EXPECTED BEHAVIOR
-----------------------
Report should return values at all the date ranges

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Report & Analytics

2. Use the Navigation : Fusion > Reports & analytics > Supply Chain Management > Cost Management > Transactional Analysis samples > Inventory Turns

3. Execute the Report Inventory Turns report

Cause

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