Skip to main content
Nerve Centre KPIs · Audit Profile · Sentiment Settings 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

SignalWarnCritical
open_journal_count2550
journal_imbalance_count15
ar_aging_60d_pct1015
dso_days4560
inventory_variance_pct35
period_close_overdue_days25
customer_master_drift510

​
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