> ## 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. # Dead Stock Value, Oracle ERP Cloud > Items with on-hand value > 0 and zero sales in 180 days. Direct write-down candidate. How to read it, why it matters, and how to act on it. **Metrics type:** [Key Metrics](/nerve-centre/overview#metrics-types-explained) • **Category:** [Ecommerce Platform](/nerve-centre/connectors#connectors-by-type) > Items with on-hand value > 0 and zero sales in 180 days. Direct write-down candidate. ## At a glance > Items in Oracle Inventory Cloud with `on_hand_value > 0 AND sales_last_180_days = 0`. The direct write-down list. Sums the dollar value of dead stock across all inventory orgs in the Business Unit scope. | | | | ------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **What it counts** | `SUM(on_hand_quantity × unit_cost)` filtered to items where the trailing-180-day sales velocity is zero. Sales velocity drawn from Order Management shipped-line history. Configurable threshold (60D, 90D, 180D) per industry. | | **Tax treatment** | n/a, inventory at cost. | | **Cost method** | Per inventory-org configuration. | | **In-transit / WIP / raw materials** | Excluded; only finished goods on-hand qualify. | | **Sales velocity scope** | All sales channels (commerce, B2B, marketplace, wholesale) consolidated through Oracle Order Management. | | **Currency** | Reporting ledger. | | **Business Unit scope** | Respects dashboard filter. | | **Time window** | Real-time snapshot vs 180-day trailing sales. | | **Alert trigger** | `>$25k dead` (default), tunable. | | **Sentiment key** | `dead_stock` | | **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 outdoor-equipment retailer on Oracle ERP Cloud. Snapshot 14 Apr 26. Total inventory \$124M. | Cut | Value | | ------------------------------------------ | ------------ | | Dead stock (180D zero sales + on-hand > 0) | \$14,800,000 | | Of which: aged 365+ days | \$6,200,000 | | Of which: ad spend in last 30D > \$500 | \$2,400,000 | | Number of dead-stock SKUs | 1,840 | Five things to notice: 1. **\$14.8M of dead stock = 11.9% of total inventory.** Above the comfort zone; healthy outdoor retail keeps dead-stock ratio under 8%. 2. \*\*$6.2M is aged 365+ days.** This is the immediate write-down conversation. At 50% NRV (net realisable value at clearance) the P&L hit is $3.1M. 3. **\$2.4M is dead AND has active ad spend.** This is the [Dead Stock with Active Ad Spend](/nerve-centre/kpi-cards/oracle-erp/dead-stock-with-active-ad-spend) cross-platform kill shot. Pause those ads immediately. 4. **1,840 SKUs is a long tail.** Pareto applies: the top 100 dead-stock SKUs probably hold 60% of the value. Sort by unit value descending and tackle the heavy hitters first. 5. **Action playbook:** Pause ads on dead SKUs, clearance markdown 30 to 50%, write-off / scrap aged 365+ items, audit purchasing logic to prevent recurrence (the buyer who ordered the 365+ stock should have a conversation). ## Sibling cards merchants should reference together | Card | Why pair it with Dead Stock Value | | ----------------------------------------------------------------------------------------------------- | ----------------------------------------------- | | [Inventory Aging](/nerve-centre/kpi-cards/oracle-erp/inventory-aging) | Aged stock + zero-sales = high-confidence dead. | | [Total Inventory Value](/nerve-centre/kpi-cards/oracle-erp/oerp-total-inventory-value) | Denominator for dead-stock ratio. | | [Dead Stock with Active Ad Spend](/nerve-centre/kpi-cards/oracle-erp/dead-stock-with-active-ad-spend) | The kill shot: dead + still being advertised. | | [Inventory Carrying Cost](/nerve-centre/kpi-cards/oracle-erp/oerp-inventory-carrying-cost) | Cost of holding the dead stock. | | [Top SKUs by Inventory Value](/nerve-centre/kpi-cards/oracle-erp/oerp-top-skus-value) | High-value dead SKUs to prioritise. | | [Dead Stock Threshold Breach](/nerve-centre/kpi-cards/oracle-erp/dead-stock-threshold-breach) | The alert layer on this card. | ## Reconciling against the vendor's own dashboard **Where to look in Oracle ERP Cloud:** Oracle does not ship a single Dead Stock report; build via OTBI: > **OTBI → Inventory Real Time Subject Area** + **Order Management Real Time** joined on Item, filtered for `On Hand > 0 AND Shipped Quantity (180D) = 0` > **Reports → Inventory → Slow / No Movement Report** The Slow / No Movement Report is the closest native equivalent. **Why our number may legitimately differ:** | Reason | Direction | Why | | -------------------------------- | ------------------- | --------------------------------------------------------------------------- | | **Velocity threshold** | Either | 90 / 180 / 365 day choice changes the dead-stock universe. | | **New-product warmup exclusion** | Card may understate | Newly-launched items below 60-day age may be excluded to avoid false flags. | | **Seasonality calendar** | Either | Configurable per merchant; off-season items not counted as dead. | **Cross-connector reconciliation:** | Card | Direction | Notes | | ----------------------------------------------------------------------------------------------------- | ----------- | -------------------------------------------------------- | | [Dead Stock with Active Ad Spend](/nerve-centre/kpi-cards/oracle-erp/dead-stock-with-active-ad-spend) | Subset | Dead SKUs that still have ad spend, the kill shot. | | Commerce-platform low-conversion product cards | Approximate | Commerce sees zero-conversion; Oracle sees zero-shipped. | ## Known limitations / merchant FAQs **What is a healthy dead-stock-as-percent-of-total ratio?** By industry: fashion 5-12%, electronics 3-8%, industrial / B2B distribution 8-15%, grocery / consumables under 3%. Above the upper end means purchasing forecasts are systematically over-shooting demand. **Why 180 days as the default?** Industry standard for "no clear demand signal". Configurable per workspace. **Seasonal merchants, does the card respect seasonality?** Yes via a seasonality calendar in the field map. Snow gear sold zero in July is not dead; it is seasonal. Without a calendar, all 180D-zero items flag. **My new-product launches always show as dead-stock initially. Will they appear here?** Yes, if 180+ days passed and they have not sold. The new-product flag (custom item attribute) suppresses the alert during a configurable warmup period (default 60 to 90 days). **Does this include consigned inventory?** No. Consigned (supplier-owned, on your shelf) is not your write-down risk. **Multi-Business-Unit, per-BU view?** Yes. Drill-down by BU reveals which warehouse / DC has the dead-stock problem. **SAP equivalent?** SAP S/4HANA has the Stock Aging app + a Slow/Non-Moving Materials Fiori app; conceptually the same. **NetSuite equivalent?** NetSuite Inventory Items → Saved Search: `quantity_available > 0 AND sales_last_180_days = 0`. Vortex IQ runs equivalent logic on both NetSuite and Oracle, allowing customers in transition between the two to keep continuous reporting. **RMCS or revenue-recognition impact?** None. This card is inventory-side, not revenue-side. **Auto-action available?** Pause-ads-on-dead-SKU action via [Dead Stock with Active Ad Spend](/nerve-centre/kpi-cards/oracle-erp/dead-stock-with-active-ad-spend). Markdown / write-off remain manual decisions for Finance. *** ### Tracked live in Vortex IQ Nerve Centre *Dead Stock 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.