All connectors
Implemented
ERP & business operations
Oracle Fusion Cloud ERP logo

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 account
    Destination
    Not retried automatically
    Approval before production

    Creates a trading community organization account; a source-system reference keeps it linked to your system.

    customer_accounts.create
  • Get customer account
    Source

    Reads one Oracle Fusion customer account.

    customer_accounts.get
  • List customer accounts
    Source
    Incremental

    Lists Oracle Fusion customer accounts, oldest change first, optionally changed since a timestamp.

    customer_accounts.list
  • Update customer account
    Destination
    Provider duplicate protection
    Approval before production

    Updates an account identified by its party number.

    customer_accounts.update
draft purchase orders
  • Create draft purchase order
    Destination
    Not retried automatically
    Approval before production

    Creates a draft purchase order (not submitted for approval) with optional lines.

    draft_purchase_orders.create
invoice installments
  • List invoice installments
    Source

    Lists the invoice installments of an Oracle Fusion payables invoice.

    invoice_installments.list
invoice lines
  • List invoice lines
    Source

    Lists the invoice lines of an Oracle Fusion payables invoice.

    invoice_lines.list
invoices
  • Create payables invoice
    Destination
    Provider duplicate protection
    Approval before production

    Creates a supplier (payables) invoice with optional lines. Oracle rejects a repeated invoice number for the same supplier.

    invoices.create
  • Get payables invoice
    Source

    Reads one Oracle Fusion payables invoice with invoiceLines,invoiceInstallments.

    invoices.get
  • List payables invoices
    Source
    Incremental

    Lists Oracle Fusion payables invoices, oldest change first, optionally changed since a timestamp.

    invoices.list
  • Update payables invoice
    Destination
    Provider duplicate protection
    Approval before production

    Updates header attributes of an unvalidated payables invoice.

    invoices.update
items
  • Create item
    Destination
    Provider duplicate protection
    Approval before production

    Creates an item in an item organization.

    items.create
  • Get item
    Source

    Reads one Oracle Fusion item.

    items.get
  • List items
    Source
    Incremental

    Lists Oracle Fusion items, oldest change first, optionally changed since a timestamp.

    items.list
journal batches
  • Get journal batch
    Source

    Reads one Oracle Fusion journal batch.

    journal_batches.get
  • List journal batchs
    Source
    Incremental

    Lists Oracle Fusion journal batchs, oldest change first, optionally changed since a timestamp.

    journal_batches.list
journal headers
  • List journals
    Source

    Lists the journals of an Oracle Fusion journal batch.

    journal_headers.list
journal lines
  • List journal lines
    Source

    Lists the journal lines of an Oracle Fusion journal batch.

    journal_lines.list
ledger balances
  • Search general ledger balances
    Source

    Reads general ledger balances with the AccountBalanceFinder (account combination, period, currency and ledger).

    ledger_balances.search
purchase order lines
  • List purchase order lines
    Source

    Lists the purchase order lines of an Oracle Fusion purchase order.

    purchase_order_lines.list
purchase orders
  • Get purchase order
    Source

    Reads one Oracle Fusion purchase order with lines.

    purchase_orders.get
  • List purchase orders
    Source
    Incremental

    Lists Oracle Fusion purchase orders, oldest change first, optionally changed since a timestamp.

    purchase_orders.list
receivables invoice lines
  • List receivables invoice lines
    Source

    Lists the receivables invoice lines of an Oracle Fusion receivables invoice.

    receivables_invoice_lines.list
receivables invoices
  • Create receivables invoice
    Destination
    Not retried automatically
    Approval before production

    Creates a customer (receivables) invoice with lines.

    receivables_invoices.create
  • Get receivables invoice
    Source

    Reads one Oracle Fusion receivables invoice with receivablesInvoiceLines,receivablesInvoiceInstallments.

    receivables_invoices.get
  • List receivables invoices
    Source
    Incremental

    Lists Oracle Fusion receivables invoices, oldest change first, optionally changed since a timestamp.

    receivables_invoices.list
supplier sites
  • List supplier sites
    Source

    Lists the supplier sites of an Oracle Fusion supplier.

    supplier_sites.list
suppliers
  • Create supplier
    Destination
    Not retried automatically
    Approval before production

    Creates a supplier (sites, contacts and bank accounts are managed in Oracle).

    suppliers.create
  • Get supplier
    Source

    Reads one Oracle Fusion supplier.

    suppliers.get
  • List suppliers
    Source
    Incremental

    Lists Oracle Fusion suppliers, oldest change first, optionally changed since a timestamp.

    suppliers.list
  • Update supplier
    Destination
    Provider duplicate protection
    Approval 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

  1. Create the Oracle credentials described above with the narrowest permissions your flows need.
  2. 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
  3. 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.