Inventory value bucketed by days-on-hand. Aged stock is cash trapped on the floor.
At a glance
Inventory value sliced into ageing buckets: 0-30 days, 31-60, 61-90, 91-180, 181-365, 365+. The longer stock sits, the more capital it ties up and the higher its write-down risk. Computed against the original receipt date in Oracle Inventory Cloud.
| What it counts | SUM(on_hand_quantity × unit_cost) per ageing bucket, where age = days since last receipt date for FIFO layers, or weighted-average receipt date for Average Cost. |
| Tax treatment | n/a, inventory at cost. |
| Cost method | Average Cost / Standard Cost / FIFO per inventory org configuration. |
| In-transit | Excluded by default. |
| WIP / raw materials | WIP excluded; raw materials by default included with separate aging clock. |
| Currency | Reporting ledger consolidated. |
| Business Unit / Inventory Org scope | Respects dashboard filter. |
| Time window | Real-time snapshot. |
| Alert trigger | >15% in 180+ bucket |
| Sentiment key | inv_aging |
| 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 fashion retailer on Oracle ERP Cloud. Snapshot 14 Apr 26. Total inventory value $184M.| Bucket | Value | Share of total |
|---|---|---|
| 0-30 days | $58,200,000 | 31.6% |
| 31-60 days | $42,800,000 | 23.3% |
| 61-90 days | $24,600,000 | 13.4% |
| 91-180 days | $26,400,000 | 14.3% |
| 181-365 days | $22,800,000 | 12.4% |
| 365+ days | $9,200,000 | 5.0% |
| Total | $184,000,000 | 100% |
- 17.4% in 180+ buckets ($32M). Above the 15% alert threshold. For fashion retail, anything past 180 days is genuinely at season-end clearance risk; past 365 is write-down territory.
- **The 365+ bucket (9.2M of 365+ stock is costing about $2M / year in carry.
- Cross-reference Dead Stock Value: zero-velocity items in the aged buckets are write-down candidates. Of the $32M in 180+, perhaps 60% has zero recent sales and qualifies as dead stock.
- Bucket migration trend matters: is value moving from 91-180 into 181-365 (bad, age is increasing), or is it being cleared (good, replaced by fresh receipts in 0-30)? Vortex IQ stores the bucket history so the trend is visible.
- Action playbook: for fashion, run promotional clearance on 91-180 stock at 30 to 40% off; markdown 181-365 to 50%+; consider physical write-off and tax-deduction strategy on 365+. Pair with Margin by SKU to identify which markdowns are most expensive.
Sibling cards merchants should reference together
| Card | Why pair it with Inventory Aging |
|---|---|
| Total Inventory Value | The total this card slices. |
| Dead Stock Value | Zero-velocity overlap with aged stock = write-down candidate. |
| Inventory Carrying Cost | What aged stock is costing per period. |
| Inventory Turnover Ratio | Dragging on turn velocity. |
| Top SKUs by Inventory Value | Which aged SKUs hold the most $. |
| Dead Stock with Active Ad Spend | Aged + still being advertised, the kill shot. |
| Margin by SKU | Markdown cost per SKU when clearing aged inventory. |
Reconciling against the vendor’s own dashboard
Where to look in Oracle ERP Cloud:Inventory → Reports → Inventory Aging by Item OTBI → Inventory Real Time Subject Area (custom analysis with date-bucketed columns) Cost Management → Aged Inventory Report (audit-grade)The native Inventory Aging by Item report sums per ABC class with bucket choices the user picks at runtime. Match the bucket boundaries (0-30, 31-60, 61-90, 91-180, 181-365, 365+) for parity. Why our number may legitimately differ:
| Reason | Direction | Why |
|---|---|---|
| Bucket boundary choice | Either | User-configurable. |
| Cost method effect on layer date | Small | FIFO uses the layer’s receipt date precisely; Average Cost uses weighted-average. |
| Subinventory scope | Either | Quarantine subinventories may be excluded depending on field map config. |
| Card | Direction | Notes |
|---|---|---|
| Commerce-platform stock-on-hand | Approximate | Commerce shows units; the SKU-level age join lives on Inventory Sync Drift. |