Skip to main content
Metrics type: Card
On-hand inventory at landed cost in Oracle ERP Cloud. The working-capital line on the balance sheet.

​
At a glance

The dollar value of all on-hand inventory across every Oracle Inventory Cloud organisation, valued at the configured cost method (typically Average Cost or Standard Cost in Fortune 500 implementations). The working-capital line that appears on the Balance Sheet and the denominator of inventory turnover.

​
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 + Oracle Inventory Cloud, with Manufacturing module enabled for furniture assembly. Snapshot 12 Apr 26. Five things to notice:
  1. **277MontheBalanceSheet.∗∗Thisistheworking−capitaldenominatorforinventory−turnanalysis.AtanannualCOGSof277M on the Balance Sheet.** This is the working-capital denominator for inventory-turn analysis. At an annual COGS of 1.4B, the implied turnover is 5.05 (1,400 / 277), a healthy figure for retail home goods.
  2. WIP at $11.8M. Indicates the Manufacturing module is recording in-progress assembly cost. If WIP age is rising (drill into Inventory Aging), production cycle is slowing.
  3. **EU stock at 48.4M.∗∗Cross−currencyexposure:heldinEURandGBPatthelocalledger,translatedtoUSDatcorporaterate.FXmovesof548.4M.** Cross-currency exposure: held in EUR and GBP at the local ledger, translated to USD at corporate rate. FX moves of 5% would shift the consolidated figure by ~2.4M without any underlying physical change. Pair with FX Currency Exposure.
  4. Cycle-count health. The card is only as accurate as the cycle counts feeding it. Oracle’s Cycle Count program runs monthly or quarterly per ABC class. If counts are overdue, the system value drifts from physical reality.
  5. Aged subset (>180 days): Cross-reference Inventory Aging and Dead Stock Value for the part of this $277M that is at write-down risk.

​
Sibling cards merchants should reference together

​
Reconciling against the vendor’s own dashboard

Where to look in Oracle ERP Cloud:
Inventory → Reports → Inventory Value Report (per inventory org) OTBI → Inventory Real Time Subject Area → On Hand Value Cost Management → Inventory Valuation Report (audit-grade, period-end)
The standard Inventory Value Report run at the same period-end as the dashboard snapshot should match this card to within rounding. The Cost Management Inventory Valuation Report is the audit version that locks period-end values for financial-close use. Why our number may legitimately differ: Cross-connector reconciliation:

​
Known limitations / merchant FAQs

Why is the card different from the period-end Inventory Valuation? Card is live; valuation is fiscal-close locked. Mid-period the card rises and falls with each receipt and shipment. At period close they should converge. Average Cost vs Standard Cost, which does the card use? Whichever the inventory org is configured for. Multi-org Fortune 500 implementations often mix: distribution orgs on Average Cost, manufacturing on Standard Cost. The card sums the value as-configured. Does this include consigned inventory? No by default. Consigned (supplier-owned, on your shelf) is not your Balance Sheet asset. If your implementation uses Vendor Managed Inventory (VMI) and you have ownership flag = yours, then yes. Why does WIP appear? Manufacturing module bookkeeping. WIP captures the partially-converted material plus labour plus overhead absorbed during the production process. Pre-finished-goods completion. FX impact on the consolidated value? Multi-Ledger: each org’s inventory value is held in the org’s currency, translated to reporting currency at the configured FX rate. Translation cadence per ledger configuration. The card reports the post-translation consolidated value. Cycle-count accuracy, how do I know my number is right? Oracle’s Cycle Count Performance Report shows variance trends. ABC class A items should be counted weekly/monthly; class C quarterly. If variance is rising, the card is drifting from physical reality. Differences vs SAP MM inventory valuation? SAP S/4HANA’s stock value lives in tables MBEW (per material) and MBEWH (history); Oracle’s lives in CST_INV_LAYERS and MTL_ONHAND_QUANTITIES. Conceptually identical, mechanically different. Vortex IQ supports both. Differences vs NetSuite inventory valuation? NetSuite has a single integrated inventory valuation; Oracle has separate Cost Management and Inventory modules with explicit cost-method election per inventory org. Oracle is more flexible (multi-method); NetSuite is simpler. Same underlying concept of quantity × unit_cost. Oracle Analytics Cloud (OAC) shows a different number, why? OAC pulls from the same data store but at a different cadence (typically nightly batch vs our 15-minute REST API pull). At month-end close the two converge.

​
Tracked live in Vortex IQ Nerve Centre

Total 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 or book a demo to see this metric running on your own data.