> ## 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.

# Returns Count, Oracle ERP Cloud

> Returns Count for Oracle ERP Cloud stores. Tracked live in Vortex IQ Nerve Centre. How to read it, why it matters, and how to act on it.

**Metrics type:** [Supporting Metrics](/nerve-centre/overview#metrics-types-explained)  •  **Category:** [Ecommerce Platform](/nerve-centre/connectors#connectors-by-type)

## At a glance

> Number of RMA (Return Material Authorisation) Sales Orders created in the period. The volume side; pair with [Credit Memo Value](/nerve-centre/kpi-cards/oracle-erp/oerp-credit-memos-value) for \$.

|                    |                                               |
| ------------------ | --------------------------------------------- |
| **What it counts** | `COUNT(SO WHERE order_type = RMA)` in window. |
| **Currency**       | n/a.                                          |
| **Time window**    | `30D vsP`                                     |
| **Alert trigger**  | `up >20% vsP`                                 |
| **Sentiment key**  | `returns_trend`                               |
| **Roles**          | owner, 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 retailer on Oracle ERP Cloud. 30D window.

|                               | This period | Prior |
| ----------------------------- | ----------- | ----- |
| RMA SO count                  | 384         | 348   |
| Return rate vs orders shipped | 8.0%        | 7.6%  |

Five things to notice:

1. **10% increase vsP, just below 20% alert.** Watching.
2. **Pair with reason codes** to see if quality / sizing / shipping issues spiking.
3. **Per-SKU drill** identifies problem products.
4. **Per-channel** distinguishes commerce returns from B2B.
5. **Cross-reference [Credit Memo Value](/nerve-centre/kpi-cards/oracle-erp/oerp-credit-memos-value)** for \$ impact.

## Sibling cards merchants should reference together

| Card                                                                              | Why pair                       |
| --------------------------------------------------------------------------------- | ------------------------------ |
| [Credit Memo Value](/nerve-centre/kpi-cards/oracle-erp/oerp-credit-memos-value)   | Dollar side.                   |
| [Margin Erosion Alerts](/nerve-centre/kpi-cards/oracle-erp/margin-erosion-alerts) | High-return SKUs erode margin. |

## Reconciling against the vendor's own dashboard

**Where to look in Oracle ERP Cloud:**

> **Order Management → Manage Orders** filter type RMA
> **OTBI → Order Management Real Time**

**Why our number may legitimately differ:**

| Reason               | Direction | Why                      |
| -------------------- | --------- | ------------------------ |
| **RMA vs cancelled** | Either    | Card excludes cancelled. |

**Cross-connector reconciliation:**

| Card                  | Notes                       |
| --------------------- | --------------------------- |
| Commerce return cards | Numerator on commerce side. |

## Known limitations / merchant FAQs

**Healthy return rate?**
Apparel 15-30%, electronics 8-15%, B2B distribution 1-5%, grocery \<1%.

**Includes warranty returns?**
Configurable. Default includes; tag warranty separately for cleaner trend.

**Multi-BU?**
Yes.

***

### Tracked live in Vortex IQ Nerve Centre

*Returns Count* 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.
