My Oracle Support Banner

Enhancement Request :Add "NOT IN STOCK (NIS)" to Inventory Fact (Doc ID 2780969.1)

Last updated on JUNE 18, 2021

Applies to:

Oracle Retail Insights Cloud Service Suite - Version 19.0 and later
Information in this document applies to any platform.

Goal

Business requires visibility of the percentage of items/locations Not In Stock (NIS %) to support current dashboards requirements.


NIS % is calculated using the following formula:
  NIS % = Count of Item NIS / Count of Total Item
  Count of Item NIS = If inventory on hand = 0 and coming in inventory (on order, in transit, transfer expected) = 0 then 1 else 0.

 

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.