Skip to main content
Metrics type: Cross-Platform Metrics • Category: Ecommerce Platform
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.

​
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. Five things to notice:
  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. **The 618Kisrealrevenueatrisk.∗∗Withoutintervention,theseorderswillnotbecomeOracleSOs,willnotAutoInvoice,willnotbecomeGLrevenue,andmayeventuallyexpirefromtheintegration′sretryqueue.AtFortune500scale,618K is real revenue at risk.** Without intervention, these orders will not become Oracle SOs, will not AutoInvoice, will not become GL revenue, and may eventually expire from the integration's retry queue. At Fortune 500 scale, 618K per snapshot translates to $1M+ per quarter if unaddressed.

​
Sibling cards merchants should reference together

​
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: Cross-connector reconciliation:

​
Known limitations / merchant FAQs

Why is Unmapped Customer the most common reason? Because customer onboarding is a separate, often-manual workflow in Fortune 500 governance. Sales adds a B2B customer in the commerce platform; the Customer Hub team has to mirror that customer in Oracle (with required-field validation, credit-limit setup, terms assignment). The lag is structural. Can the integration auto-create customers? Yes if configured, but most Fortune 500 implementations deliberately disable auto-create for governance reasons. Customer master data is a controlled object in finance. Unmapped Item, when does this happen? New product launches that were created in commerce but not yet in Oracle Item Master. Reverse direction is rare (Oracle Item Master is usually source of truth). Tax Calculation Failed, what to do? Either update the E-Business Tax rule set to cover the new jurisdiction, or block customers from new jurisdictions until tax registration is complete. Working with legal / tax counsel. OIC vs Vortex IQ for resolving these? OIC orchestrates the integration and exposes raw error logs. Vortex IQ reads both sides (commerce + Oracle) and surfaces in Controller-readable language with action owners. Complementary. How does this differ from Oracle’s own failed-import log? Oracle’s log shows the failure event; this card shows the business impact (which customer, which order, what dollar amount). Same facts, different framing.

​
Tracked live in Vortex IQ Nerve Centre

Commerce Orders Without Oracle ERP Cloud Sales Order 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.