> ## Documentation Index
> Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Top SKUs by Inventory Value, Oracle ERP Cloud

**Metrics type:** [Card](/nerve-centre/overview#metrics-types-explained)

## 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   |

Five things to notice:

1. **Top 20 typically hold 60-80% of value.** Operations focus.
2. **High-value SKUs need cycle counts more often.**
3. **Pair with [Inventory Aging](/nerve-centre/kpi-cards/oracle-erp/inventory-aging)**: high-value + aged = priority write-down.
4. **Insurance / loss-prevention focus.**
5. **Drill into per-warehouse**: which DC holds the high-value stock.

## Sibling cards merchants should reference together

| Card                                                                                   | Why pair        |
| -------------------------------------------------------------------------------------- | --------------- |
| [Total Inventory Value](/nerve-centre/kpi-cards/oracle-erp/oerp-total-inventory-value) | Total.          |
| [Inventory Aging](/nerve-centre/kpi-cards/oracle-erp/inventory-aging)                  | Risk view.      |
| [Dead Stock Value](/nerve-centre/kpi-cards/oracle-erp/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 value

**Cross-connector reconciliation:**

Internal Oracle metric.

## Known limitations / merchant FAQs

**Top N tunable?**
Yes (default 20).

**Multi-BU?**
Yes.

***

### Tracked live in Vortex IQ Nerve Centre

*Top SKUs by Inventory Value* is one of hundreds of KPI pulses Vortex IQ tracks across Oracle ERP Cloud and 70+ other ecommerce connectors. Nerve Centre runs the detection layer; Vortex Mind investigates the cause when something moves; Ask Viq lets you interrogate any number in plain English.

[Start for free](https://app.vortexiq.ai/login) or [book a demo](https://www.vortexiq.ai/contact-us) to see this metric running on your own data.