My Oracle Support Banner

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

Last updated on AUGUST 25, 2022

Applies to:

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


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.



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

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