> ## 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) audit profile, Vortex IQ

> What the Vortex IQ Oracle ERP Cloud (Fusion) health audit checks: Oracle Fusion Cloud ERP: postings settle, AR is collectible, inventory reconciles

**[Nerve Centre KPIs](/nerve-centre/kpi-cards/oracle-erp) · [Audit Profile](/nerve-centre/kpi-cards/oracle-erp/audit) · [Sentiment Settings](/nerve-centre/kpi-cards/oracle-erp/sentiment)**

Oracle Fusion Cloud ERP back-office health audit. Answers four questions: (1) are journal batches posting cleanly (no stuck/unposted batches, no out-of-balance entries); (2) is AR collectible (aging, DSO, credit holds) across Business Units; (3) does Oracle Inventory on-hand reconcile with ecom availability; (4) is the period close on track for ledger consolidation. The cross-channel area joins Fusion sales orders and AR invoices to commerce-sibling orders to size unbilled revenue and credit risk.

## What this audit checks

### Authentication & access

* OAuth2 / Basic token resolves against the correct Fusion pod host
* Roles grant REST access to journalBatches, receivablesInvoices, inventoryOnhandBalances, salesOrdersForOrderHub, suppliers
* Primary + secondary Ledgers and Business Units for every active entity are configured
* REST page size + finder filters tuned to stay within Fusion throttle limits

### GL health

* Unposted journal batches below 50 (no stuck import from ecom subledger)
* Zero out-of-balance journals persisting past posting validation
* Subledger Accounting (SLA) errors cleared in the last 24h
* Manual journals under 25% of total postings (controls gap if higher)

### AP/AR cycle

* AR aging 60+ days below 15% of open receivables
* DSO under 60 days and not rising > 10 days vsP
* No single customer holding > 40% of 60+ day AR (concentration risk)
* Cash application rate at or above 95%; high-value invoices (> 50k) not overdue 60+ days

### Inventory reconciliation

* ERP-vs-ecom on-hand variance below 5% on top-50 velocity SKUs
* No item on-hand gone negative in any Inventory Organization
* Items below safety stock / reorder point flagged
* Slow-moving / dead stock under 10% of inventory value

### Period close

* GL period not past close deadline on any Ledger (> 5 days blocks consolidation)
* Zero intercompany imbalances across the Business Unit group
* Accrual reversals from the last close within expected range

### Cross-channel: revenue reconciliation

* Ecom orders with a matching Fusion Sales Order + AR Invoice of equal value within the period (sibling = shopify/bigcommerce/adobe.order)
* Ecom customers with completed orders present in the Oracle customer (TCA party) master
* AR aging on customers with active ecom orders (credit-control gap)
* Unbilled revenue forecast (commerce cleared value minus matched AR invoice value)

## Severity thresholds

| Signal                      | Warn | Critical |
| --------------------------- | ---- | -------- |
| `open_journal_count`        | 25   | 50       |
| `journal_imbalance_count`   | 1    | 5        |
| `ar_aging_60d_pct`          | 10   | 15       |
| `dso_days`                  | 45   | 60       |
| `inventory_variance_pct`    | 3    | 5        |
| `period_close_overdue_days` | 2    | 5        |
| `customer_master_drift`     | 5    | 10       |

## Data sources

* `GET https://{pod}/fscmRestApi/resources/11.13.18.05/journalBatches` - Journal batches: posting status, balance, source
* `GET https://{pod}/fscmRestApi/resources/11.13.18.05/receivablesInvoices` - AR invoices: aging, due date, paid status
* `GET https://{pod}/fscmRestApi/resources/11.13.18.05/inventoryOnhandBalances` - Inventory org on-hand vs ecom availability
* `GET https://{pod}/fscmRestApi/resources/11.13.18.05/salesOrdersForOrderHub` - Sales orders: status, hold, ecom reference
* `GET https://{pod}/fscmRestApi/resources/11.13.18.05/suppliers` - Supplier (AP) master + payment terms