> ## 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.
# Oracle ERP Cloud (Fusion) on Vortex IQ
> Monitor Oracle ERP Cloud (Fusion) performance signals, run automated checks, and prepare approved work through Vortex IQ.
Monitor Oracle ERP Cloud (Fusion) performance signals, run automated checks, and prepare approved work through Vortex IQ.
[Connect or manage this source](https://app.vortexiq.ai/workbench/settings/sources) · [How connecting works](/integrations/connector-catalogue) · [Create a workflow](https://app.vortexiq.ai/workbench/flows/create?connector=oracle-erp)
performance signals
automated checks
prepared fixes
proven workflows
API operations
### What you can achieve
Capabilities are grouped around merchant outcomes, not API terminology.
Find failures, leaks and risks before they cost sales.
Monitor orders, fulfilment, delivery and settlement.
Keep tracking, access and change under governed control.
Improve discovery, conversion, campaigns and repeat purchase.
Find storefront, speed, accessibility and journey problems.
### From connection to verified outcome
The controlled sequence every capability follows. Nothing changes a connected system without the approval step.
Authorise the source. Scopes are shown before access is granted.
Watch the signals against your own baselines, not universal defaults.
Run checks and gather evidence specific to your store.
Explain what happened, why it matters and the proposed action.
You review scope, risk and reversibility before anything changes.
Apply through governed connector operations.
Confirm the intended result and keep the receipt.
No changes are made without the configured approval policy. Read-only operations do not modify the connected system; schedules, access scopes, API usage and data handling remain governed by Vortex IQ controls.
### Monitor performance
89 performance signals. Open an outcome to see its signals and how each one alerts. Read-only operations do not modify the connected system.
| Signal | Alert behaviour | What it tracks |
| ----------------------------------------------- | -------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **A/R Aging Detail** | Alert band 5 / 25 | A/R Aging Detail from Oracle ERP Cloud (Fusion), grouped under AP/AR Cycle. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; reconc |
| **AP Aging , 60+ Days** | Alert band 10 / 30 | Description pending editorial review; the signal is live. |
| **AR Aging Buckets** | Watch only | AR Aging Buckets, compared across items. |
| **AR Aging , 60+ Days** | Alert band 5 / 15 | Description pending editorial review; the signal is live. |
| **AR Balance (live, by Business Unit)** | Watch only | Description pending editorial review; the signal is live. |
| **Accrual Reversals (last close)** | Merchant rule | Description pending editorial review; the signal is live. |
| **Active Customers** | Watch only | Active Customers from Oracle ERP Cloud (Fusion), grouped under Customer Master. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; re |
| **Active Suppliers** | Watch only | Description pending editorial review; the signal is live. |
| **Average Landed Cost per Unit** | Alert band 0 / 10 | Average Landed Cost per Unit from Oracle ERP Cloud (Fusion), grouped under Margin & Cost. Computes when a live Oracle ERP Cloud (Fusion) tenant is con |
| **Average Sales Order Value** | Alert band 0 / -5 | Average Sales Order Value from Oracle ERP Cloud (Fusion), grouped under Sales Orders. Computes when a live Oracle ERP Cloud (Fusion) tenant is connect |
| **B2B Payment Terms Mix** | Watch only | B2B Payment Terms Mix from Oracle ERP Cloud (Fusion), grouped under AP/AR Cycle. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; r |
| **Business Unit Health Roll-up** | Watch only | Business Unit Health Roll-up from Oracle ERP Cloud (Fusion), grouped under Executive Overview. Computes when a live Oracle ERP Cloud (Fusion) tenant i |
| **Cash Application Rate** | Alert band 95 / 85 | Cash Application Rate from Oracle ERP Cloud (Fusion), grouped under AP/AR Cycle. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; r |
| **Cash Applied Today** | Watch only | Cash Applied Today from Oracle ERP Cloud (Fusion), grouped under Executive Overview. Computes when a live Oracle ERP Cloud (Fusion) tenant is connecte |
| **Credit Hold Spike** | Watch only | Credit Hold Spike from Oracle ERP Cloud (Fusion), grouped under AP/AR Cycle. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; recon |
| **Customer Churn Signals** | Watch only | Customer Churn Signals from Oracle ERP Cloud (Fusion), grouped under Customer Master. Computes when a live Oracle ERP Cloud (Fusion) tenant is connect |
| **Customer Credit Utilisation** | Alert band 60 / 85 | Customer Credit Utilisation from Oracle ERP Cloud (Fusion), grouped under AP/AR Cycle. Computes when a live Oracle ERP Cloud (Fusion) tenant is connec |
| **DSO Increase Alert** | Watch only | DSO Increase Alert from Oracle ERP Cloud (Fusion), grouped under AP/AR Cycle. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; reco |
| **Days Sales Outstanding (DSO)** | Alert band 30 / 60 | Description pending editorial review; the signal is live. |
| **Dead Stock Threshold Breach** | Watch only | Dead Stock Threshold Breach from Oracle ERP Cloud (Fusion), grouped under Inventory. Computes when a live Oracle ERP Cloud (Fusion) tenant is connecte |
| **Dead Stock Value** | Alert band 5 / 15 | Dead Stock Value from Oracle ERP Cloud (Fusion), grouped under Inventory. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; reconcil |
| **ERP-vs-Ecom Inventory Variance %** | Alert band 1 / 5 | Description pending editorial review; the signal is live. |
| **Ecom Customers Absent from Fusion Party** | Alert band 0 / 10 | Description pending editorial review; the signal is live. |
| **FX Currency Exposure** | Alert band 5 / 15 | FX Currency Exposure from Oracle ERP Cloud (Fusion), grouped under Executive Overview. Computes when a live Oracle ERP Cloud (Fusion) tenant is connec |
| **GL Period Close Past Deadline** | Alert band 0 / 5 | Alerts for GL Period Close Past Deadline. |
| **GL Period Close Status** | Alert band 0 / 5 | Description pending editorial review; the signal is live. |
| **Gross Margin Percentage** | Watch only | Gross Margin Percentage from Oracle ERP Cloud (Fusion), grouped under Margin & Cost. Computes when a live Oracle ERP Cloud (Fusion) tenant is connecte |
| **High-Value Overdue Invoices** | Watch only | High-Value Overdue Invoices from Oracle ERP Cloud (Fusion), grouped under AP/AR Cycle. Computes when a live Oracle ERP Cloud (Fusion) tenant is connec |
| **Intercompany Balance** | Watch only | Intercompany Balance from Oracle ERP Cloud (Fusion), grouped under Multi-Entity. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; r |
| **Intercompany Business Unit Imbalances** | Merchant rule | Cross-Business-Unit journals failing intercompany balance check. Blocks Cloud EPM consolidation. |
| **Inventory Aging** | Alert band 5 / 15 | Inventory Aging from Oracle ERP Cloud (Fusion), grouped under Inventory. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; reconcile |
| **Inventory AvailableQuantity Went Negative** | Merchant rule | Alerts for Inventory AvailableQuantity Went Negative. |
| **Inventory Carrying Cost** | Watch only | Inventory Carrying Cost from Oracle ERP Cloud (Fusion), grouped under Margin & Cost. Computes when a live Oracle ERP Cloud (Fusion) tenant is connecte |
| **Inventory Turnover Ratio** | Alert band 4 / 2 | Inventory Turnover Ratio from Oracle ERP Cloud (Fusion), grouped under Inventory. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; |
| **Inventory Value by Inventory Org** | Watch only | Inventory Value by Inventory Org. |
| **Journals by Source (JeSource)** | Watch only | Manual / Receivables / Payables / Inventory / Spreadsheet split. Receivables spike from ecom integration = good; Manual spike = controls gap. |
| **Landed Cost Variance vs Standard** | Alert band 2 / 5 | Landed Cost Variance vs Standard from Oracle ERP Cloud (Fusion), grouped under Margin & Cost. Computes when a live Oracle ERP Cloud (Fusion) tenant is |
| **Manual JEs as % of Total** | Merchant rule | Description pending editorial review; the signal is live. |
| **Margin Compression** | Watch only | Margin Compression from Oracle ERP Cloud (Fusion), grouped under Margin & Cost. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; re |
| **Margin Erosion Alerts** | Watch only | Margin Erosion Alerts from Oracle ERP Cloud (Fusion), grouped under Margin & Cost. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; |
| **Margin by SKU** | Watch only | Margin by SKU from Oracle ERP Cloud (Fusion), grouped under Margin & Cost. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; reconci |
| **New Party Records (30d)** | Watch only | Description pending editorial review; the signal is live. |
| **OIC Integration Flow Failures (24h)** | Merchant rule | Oracle Integration Cloud flows that mediate ecom→Fusion. Spike = trigger source down OR Fusion endpoint changed. |
| **On-Hand Inventory Value (by Inventory Org)** | Watch only | Description pending editorial review; the signal is live. |
| **Open (Unposted) Journals** | Alert band 0 / 50 | Description pending editorial review; the signal is live. |
| **Open Sales Order Value** | Watch only | Open Sales Order Value from Oracle ERP Cloud (Fusion), grouped under Sales Orders. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; |
| **Open Sales Orders** | Watch only | Open Sales Orders from Oracle ERP Cloud (Fusion), grouped under Sales Orders. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; reco |
| **Oracle Fusion Health Score** | Merchant rule | Composite: subledger-gl-posting-clean x intercompany-balanced x OIC-flows-healthy x AR-aging-low. |
| **Orders on Credit Hold** | Watch only | Orders on Credit Hold from Oracle ERP Cloud (Fusion), grouped under AP/AR Cycle. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; r |
| **Overdue Invoice Value** | Alert band 0 / 50000 | Overdue Invoice Value from Oracle ERP Cloud (Fusion), grouped under AP/AR Cycle. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; r |
| **Period Close On-Time Rate (12mo)** | Merchant rule | Description pending editorial review; the signal is live. |
| **Returns Count** | Alert band 5 / 20 | Returns Count from Oracle ERP Cloud (Fusion), grouped under Sales Orders. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; reconcil |
| **Sales Order State Breakdown** | Watch only | Sales Order State Breakdown from Oracle ERP Cloud (Fusion), grouped under Sales Orders. Computes when a live Oracle ERP Cloud (Fusion) tenant is conne |
| **Sales Order to Invoice Lead Time** | Alert band 3 / 7 | Sales Order to Invoice Lead Time from Oracle ERP Cloud (Fusion), grouped under Sales Orders. Computes when a live Oracle ERP Cloud (Fusion) tenant is |
| **Sales Orders Blocked on Inventory or Credit** | Alert band 0 / 5 | Sales Orders Blocked on Inventory or Credit from Oracle ERP Cloud (Fusion), grouped under Inventory. Computes when a live Oracle ERP Cloud (Fusion) te |
| **Slow-Moving Items (>90d no movement)** | Merchant rule | Description pending editorial review; the signal is live. |
| **Top Findings Across Business Units** | Watch only | Top Findings Across Business Units from Oracle ERP Cloud (Fusion), grouped under Multi-Entity. Computes when a live Oracle ERP Cloud (Fusion) tenant i |
| **Top SKUs by Inventory Value** | Watch only | Top SKUs by Inventory Value from Oracle ERP Cloud (Fusion), grouped under Inventory. Computes when a live Oracle ERP Cloud (Fusion) tenant is connecte |
| **Total COGS** | Watch only | Total COGS from Oracle ERP Cloud (Fusion), grouped under Margin & Cost. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; reconciles |
| **Unpaid Invoice Count** | Watch only | Unpaid Invoice Count from Oracle ERP Cloud (Fusion), grouped under AP/AR Cycle. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; re |
| **Vendor Payment On-Time Rate** | Merchant rule | Description pending editorial review; the signal is live. |
| Signal | Alert behaviour | What it tracks |
| --------------------------------------------------------------- | ----------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **AR Aging on Customers with Active Ecom Orders** | Alert band 1000 / 10000 | Fusion Credit Management should auto-classify these as high-risk via Credit Authorization rules. |
| **Commerce Orders Without Oracle ERP Cloud Sales Order** | Watch only | Commerce Orders Without Oracle ERP Cloud Sales Order from Oracle ERP Cloud (Fusion), grouped under Cross-Channel: Revenue at Risk. Computes when a liv |
| **Customers with TaxRegistrationNumber Mismatch (B2B)** | Merchant rule | B2B customers where ecom-stored VAT/Tax ID differs from Fusion Party , reverse-charge accounting risk. |
| **Dead Stock with Active Ad Spend** | Watch only | Dead Stock with Active Ad Spend from Oracle ERP Cloud (Fusion), grouped under Cross-Channel: Revenue at Risk. Computes when a live Oracle ERP Cloud (F |
| **Ecom Orders Missing Matching Fusion Receivables Transaction** | Merchant rule | Common cause: OIC flow that posts Receivables Transactions failed silently. SOX-audit gap on top of the missed revenue. |
| **High-Credit-Risk Customers** | Merchant rule | Customers classified as high-risk in Fusion Credit Management. Spike = collections / underwriting tightening needed. |
| **Inventory Sync Drift** | Watch only | Inventory Sync Drift from Oracle ERP Cloud (Fusion), grouped under Cross-Channel: Revenue at Risk. Computes when a live Oracle ERP Cloud (Fusion) tena |
| **Low Stock Alerts** | Watch only | Low Stock Alerts from Oracle ERP Cloud (Fusion), grouped under Inventory. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; reconcil |
| **OOS with Open Sales Order Demand** | Watch only | OOS with Open Sales Order Demand from Oracle ERP Cloud (Fusion), grouped under Cross-Channel: Revenue at Risk. Computes when a live Oracle ERP Cloud ( |
| **Revenue Gap** | Watch only | Revenue Gap from Oracle ERP Cloud (Fusion), grouped under Cross-Channel: Revenue at Risk. Computes when a live Oracle ERP Cloud (Fusion) tenant is con |
| **SKUs with Fusion-vs-Ecom Inventory Drift >5%** | Alert band 1 / 5 | SKUs with Fusion-vs-Ecom Inventory Drift >5%, broken down by row. |
| **Subledger-to-GL Posting Failed (any source)** | Alert band 0 / 5 | Fusion's strict GL validation rejects on COA segment issues. Blocks Receivables from flowing to GL. |
| **Subledger-to-GL Posting Interface Errors (24h)** | Merchant rule | Fusion-specific: Receivables / Payables / Inventory subledger transactions failed to post to GL. Often dimension validation fail. |
| Signal | Alert behaviour | What it tracks |
| ------------------------------- | ------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Cash Collected** | Alert band 0 / -15 | Cash Collected from Oracle ERP Cloud (Fusion), grouped under Revenue & Sales. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; reco |
| **Consolidated Revenue Trend** | Watch only | Consolidated Revenue Trend from Oracle ERP Cloud (Fusion), grouped under Revenue & Sales. Computes when a live Oracle ERP Cloud (Fusion) tenant is con |
| **Credit Memo Value** | Watch only | Credit Memo Value from Oracle ERP Cloud (Fusion), grouped under Revenue & Sales. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; r |
| **Invoiced Revenue** | Alert band 0 / -5 | Invoiced Revenue from Oracle ERP Cloud (Fusion), grouped under Revenue & Sales. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; re |
| **Revenue Booked Over Time** | Watch only | Revenue Booked Over Time from Oracle ERP Cloud (Fusion), grouped under Revenue & Sales. Computes when a live Oracle ERP Cloud (Fusion) tenant is conne |
| **Revenue Booked into GL** | Watch only | Revenue Booked into GL from Oracle ERP Cloud (Fusion), grouped under Revenue & Sales. Computes when a live Oracle ERP Cloud (Fusion) tenant is connect |
| **Revenue Gap Spike** | Watch only | Revenue Gap Spike from Oracle ERP Cloud (Fusion), grouped under Revenue & Sales. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; r |
| **Revenue Gap vs Commerce** | Alert band 0 / 5 | Revenue Gap vs Commerce from Oracle ERP Cloud (Fusion), grouped under Revenue & Sales. Computes when a live Oracle ERP Cloud (Fusion) tenant is connec |
| **Revenue by Business Unit** | Watch only | Revenue by Business Unit from Oracle ERP Cloud (Fusion), grouped under Revenue & Sales. Computes when a live Oracle ERP Cloud (Fusion) tenant is conne |
| **Revenue by Currency** | Watch only | Revenue by Currency from Oracle ERP Cloud (Fusion), grouped under Revenue & Sales. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; |
| **Revenue by Segment** | Watch only | Revenue by Segment from Oracle ERP Cloud (Fusion), grouped under Revenue & Sales. Computes when a live Oracle ERP Cloud (Fusion) tenant is connected; |
| **Top B2B Accounts by Revenue** | Watch only | Top B2B Accounts by Revenue from Oracle ERP Cloud (Fusion), grouped under Revenue & Sales. Computes when a live Oracle ERP Cloud (Fusion) tenant is co |
| **Top Customers by Revenue** | Watch only | Top Customers by Revenue from Oracle ERP Cloud (Fusion), grouped under Revenue & Sales. Computes when a live Oracle ERP Cloud (Fusion) tenant is conne |
| Signal | Alert behaviour | What it tracks |
| ------------------------------------ | ---------------- | ------------------------------------------------------------------------------------------------------------------------------- |
| **Journals in Error (PostedFlag=E)** | Alert band 0 / 5 | Fusion rejects on account combination invalid, segment value disabled, or balance mismatch. Common after COA segment additions. |
| Signal | Alert behaviour | What it tracks |
| ----------------------------- | --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **Business Unit Performance** | Watch only | Business Unit Performance from Oracle ERP Cloud (Fusion), grouped under Executive Overview. Computes when a live Oracle ERP Cloud (Fusion) tenant is c |
### Audit risks and opportunities
A fix status appears only where the action, inputs, approval, verification and recovery controls are mapped. Candidate remediations are never executable. Open a check for the detail.
**Severity** critical · **Outcome** Protect revenue · **Fix status** Report only
An entry where debits and credits do not match cannot post to a correct ledger; if it exists at all, it means something upstream (an import, an integration, a manual entry) produced a genuinely broken transaction that accounting will have to find and fix by hand before the books balance.
Vortex IQ detects and explains this; resolution is manual, with evidence and recommended steps.
Reference: `ERP-GL-002`
**Severity** high · **Outcome** Run operations · **Fix status** Report only
More than 15% of receivables are sitting in the 60+ day bucket. The longer an invoice goes unpaid, the less likely it is ever collected in full, so this is not just a cash-flow timing issue, a growing 60+ day bucket is a leading indicator of bad debt building up.
Vortex IQ detects and explains this; resolution is manual, with evidence and recommended steps.
Reference: `ERP-FIN-001`
**Severity** high · **Outcome** Protect revenue · **Fix status** Candidate remediation
Stock levels disagree between the ERP and the storefront by more than 5% on SKUs that currently have active orders. That gap risks selling inventory that is not really there (an oversell) or holding stock back that is actually available, on exactly the products customers are ordering right now.
A likely corrective operation exists, but its mapping and recovery are not yet complete, so execution is not offered. Evidence and recommended manual steps are provided.
Reference: `ERP-INV-001`
**Severity** high · **Outcome** Run operations · **Fix status** Report only
The accounting period is more than 5 days past its close deadline and still open. Every day it stays open is another day transactions can still be edited or added to a period that reporting, tax filing and any lender or investor reporting expects to be final.
Vortex IQ detects and explains this; resolution is manual, with evidence and recommended steps.
Reference: `ERP-CLOSE-001`
**Severity** high · **Outcome** Run operations · **Fix status** Report only
More than 50 journal entries are sitting unposted. Every report pulled from the general ledger while this backlog exists, profitability, cash position, tax figures, is working from incomplete books, and the larger the backlog grows the harder it gets to reconcile at period close.
Vortex IQ detects and explains this; resolution is manual, with evidence and recommended steps.
Reference: `ERP-GL-001`
**Severity** medium · **Outcome** Run operations · **Fix status** Candidate remediation
Customers who ordered over a week ago still are not in the ERP's customer master. Anything downstream that depends on that record, invoicing, tax reporting, credit terms, customer-level reporting, is working with an incomplete customer base until this syncs.
A likely corrective operation exists, but its mapping and recovery are not yet complete, so execution is not offered. Evidence and recommended manual steps are provided.
Reference: `ERP-CUST-001`
#### Build your own automated fixes
Turn any finding into an automated fix with a Vortex IQ workflow: **over 13,000 read and write operations across more than 200 connectors** are available as building blocks, with approval, verification and rollback on every change.
### Automate approved work
Vortex IQ is integrated with **4 read** and **1 write** operations across fscmrestapiresourcecustomersv2s, fscmrestapiresourceitemsv2s, fscmrestapiresourcejournals, fscmrestapiresourcesuppliers, oauth2tokens on Oracle ERP Cloud (Fusion). Combine them with anything from the **over 13,000 operations across more than 200 connectors** to automate the work in your own words.
Changes follow your configured approval policy: the target, proposed change, affected records, risk, reversibility and verification plan are shown before execution.
[Create a workflow](https://app.vortexiq.ai/workbench/flows/create?connector=oracle-erp)
#### Ready to build your first Oracle ERP Cloud (Fusion) workflow
Pick a trigger, add the operations above as steps, and every step that changes data pauses for your approval. Monitoring and audits are live now and can start any workflow you build.
| Resource | Read operations | Write operations |
| ------------------------------- | --------------- | ---------------- |
| fscmrestapiresourcecustomersv2s | 1 | 0 |
| fscmrestapiresourceitemsv2s | 1 | 0 |
| fscmrestapiresourcejournals | 1 | 0 |
| fscmrestapiresourcesuppliers | 1 | 0 |
| oauth2tokens | 0 | 1 |
Signed-in users see the full catalogue in the workflow builder, filtered to the sources they have connected.