My Oracle Support Banner

Support Inventory Availability Calculations In RI For Phase 1 Item Level (Doc ID 2765117.1)

Last updated on APRIL 05, 2021

Applies to:

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


We uses a complex formula to calculate availability, based on SOH and minimum display quantity at item location level:
  Availability = 1- sum (count of item location below) / sum (count item location).
  Count of item location below = Case when (SOH – minimum display quantity < 0 and shelf capacity is not null) then 1 else 0

Since OBIEE repository is closed to changes, this metric needs to be added to the base catalogue to be able to be used on the dashboards.




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.