On-Hand Inventory Value (by Inventory Org), Oracle ERP Cloud

On-Hand Inventory Value (by Inventory Org) from Oracle ERP Cloud. The live total dollar value of on-hand inventory, viewable by Oracle Inventory Cloud organisation, the executive working-capital headline for stock on the floor.

Metrics type: Supporting Metrics • Category: Ecommerce Platform

Live total dollar value of on-hand inventory, viewable by Oracle Inventory Cloud organisation. The executive working-capital headline for stock on the floor.

At a glance

The live total dollar value of on-hand inventory across the business, surfaced at the executive level and breakable out by Oracle Inventory Cloud organisation. This is the working-capital headline a CFO or COO glances at first: how much cash is sitting as stock on the floor right now, valued at the configured cost method. It is the executive-overview cut of the same data that the Total Inventory Value card holds for finance and that the Inventory Value by Inventory Org card breaks down for operations. Same underlying number, framed for the boardroom.

What it counts	On-hand quantity multiplied by unit cost, summed live across all inventory organisations in scope, valued at the cost method configured per org. Includes finished goods, raw materials, and WIP (where the Manufacturing module is enabled). Excludes consigned stock owned by suppliers, in-transit not yet received, and customer-owned inventory.
Currency	Multi-Ledger: consolidated in the reporting ledger’s currency at cost-rate FX. The org breakout can show native currency per org.
Cost method	Respects the method configured per inventory org (typically Average Cost for distribution, Standard Cost for manufacturing).
Inventory Org scope	Respects the dashboard’s Business Unit and inventory-org filter. The executive view rolls every org into one headline, then lets you drill by org.
Time window	Real-time snapshot (RT).
Alert trigger	None by default. This is a headline working-capital figure; pair with Inventory Turnover Ratio and Slow-Moving Items for actionable alerts.
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 US Fortune 500 omnichannel home-goods retailer on Oracle ERP Cloud plus Oracle Inventory Cloud. The executive dashboard snapshot is 12 Apr 26. Reporting ledger is the US ledger (USD).

View	Value (USD)
On-hand inventory value, all orgs (executive headline)	$280,300,000
of which US distribution orgs	$207,300,000
of which EU distribution orgs	$48,400,000
of which Manufacturing (WIP plus raw)	$24,600,000
Annualised COGS run-rate	$1,400,000,000

Five things to notice:

1. **$280.3M is the one number the executive committee tracks.** It is the live working-capital headline for stock. Against an annualised COGS of$1.4B, the implied inventory turnover is roughly 5.0, which the executive view annotates so the headline carries context, not just a dollar figure.
2. The executive view is a roll-up, not a new calculation. This card sums exactly the same on-hand value as Total Inventory Value and Inventory Value by Inventory Org. The difference is framing and audience: this is the boardroom headline with a turnover annotation; the others serve finance close and operations planning.
3. The org breakout is one click away. The headline answers “how much”; the breakout answers “where”. US distribution holds 74% of the working capital, so any executive conversation about freeing cash starts there. Drill via Inventory Value by Inventory Org.
4. It is live, so it moves intraday. Unlike the period-close Balance Sheet line, the executive headline updates with each receipt and shipment. A large inbound container can lift it by several million within a sync window. At fiscal close, the live figure and the locked Balance Sheet value converge.
5. FX moves the headline without any physical change. $48.4M of the total sits in EU orgs in EUR and GBP. A 5$2.4M with no stock movement at all. Pair with FX Currency Exposure so the executive view does not misread an FX swing as an inventory build.

Sibling cards merchants should reference together

This executive headline is the entry point to the inventory-health family. Pair it with these to move from the boardroom number to the operational detail.

Card	Why pair it with On-Hand Inventory Value
Total Inventory Value	The finance-close framing of the same on-hand value. Same number, audit-grade context.
Inventory Value by Inventory Org	The operations drill-down: which warehouse, plant, or DC holds the headline.
Inventory Turnover Ratio	Turns the headline dollar value into an efficiency signal.
Slow-Moving Items (>90d no movement)	The at-risk fraction of the headline.
Dead Stock Value	The write-down-candidate fraction of the headline.
Inventory Carrying Cost	What the headline stockpile costs per period to hold.

