Commerce orders that never created a Oracle ERP Cloud Sales Order. Each row is a revenue-leak investigation.
At a glance
Commerce-platform orders that have not produced a corresponding Oracle ERP Cloud Sales Order. Each row is a potential revenue-leak investigation. The Unmapped Customer subset of the revenue gap breakdown, promoted to its own card because it is the most actionable bucket.
| What it counts | Commerce orders in the window where the integration did not produce an Oracle Sales Order, broken down by failure reason: Unmapped Customer (most common), Unmapped Item, Tax Calculation Failed, Pricing Lookup Failed, Currency Mapping Missing, Other Validation Error. |
| Tax treatment | n/a (integration-error universe). |
| Currency | Order amount in transaction currency. |
| Time window | Real-time snapshot. |
| Alert trigger | >0 unmapped orders (every unmapped order is real revenue at risk) |
| 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 industrial distributor on Oracle ERP Cloud with Salesforce Commerce Cloud B2B and Adobe Commerce. Snapshot 14 Apr 26.| Failure reason | Order count | Total $ at risk |
|---|---|---|
| Unmapped Customer | 22 | $384,000 |
| Unmapped Item | 14 | $128,400 |
| Tax Calculation Failed | 8 | $48,200 |
| Pricing Lookup Failed | 6 | $24,800 |
| Currency Mapping Missing | 2 | $14,200 |
| Other Validation Error | 4 | $18,400 |
| Total Unmapped | 56 | $618,000 |
- 22 Unmapped Customer rows = $384K stuck. Top priority: send the Customer Hub team the customer-key list. Each customer is a 1 to 3 day mapping job; if the team has bandwidth they could clear all 22 in 5 to 10 working days.
- 14 Unmapped Item rows. A new product line launched on Adobe Commerce was not yet synced into Oracle Item Master. Operations needs to set up the items in Oracle (cost, lead time, BU assignment) before the SO can import.
- Tax Calculation Failed (8 orders). The E-Business Tax engine could not find a rule for the customer’s shipping jurisdiction. Often a new state / country where the merchant has not yet registered. Either suspend new orders to that jurisdiction or update the tax registration + rule set.
- Pricing Lookup Failed (6 orders). Custom contract pricing on the customer’s account expired or has not been renewed. Pricing Operations to renew the contract.
- **The 618K per snapshot translates to $1M+ per quarter if unaddressed.
Sibling cards merchants should reference together
| Card | Why pair it with Commerce Orders Without Oracle SO |
|---|---|
| Revenue Gap vs Commerce | This card is the Unmapped Customer / Unmapped Item subset. |
| Revenue Gap, Detailed Breakdown | Per-row drill-down across all gap reasons. |
| Open Sales Order Value | The forward book that this card threatens to undermine. |
| Commerce-platform total order count cards | The numerator of the gap. |
Reconciling against the vendor’s own dashboard
Where to look in Oracle ERP Cloud:Order Management → Process Order Import (failed-import log) Oracle Integration Cloud (OIC) → Monitoring → Failed Instances (if OIC orchestrates the inbound) OTBI → Order Management Real Time with custom filter on Order Source = the connected commerce platform AND Status = ‘Error’The Process Order Import error log shows each failed inbound, but stops at “what failed in Oracle”. This card adds “what was the originating commerce order” so the merchant can act. Why our number may legitimately differ:
| Reason | Direction | Why |
|---|---|---|
| Retry queue cadence | Either | OIC retries failures on a configurable schedule. Card snapshot may include items currently being retried. |
| Test order exclusion | Either | Configurable; default excludes commerce-platform test flag. |
| Card | Direction | Notes |
|---|---|---|
| Commerce-platform order count | Numerator | Card is the integration-failure subset. |
| Revenue Gap, Detailed Breakdown | Same | Drill-down for context. |