
Oracle Fusion Cloud ERP
Payables and receivables invoices, suppliers, purchase orders, journals, ledger balances, items and customer accounts through the Fusion REST APIs.
Synchronise procure-to-pay, order-to-cash and general ledger data between Oracle Fusion and operational systems.
Source actions
22
Destination actions
9
Data types
16
Validation status
Implemented · fixture tested.
Implementation is checked against provider-shaped fixtures for every action, authentication failures, rate limits, pagination and duplicate safety. Provider sandbox and authorised account validation are recorded separately when credential-backed runs are completed.
What you can map
customer accounts
- Create customer accountDestinationNot retried automaticallyApproval before production
Creates a trading community organization account; a source-system reference keeps it linked to your system.
customer_accounts.create - Get customer accountSource
Reads one Oracle Fusion customer account.
customer_accounts.get - List customer accountsSourceIncremental
Lists Oracle Fusion customer accounts, oldest change first, optionally changed since a timestamp.
customer_accounts.list - Update customer accountDestinationProvider duplicate protectionApproval before production
Updates an account identified by its party number.
customer_accounts.update
draft purchase orders
- Create draft purchase orderDestinationNot retried automaticallyApproval before production
Creates a draft purchase order (not submitted for approval) with optional lines.
draft_purchase_orders.create
invoice installments
- List invoice installmentsSource
Lists the invoice installments of an Oracle Fusion payables invoice.
invoice_installments.list
invoice lines
- List invoice linesSource
Lists the invoice lines of an Oracle Fusion payables invoice.
invoice_lines.list
invoices
- Create payables invoiceDestinationProvider duplicate protectionApproval before production
Creates a supplier (payables) invoice with optional lines. Oracle rejects a repeated invoice number for the same supplier.
invoices.create - Get payables invoiceSource
Reads one Oracle Fusion payables invoice with invoiceLines,invoiceInstallments.
invoices.get - List payables invoicesSourceIncremental
Lists Oracle Fusion payables invoices, oldest change first, optionally changed since a timestamp.
invoices.list - Update payables invoiceDestinationProvider duplicate protectionApproval before production
Updates header attributes of an unvalidated payables invoice.
invoices.update
items
- Create itemDestinationProvider duplicate protectionApproval before production
Creates an item in an item organization.
items.create - Get itemSource
Reads one Oracle Fusion item.
items.get - List itemsSourceIncremental
Lists Oracle Fusion items, oldest change first, optionally changed since a timestamp.
items.list
journal batches
- Get journal batchSource
Reads one Oracle Fusion journal batch.
journal_batches.get - List journal batchsSourceIncremental
Lists Oracle Fusion journal batchs, oldest change first, optionally changed since a timestamp.
journal_batches.list
journal headers
- List journalsSource
Lists the journals of an Oracle Fusion journal batch.
journal_headers.list
journal lines
- List journal linesSource
Lists the journal lines of an Oracle Fusion journal batch.
journal_lines.list
ledger balances
- Search general ledger balancesSource
Reads general ledger balances with the AccountBalanceFinder (account combination, period, currency and ledger).
ledger_balances.search
purchase order lines
- List purchase order linesSource
Lists the purchase order lines of an Oracle Fusion purchase order.
purchase_order_lines.list
purchase orders
- Get purchase orderSource
Reads one Oracle Fusion purchase order with lines.
purchase_orders.get - List purchase ordersSourceIncremental
Lists Oracle Fusion purchase orders, oldest change first, optionally changed since a timestamp.
purchase_orders.list
receivables invoice lines
- List receivables invoice linesSource
Lists the receivables invoice lines of an Oracle Fusion receivables invoice.
receivables_invoice_lines.list
receivables invoices
- Create receivables invoiceDestinationNot retried automaticallyApproval before production
Creates a customer (receivables) invoice with lines.
receivables_invoices.create - Get receivables invoiceSource
Reads one Oracle Fusion receivables invoice with receivablesInvoiceLines,receivablesInvoiceInstallments.
receivables_invoices.get - List receivables invoicesSourceIncremental
Lists Oracle Fusion receivables invoices, oldest change first, optionally changed since a timestamp.
receivables_invoices.list
supplier sites
- List supplier sitesSource
Lists the supplier sites of an Oracle Fusion supplier.
supplier_sites.list
suppliers
- Create supplierDestinationNot retried automaticallyApproval before production
Creates a supplier (sites, contacts and bank accounts are managed in Oracle).
suppliers.create - Get supplierSource
Reads one Oracle Fusion supplier.
suppliers.get - List suppliersSourceIncremental
Lists Oracle Fusion suppliers, oldest change first, optionally changed since a timestamp.
suppliers.list - Update supplierDestinationProvider duplicate protectionApproval before production
Updates supplier header attributes.
suppliers.update
Authentication
Integration user (HTTPS basic authentication)
Plans and access
Oracle Fusion Cloud ERP / Financials, Procurement and SCM subscriptions. Access follows the integration user's job and data roles (business unit and ledger data access sets).
Test environment
Use a Fusion test (non-production) pod provisioned with your subscription.
Rate limits
Oracle applies pod-level throttling and returns HTTP 429 or 503 under load; page sizes are capped at 500 records.
Pagination
offset/limit with hasMore, ordered by LastUpdateDate and the primary key.
Provider events
Oracle Integration Cloud business events (separate subscription). Nexra event triggers are not yet available; flows run on demand or on a schedule.
Before you build a flow
- Basic authentication only; OAuth through Oracle Identity Cloud Service (JWT assertion) is not implemented.
- Requests pin REST-Framework-Version 2 so filters use rowmatch expressions (Field = 'value' and LastUpdateDate >= 'timestamp').
- Invoice validation, approval, cancellation, payments and purchase order submission are not implemented; purchase orders are created as drafts.
- Journal batches, journal headers, journal lines and ledger balances are read only.
- Item reads by key use the composite resource key (resourceKey) returned by the items list.
- Child line and installment field names follow the published resource schemas; descriptive flexfields are not mapped.
- Receivables invoice creation has no idempotency key; uncertain creates are not repeated automatically.
Developer reference
- Create the Oracle credentials described above with the narrowest permissions your flows need.
- In Nexra, open Connect, then Connections, then New connection, choose Oracle Fusion Cloud ERP, enter its settings and credentials, and tick only the write actions you need. Connection guide
- Test the connection, then use its actions as flow sources and destinations. Flow guide
Machine-readable detail: GET /api/public/connect/connectors/oracle-fusion-cloud-erp and the Connections API.