Reconciling against Oracle ERP Cloud

Where to look in Oracle ERP Cloud:

Navigator → Inventory → Reports → Inventory Value Report (all orgs, for the headline; per org, for the breakout) Navigator → Cost Management → Inventory Valuation Report (audit-grade, period-end) Reports and Analytics → OTBI → Inventory Real Time Subject Area → On Hand Value (total, then grouped by org)

The Inventory Value Report run across all orgs at the same snapshot date should match the executive headline to within rounding, and run per org should match the breakout. The Cost Management Inventory Valuation Report is the audit version that locks period-end values for financial-close use.

Common mistakes when comparing against Oracle’s own reports:

• Comparing the live headline to the locked Balance Sheet line. The card is live and moves intraday; the Balance Sheet line is fiscal-close locked. Mid-period they differ; at close they converge.
• Scope mismatch between headline and report. Running the Oracle report at a single Business Unit while reading the all-orgs headline will never reconcile. Match the scope.
• Subinventory and ownership filters. A report that excludes Quarantine or includes consigned-with-ownership reads differently from the card’s defaults.

Why our number may legitimately differ from Oracle’s reports:

Reason	Direction	Why
Live snapshot vs period close	Either	The executive headline is real-time; the period-end valuation is locked. Mid-period the headline moves with each receipt and shipment.
Cost method per org	Either	Average Cost revalues with each receipt; Standard Cost holds with variances posted separately. The card respects the per-org election.
FX translation cadence	Small	EU org values translate to the reporting currency at the configured cost rate. A rate change moves the headline without a physical change.
Subinventory inclusion	Either	Card includes all subinventories by default; a report excluding Quarantine or Damage reads lower.
Landed Cost timing	Card may understate	Unprocessed Landed Cost Management documents mean duty and freight have not yet rolled into unit cost.

Known limitations / merchant FAQs

How is this different from the Total Inventory Value card? It is the same on-hand value, framed for a different audience. This card is the executive-overview headline, presented with working-capital context (such as an implied turnover annotation) and a one-click org breakout. Total Inventory Value is the finance-close framing of the identical figure. They will always agree at the same scope and snapshot.

And how is it different from Inventory Value by Inventory Org? Inventory Value by Inventory Org leads with the per-org bar chart for operations planning. This card leads with the consolidated executive headline and treats the org breakout as a drill-down. Same data, opposite emphasis.

Why does the headline move during the day? Because it is live. Each receipt, shipment, transfer, and adjustment changes on-hand value, and the card reflects that at every sync. The period-close Balance Sheet figure is locked; this is the running figure that converges to it at close.

Does it include WIP? Yes, for orgs where the Manufacturing module is enabled. WIP is partially-converted material plus absorbed labour and overhead. For pure distribution estates there is no WIP and the headline is finished goods plus raw materials.

What does it exclude? Consigned stock owned by suppliers, in-transit not yet received into an org, and customer-owned inventory. These are not your Balance Sheet asset, so they sit outside the headline by default.

How does FX affect the executive headline? Each non-functional-currency org’s value is translated to the reporting currency at the configured cost rate. A currency swing moves the consolidated headline with no physical change in stock, which is why the executive view should be read alongside FX Currency Exposure.

Can the executive view show native currency per org? Yes. The headline is consolidated in the reporting currency, but the org breakout can toggle to each org’s native ledger currency for local operations leaders.

Oracle Analytics Cloud shows a slightly different total. Why? OAC typically refreshes on a nightly batch while this card pulls on a 15-minute REST API cadence, and OAC’s subject area may apply a subinventory or ownership filter your implementation configured. Align the cadence and filters and the two converge, fully at month-end close.

---

Tracked live in Vortex IQ Nerve Centre

On-Hand Inventory Value (by Inventory Org) 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 or book a demo to see this metric running on your own data.