Oracle Fusion Cloud ERP integration
Fusion Host: your Oracle Cloud server, such as servername.fa.us2.oraclecloud.com (the host of the REST server URL in your Oracle welcome email, no path). Oracle Fusion Cloud ERP Financials REST API, release 26D. Create, validate, cancel and read supplier (payables) invoices and lines; create, read, void and stop supplier payments; create and read customer (receivables) invoices, credit memos and standard receipts; read adjustments and customer account activity; read, update and delete journal batches; read ledger balances and currency rates; and list ledgers, business units, legal entities, periods, payment terms and methods, transaction types and sources and journal sources and categories. Not covered: the other Financials resources (expenses, assets, tax setup, cash management, collections, intercompany, joint ventures, revenue, federal, bulk import and export), attachments, flexfields and child-resource expansion. Bank account, IBAN and card fields are neither returned nor accepted. Authentication is HTTP Basic with a Fusion user name and password; the user role decides what each call may do.
Say what should happen.
The workflow builds itself.
What you can do with Oracle Fusion Cloud ERP
Each of these is one operation on one endpoint, available both as a workflow step and as a tool an AI agent can call on its own. Nothing bundles several operations into one action, so what a run did stays readable afterwards.
Most endpoints run on the free plan. A few, mainly the ones that publish on your behalf, need a paid plan.
Payables invoice, 6 operations
cancel_payables_invoiceCancel payables invoicePOSTCancels a payables invoice: all its amounts are set to zero and it can no longer be edited or processed. Irreversible. Identify it with InvoiceNumber, Supplier and BusinessUnit.create_payables_invoiceCreate payables invoicePOSTCreates a supplier (payables) invoice, optionally with its lines in invoiceLines; it then needs validate_payables_invoice before payment. Returns the invoice header.delete_payables_invoiceDelete payables invoiceDELETEDeletes a payables invoice, by the key from the self link of list_payables_invoices.get_payables_invoiceGet payables invoiceGETReturns one payables invoice header by its key (the last segment of the self link that list_payables_invoices returns): amounts, dates, supplier, status, payment terms.update_payables_invoiceUpdate payables invoicePATCHChanges the attributes you send on a payables invoice. Only certain attributes can be updated, and related fields are not recomputed (changing the invoice date does not move the due date).validate_payables_invoiceValidate payables invoicePOSTValidates a payables invoice: calculates tax, checks matching tolerances and places holds for exceptions, which a payment needs first. Send ProcessAction Validate and identify it with InvoiceNumber, Supplier and BusinessUnit.
Payables payment, 4 operations
create_payables_paymentCreate payables paymentPOSTCreates a manual supplier payment (a payment already made outside Oracle, such as a typed check) for invoices in relatedInvoices. It records payment and pays the invoices; it moves no money itself.get_payables_paymentGet payables paymentGETReturns one supplier payment by CheckId: number, date, amount, currency, status, payee, method, business unit and void details. Bank account numbers are not returned.initiate_stop_paymentInitiate stop paymentPOSTInitiates a stop on a supplier payment: its status becomes stop initiated. Identify the payment with PaymentNumber, PaymentDocument, BusinessUnit and DisbursementBankAccountName.update_payables_paymentUpdate payables paymentPATCHUpdates a supplier payment by CheckId: per Oracle, used to void a payment (void date and accounting date) and to update its flexfields.
Receivables invoice, 4 operations
create_receivables_invoiceCreate receivables invoicePOSTCreates a customer (receivables) invoice with lines in receivablesInvoiceLines (its customer, transaction type and source, dates and currency) and returns it.delete_receivables_invoiceDelete receivables invoiceDELETEDeletes a receivables invoice by CustomerTransactionId.get_receivables_invoiceGet receivables invoiceGETReturns one customer (receivables) invoice by CustomerTransactionId: number, date, customer, amounts, currency, status and terms.update_receivables_invoiceUpdate receivables invoicePATCHUpdates a receivables invoice by CustomerTransactionId. Oracle's resource note says only InvoiceStatus, PaymentTerms and TransactionDate can be updated, although its update schema lists more fields.
Journal batch, 3 operations
delete_journal_batchDelete journal batchDELETEDeletes a general ledger journal batch.get_journal_batchGet journal batchGETReturns one general ledger journal batch with its status, period, source, totals, approval and posting status.update_journal_batchUpdate journal batchPATCHUpdates a journal batch: only its completion status and its reversal attributes (reverse journals, reversal date or period, method) can change.
Receivables credit memo, 2 operations
create_receivables_credit_memoCreate receivables credit memoPOSTCreates a receivables credit memo for a customer, with lines in receivablesCreditMemoLines, and returns it.get_receivables_credit_memoGet receivables credit memoGETReturns one receivables credit memo by CustomerTransactionId: number, date, customer, amounts, currency and status.
Standard receipt, 2 operations
create_standard_receiptCreate standard receiptPOSTRecords a standard receipt (a payment received from a customer) in Receivables and returns it; it can then be applied to the customer transactions.get_standard_receiptGet standard receiptGETReturns one standard receipt by StandardReceiptId: number, date, amount, currency, customer, status, method and remittance bank name.
Accounting periods, 1 operation
list_accounting_periodsList accounting periodsGETLists accounting periods of the calendars (period names, years, start and end dates), for the PeriodName and accounting dates other tools take. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Business units, 1 operation
list_business_unitsList business unitsGETLists the Financials business units (names and ids), for the BusinessUnit fields of invoices and payments. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Currency conversion types, 1 operation
list_currency_conversion_typesList currency conversion typesGETLists currency conversion rate types (Corporate, Spot, User and the ones you defined), for ConversionRateType fields. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Currency rates, 1 operation
list_currency_ratesList currency ratesGETLists daily currency rates. Use finder CurrencyRatesFinder (fromCurrency, toCurrency, a conversion type, startDate, endDate) for one currency pair. Page with limit and offset while hasMore is true.
Customer account activities, 1 operation
list_customer_account_activitiesList customer account activitiesGETLists customer accounts with their receivables activity totals (open receivables, transactions due) and customer details; filter with q. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Customer account activity, 1 operation
get_customer_account_activityGet customer account activityGETReturns one customer account with its receivables activity totals and customer details, by AccountId.
Journal batches, 1 operation
list_journal_batchesList journal batchesGETLists general ledger journal batches with status, period, source, totals and approval and posting status; filter with q. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Journal categories, 1 operation
list_journal_categoriesList journal categoriesGETLists journal categories (names and descriptions), for the journal category of entries. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Journal headers, 1 operation
list_journal_headersList journal headersGETLists the journals of a journal batch (name, ledger, category, period, currency, totals, status). Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Journal sources, 1 operation
list_journal_sourcesList journal sourcesGETLists journal sources (names and descriptions), for the source of journal entries. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Ledger balances, 1 operation
list_ledger_balancesList ledger balancesGETReturns general ledger account balances. Use finder AccountBalanceFinder with ledgerName, accountCombination (a percent sign for a segment means all values), accountingPeriod and currency.
Ledgers, 1 operation
list_ledgersList ledgersGETLists the ledgers (primary, secondary, reporting currency) with names, ids, currency, chart of accounts and calendar. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Legal entities, 1 operation
list_legal_entitiesList legal entitiesGETLists the legal entities (names, identifiers, ids), for the LegalEntity fields of transactions. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Payables invoice line, 1 operation
create_payables_invoice_lineCreate payables invoice linePOSTAdds a line (item, freight or miscellaneous charge) to a payables invoice, by the invoice key, and returns it.
Payables invoice lines, 1 operation
list_payables_invoice_linesList payables invoice linesGETLists the lines of a payables invoice (line number, type, amount, description, item, quantity, PO match, tax), by the invoice key. Page with limit and offset while hasMore is true.
Payables invoices, 1 operation
list_payables_invoicesList payables invoicesGETLists supplier (payables) invoices with header amounts, dates, supplier, status and validation status; filter with q. Each item links (rel self) to its key for get_payables_invoice. Page with limit and offset while hasMore is true.
Payables payment terms, 1 operation
list_payables_payment_termsList payables payment termsGETLists payables payment terms (names and ids), for PaymentTerms on supplier invoices. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Payables payments, 1 operation
list_payables_paymentsList payables paymentsGETLists supplier payments with payment number, date, amount, currency, status, payee, method and business unit; filter with q. Bank account numbers are not returned. Page with limit and offset.
Payment methods, 1 operation
list_disbursement_payment_methodsList disbursement payment methodsGETLists the payables payment methods (check, EFT, wire and so on) with their codes, for PaymentMethodCode on invoices and payments. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Payment process profiles, 1 operation
list_payment_process_profilesList payment process profilesGETLists payment process profiles (names and codes), which control how payments are processed and formatted. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Payment related invoices, 1 operation
list_payment_related_invoicesList payment related invoicesGETLists the invoices a supplier payment paid (invoice number, amount paid, discount, dates), by the payment CheckId. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Receipt methods, 1 operation
list_receipt_methodsList receipt methodsGETLists receipt methods (name, receipt class, remittance bank account name and dates), for ReceiptMethod on standard receipts. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Receivables adjustment, 1 operation
get_receivables_adjustmentGet receivables adjustmentGETReturns one receivables adjustment by AdjustmentId: amount, type, reason, status, dates and the adjusted transaction.
Receivables adjustments, 1 operation
list_receivables_adjustmentsList receivables adjustmentsGETLists receivables adjustments (amounts that increase or reduce a customer transaction) with type, status and the adjusted transaction. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Receivables business units, 1 operation
list_receivables_business_unitsList receivables business unitsGETLists the business units valid for Receivables (names and ids), for customer invoices and receipts. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Receivables credit memos, 1 operation
list_receivables_credit_memosList receivables credit memosGETLists receivables credit memos with number, date, customer, amounts, currency and status; filter with q. Card details are not returned. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Receivables invoice lines, 1 operation
list_receivables_invoice_linesList receivables invoice linesGETLists the lines of a receivables invoice (line number, item, description, quantity, unit price, amount, tax), by CustomerTransactionId. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Receivables invoices, 1 operation
list_receivables_invoicesList receivables invoicesGETLists customer (receivables) invoices with number, date, customer, amounts, currency, status and payment terms; filter with q. Card and bank details are not returned. Page with limit and offset.
Receivables payment terms, 1 operation
list_receivables_payment_termsList receivables payment termsGETLists receivables payment terms (names and ids), for PaymentTerms on customer invoices. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Standard receipts, 1 operation
list_standard_receiptsList standard receiptsGETLists standard receipts (customer payments recorded in Receivables) with number, date, amount, currency, customer, status and method. Bank and card numbers are not returned. Page with limit and offset.
Transaction sources, 1 operation
list_transaction_sourcesList transaction sourcesGETLists receivables transaction sources (names and ids), for TransactionSource on customer invoices. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Transaction types, 1 operation
list_transaction_typesList transaction typesGETLists receivables transaction types (names and ids), for TransactionType on customer invoices. Returns items plus count, hasMore, limit and offset: page with limit and offset while hasMore is true.
Use Oracle Fusion Cloud ERP from Claude Code, Cursor or Codex
Connect Oracle Fusion Cloud ERP in LiveContext, create an API key in Settings, then add the LiveContext MCP server to your client. Its Oracle Fusion Cloud ERP operations become tools the client can call, next to every other integration you connected.
claude mcp add --transport http livecontext https://livecontext.ai/mcp --header "X-API-Key: YOUR_API_KEY"[mcp_servers.livecontext]
url = "https://livecontext.ai/mcp"
[mcp_servers.livecontext.http_headers]
"X-API-Key" = "YOUR_API_KEY"{
"mcpServers": {
"livecontext": {
"type": "http",
"url": "https://livecontext.ai/mcp",
"headers": {
"X-API-Key": "YOUR_API_KEY"
}
}
}
}How to connect Oracle Fusion Cloud ERP
- Create your workspace
Sign up free. Nothing to install.
- Connect Oracle Fusion Cloud ERP once
Add your Oracle Fusion Cloud ERP connection in Settings. Every tool from this integration reuses it, and secrets are encrypted at rest and visible only to you.
- Describe the job in chat
The workflow builds itself in front of you and picks the endpoints it needs. Drag the steps yourself on the canvas whenever you would rather be explicit.
Oracle Fusion Cloud ERP integration FAQ
What can you do with the Oracle Fusion Cloud ERP integration?
LiveContext exposes 53 operations on Oracle Fusion Cloud ERP, covering payables invoice, payables payment, receivables invoice and journal batch.
