Skip to main content
Metrics type: Supporting Metrics • Category: Ecommerce Platform
Detailed A/R aging across 0-30, 31-60, 61-90, 91-120, 120+ buckets.

​
At a glance

Detailed Accounts Receivable aging from Oracle Receivables, sliced into standard buckets: 0-30, 31-60, 61-90, 91-120, 120+ days past due date. Each bucket shows total dollars and customer count. The diagnostic complement to the DSO headline.

​
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 industrial distributor on Oracle ERP Cloud. Snapshot 14 Apr 26. Total AR $148.2M. Five things to notice:
  1. 5.6% in 90+ buckets ($8.4M). Below the 25% alert threshold. Healthy AR profile.
  2. 18 customers in 120+. These are the chronic-late accounts. Drill into per-customer detail; some may be candidates for collection action or terms tightening.
  3. The 0-30 past-due bucket ($32.4M) is the leading indicator. If this is rising vs prior periods, DSO will rise next month.
  4. Net of Credit Memos appears at the customer level on detail; some 120+ customers may have offsetting Credit Memos pending application.
  5. Cross-reference DSO: AR / Revenue × 90 produces DSO; bucket distribution explains DSO movement.

​
Sibling cards merchants should reference together

​
Reconciling against the vendor’s own dashboard

Where to look in Oracle ERP Cloud:
Receivables → Reports → AR Aging Report (7-bucket) OTBI → Receivables Real Time Subject Area with Bucket Bands = Standard 4 or 7-bucket Customer Account Inquiry for per-customer drill-down
The standard AR Aging Report should match this card to within rounding when bucket boundaries align. Why our number may legitimately differ: Cross-connector reconciliation: This is an Oracle-internal AR metric. No commerce-platform counterpart.

​
Known limitations / merchant FAQs

What is a healthy aging mix for Net-30 B2B? Current 60-70%, 0-30 PD 20-25%, 31-60 5-10%, 61+ under 5%. If 91+ exceeds 5%, collections is slipping. Why are some customers in 120+ but still on credit hold release? Credit hold and aging are independent dimensions. A customer can be on credit hold (cannot place new orders) while still having aged receivables you are collecting on. The hold is on new orders; aging is on existing invoices. Multi-Ledger, can I see per-Ledger aging? Yes via dashboard filter. Disputed invoices, how are they treated? Configurable. Default: included in their bucket; flag visible in detail. If dispute-flagged invoices should not count toward DSO, the field map can exclude. Foreign-currency invoices, FX impact? Each AR transaction translated at the corporate rate; aging bucket assignment uses the original due date in the transaction calendar. FX revaluation runs at period-end may shift dollar values; bucket assignment is currency-neutral.

​
Tracked live in Vortex IQ Nerve Centre

A/R Aging Detail 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.