Oracle Fusion Cloud ERP
Keep Oracle Fusion Cloud ERP in step with your orders, stock and finance, with the right person approving every posting.
43 ways to read, 12 ways to write, each write switched on by you.
Quality checks
Built and tested with example responses.
- Ready to connect: doneEvery listed action is built in.
- Built and tested with example responses: doneEach action is built from the provider’s published API and tested against example responses, errors, rate limits and paging.
Connected, approved, proven.
The things teams do most with Oracle Fusion Cloud ERP, an example flow with a person in the loop, and what Nexra keeps as proof.
Top actions
- Create customer accountApproval by rule
- Create draft purchase orderApproval by rule
- Search general ledger balancesRead
Example flow
- Oracle Fusion Cloud ERP · Search general ledger balancesDone
- Oracle Fusion Cloud ERP · Create customer accountNeeds approval
- Nexra · Record the decision and result in the evidence chainProven
Example workflow. Routine runs go through on their own. Only a change your rules flag, such as one over a limit you set, waits for the right person, who sees the exact change and the rule before it reaches Oracle Fusion Cloud ERP.
What gets logged
- Whether it ran on its own or who approved it, and under which rule
- A fingerprint of the exact request sent to Oracle Fusion Cloud ERP
- Oracle Fusion Cloud ERP's reply: what it created or changed
- One entry in the evidence chain, linked to the one before
Try this in the sandbox
Run the whole flow with test data in your sandbox, then connect your own account when you are ready to go live.
For developers
Technical detail
Fusion REST reads across payables, payments, holds, receivables, receipts, credit memos, bank transactions, procurement, ledgers and items, with draft-only document writes.
Oracle API docs- Source actions
- 43
- Destination actions
- 12
- Data types
- 30
What you can map
Reads are always available. Writes are off until you switch them on for a connection, and governed writes follow your policies.
Bank transactions2
- Get bank transactionSource
Reads one Oracle Fusion bank transaction.
- List bank transactionsSourceIncremental
Lists Oracle Fusion bank transactions, oldest change first, optionally changed since a timestamp.
Currency rates1
- List currency ratesSource
Daily conversion rates between two currencies, optionally for one date and type.
Customer accounts4
- Create customer accountDestinationNot retried automaticallyApproval before production
Creates a trading community organization account; a source-system reference keeps it linked to your system.
- Get customer accountSource
Reads one Oracle Fusion customer account.
- List customer accountsSourceIncremental
Lists Oracle Fusion customer accounts, oldest change first, optionally changed since a timestamp.
- Update customer accountDestinationProvider duplicate protectionApproval before production
Updates an account identified by its party number.
Draft purchase orders4
- Create draft purchase orderDestinationNot retried automaticallyApproval before production
Creates a draft purchase order (not submitted for approval) with optional lines.
- Get draft purchase orderSource
Reads one Oracle Fusion draft purchase order.
- List draft purchase ordersSourceIncremental
Lists Oracle Fusion draft purchase orders, oldest change first, optionally changed since a timestamp.
- Update draft purchase orderDestinationProvider duplicate protectionApproval before production
Updates the description and notes of a draft purchase order. It is never submitted for approval or sent to the supplier.
Draft receivables invoices1
- Create incomplete receivables invoiceDestinationNot retried automaticallyApproval before production
Creates a customer invoice that is always left Incomplete, so it is not ready for posting until someone completes it in Oracle.
Invoice holds2
- Get invoice holdSource
Reads one Oracle Fusion invoice hold.
- List invoice holdsSourceIncremental
Lists Oracle Fusion invoice holds, oldest change first, optionally changed since a timestamp.
Invoice installments1
- List invoice installmentsSource
Lists the invoice installments of an Oracle Fusion payables invoice.
Invoice lines1
- List invoice linesSource
Lists the invoice lines of an Oracle Fusion payables invoice.
Invoices4
- 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.
- Get payables invoiceSource
Reads one Oracle Fusion payables invoice with invoiceLines,invoiceInstallments.
- List payables invoicesSourceIncremental
Lists Oracle Fusion payables invoices, oldest change first, optionally changed since a timestamp.
- Update payables invoiceDestinationProvider duplicate protectionApproval before production
Updates header attributes of an unvalidated payables invoice.
Items3
- Create itemDestinationProvider duplicate protectionApproval before production
Creates an item in an item organization.
- Get itemSource
Reads one Oracle Fusion item.
- List itemsSourceIncremental
Lists Oracle Fusion items, oldest change first, optionally changed since a timestamp.
Journal batches2
- Get journal batchSource
Reads one Oracle Fusion journal batch.
- List journal batchsSourceIncremental
Lists Oracle Fusion journal batchs, oldest change first, optionally changed since a timestamp.
Journal headers1
- List journalsSource
Lists the journals of an Oracle Fusion journal batch.
Journal lines1
- List journal linesSource
Lists the journal lines of an Oracle Fusion journal batch.
Ledger balances1
- Search general ledger balancesSource
Reads general ledger balances with the AccountBalanceFinder (account combination, period, currency and ledger).
Ledgers1
- List ledgersSource
Lists Oracle Fusion ledgers, oldest change first.
Payables payments2
- Get payables paymentSource
Reads one Oracle Fusion payables payment.
- List payables paymentsSourceIncremental
Lists Oracle Fusion payables payments, oldest change first, optionally changed since a timestamp.
Payment invoices1
- List paid invoicesSource
Lists the paid invoices of an Oracle Fusion payables payment.
Payment terms1
- List payables payment termsSource
Lists Oracle Fusion payables payment terms, oldest change first.
Purchase order lines1
- List purchase order linesSource
Lists the purchase order lines of an Oracle Fusion purchase order.
Purchase orders2
- Get purchase orderSource
Reads one Oracle Fusion purchase order with lines.
- List purchase ordersSourceIncremental
Lists Oracle Fusion purchase orders, oldest change first, optionally changed since a timestamp.
Purchase requisitions3
- Create draft purchase requisitionDestinationNot retried automaticallyApproval before production
Creates a requisition in Incomplete status with optional lines. It is never submitted for approval.
- Get purchase requisitionSource
Reads one Oracle Fusion purchase requisition.
- List purchase requisitionsSourceIncremental
Lists Oracle Fusion purchase requisitions, oldest change first, optionally changed since a timestamp.
Receivables credit memo lines1
- List receivables credit memo linesSource
Lists the receivables credit memo lines of an Oracle Fusion receivables credit memo.
Receivables credit memos2
- Get receivables credit memoSource
Reads one Oracle Fusion receivables credit memo.
- List receivables credit memosSourceIncremental
Lists Oracle Fusion receivables credit memos, oldest change first, optionally changed since a timestamp.
Receivables invoice lines1
- List receivables invoice linesSource
Lists the receivables invoice lines of an Oracle Fusion receivables invoice.
Receivables invoices3
- Create receivables invoiceDestinationNot retried automaticallyApproval before production
Creates a customer (receivables) invoice with lines.
- Get receivables invoiceSource
Reads one Oracle Fusion receivables invoice with receivablesInvoiceLines,receivablesInvoiceInstallments.
- List receivables invoicesSourceIncremental
Lists Oracle Fusion receivables invoices, oldest change first, optionally changed since a timestamp.
Standard receipts2
- Get standard receiptSource
Reads one Oracle Fusion standard receipt.
- List standard receiptsSourceIncremental
Lists Oracle Fusion standard receipts, oldest change first, optionally changed since a timestamp.
Supplier addresses1
- List supplier addresssSource
Lists the supplier addresss of an Oracle Fusion supplier.
Supplier contacts1
- List supplier contactsSource
Lists the supplier contacts of an Oracle Fusion supplier.
Supplier sites1
- List supplier sitesSource
Lists the supplier sites of an Oracle Fusion supplier.
Suppliers4
- Create supplierDestinationNot retried automaticallyApproval before production
Creates a supplier (sites, contacts and bank accounts are managed in Oracle).
- Get supplierSource
Reads one Oracle Fusion supplier.
- List suppliersSourceIncremental
Lists Oracle Fusion suppliers, oldest change first, optionally changed since a timestamp.
- Update supplierDestinationProvider duplicate protectionApproval before production
Updates supplier header attributes.
Access and limits
- 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). Flows run on demand, on a schedule, or when a scheduled check finds new or changed records.
Before you build a flow
- Nothing is posted, approved, paid or deleted. Payments, receipts, holds, credit memos and journals are read only.
- Filters are rowmatch expressions built only from validated, single-quoted values (embedded quotes are doubled). No email address or phone number is sent in a URL by any added operation; the requisition preparer email travels in the request body.
- Payables invoice interface (FBDI) import is not implemented; payables invoices are created through the invoices resource, which leaves them unvalidated.
- Procurement resources (draft purchase orders, requisitions, supplier addresses and contacts) follow the Procurement REST reference at https://docs.oracle.com/en/cloud/saas/procurement/25d/fapra/rest-endpoints.html.
- Currency rates have no documented sort key, so pages follow Oracle's default order.
- Basic authentication only; OAuth through Oracle Identity Cloud Service (JWT assertion) is not implemented.
- 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.
- Bank transactions: Oracle's REST API has no bank statement or statement line resource, so bank_transactions reads Cash Management external transactions (bank fees, interest, receipts and payments recorded or imported for reconciliation). Imported bank statement lines themselves are not available. The resource has no separate debit or credit field; use the transaction type to tell them apart.
- 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.