At a glance
Top 20 SKUs by on-hand inventory value. Pareto view: typically 20% of SKUs hold 80% of value.
| What it counts | SUM(on_hand × unit_cost) GROUP BY item ORDER BY value DESC LIMIT 20. |
| Currency | Reporting ledger. |
| Time window | Real-time. |
| Roles | owner, finance, operations |
Calculation
Calculated automatically from your Oracle ERP Cloud data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A Fortune 500 retailer’s top 5 SKUs by inventory value:| SKU | On-hand value |
|---|---|
| FURN-SOFA-EXEC | $4,820,000 |
| FURN-DESK-CEO | $3,420,000 |
| ELEC-TV-OLED-65 | $2,840,000 |
| FURN-CHAIR-EXEC | $2,420,000 |
| ELEC-LAPTOP-PRO | $2,180,000 |
- Top 20 typically hold 60-80% of value. Operations focus.
- High-value SKUs need cycle counts more often.
- Pair with Inventory Aging: high-value + aged = priority write-down.
- Insurance / loss-prevention focus.
- Drill into per-warehouse: which DC holds the high-value stock.
Sibling cards merchants should reference together
| Card | Why pair |
|---|---|
| Total Inventory Value | Total. |
| Inventory Aging | Risk view. |
| Dead Stock Value | Idle inventory. |
Reconciling against the vendor’s own dashboard
Where to look in Oracle ERP Cloud:OTBI → Inventory Real Time rank by valueCross-connector reconciliation: Internal Oracle metric.