All Inventories Value Report or Inventory Value Report - No Data Found when run by Subinventory with same first category code segment. (Doc ID 748537.1)

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle Cost Management - Version 12.0.4 and later
Information in this document applies to any platform.

Goal

On 12 in Production: 

Run All Inventories Value Report or Inventory Value Report - by Subinventory CSTRINVR.rdf with same first category code segment, report shows 'NO DATA FOUND'. 

STEPS
---------

CSTRINVR.rdf-->Inventory Value Report - by Subinventory
CSTRAIVR.rdf-->All Inventories Value Report

Run the report with all category code segment, it works fine.
Run the report with first category code segment (diff from - to), it works fine.
Run the report with same first category code segment, report shows 'NO DATA FOUND'.

Go to Cost Management responsibility --> Reports-->  Value -->'All Inventory Value report'.

From the log file
-------------------------------------------------
the category set is
Categories From COMMERCIAL||| To ELECTRONICS|||-->All categories
Category Set: INVLOB

Could see Data for Electronics and Commerical

----------------------------------
If the category set selected is

Categories From COMMERCIAL||| To COMMERCIAL|||
Categories From ELECTRONICS||| To ELECTRONICS|||
Category Set: INVLOB

then All Inventories Value Report or Inventory Value Report - by Subinventory

Shows
***** No Data Found *****

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