Reference · built on requestConnectorERP & finance

Oracle Fusion Cloud ERP

Payables invoices, receivables, receipts, journal batches, ledger balances, and collections from Oracle Fusion Cloud ERP.

About

Oracle Fusion Cloud ERP is Oracle's cloud finance suite. Its REST APIs sit under /fscmRestApi/resources/11.13.18.05/ and cover payables invoices and holds, payments, receivables invoices, credit memos, standard receipts, disputes, collections delinquencies and promises, journal batches, and ledger balances. Each resource documents its GET, POST, PATCH, and DELETE methods and any named actions.

An operator on Fibric reads open invoices, holds, receipts, and delinquencies, and proposes an invoice hold, a dispute, or a promise to pay for your approval before anything is written. Nothing is written without a receipt that names the change, the reason, and the undo.

This is a reference listing. It documents what Fibric would read from Oracle Fusion Cloud ERP and what it could propose, based on the vendor's published interfaces. Fibric builds it under a managed deployment when you request it; selecting it here installs nothing.

Inputs

  • Payables invoices at /invoices, with approvals history at /invoiceApprovalsAndNotificationsHistory
  • Holds placed and released on invoices at /invoiceHolds
  • Receivables invoices, credit memos, and customer account activities, including standard receipts
  • Collections delinquencies and collection promises
  • Journal batches with their action logs, and account balances at /ledgerBalances
  • Payables payments at /payablesPayments, with stop-payment and escheatment actions
  • Business-event enabled records at /erpBusinessEvents and bulk import or export jobs at /erpintegrations

Proposed actions

  • Target capability: propose an invoice hold with POST /invoiceHolds so an invoice cannot be paid until released
  • Target capability: propose a receivables dispute with POST /receivablesDisputes
  • Target capability: propose a promise to pay with POST /collectionPromises
  • Target capability: propose validating, cancelling, or calculating tax on a payables invoice through its /invoices/action endpoints
  • Target capability: propose a stop payment with POST /payablesPayments/action/initiateStopPayment

Proposed actions are target capabilities. Every action runs propose-first and needs a validated deployment and the appropriate permissions.

What you can build

  • Hold a duplicate invoice before the payment run

    Compare new payables invoices against paid ones and propose an invoice hold with the matching invoice cited.

    With Duplicate Invoice, Three-Way Match

  • Turn a delinquency into a promise

    Read collections delinquencies, draft the outreach, and record the promise to pay the customer makes.

    With Dunning Cadence, Balance Write-Off

  • Check ledger balances against your dashboard

    Read account balances after each close and flag any figure that drifts from the number on the board pack.

    With Metric Reconciliation, Month-End Cutoff

Requirements

  • An Oracle Fusion Cloud ERP instance and its REST server URL, for example https://servername.fa.us2.oraclecloud.com
  • A user with the security roles and privileges for GET, POST, PATCH, and DELETE on each parent and child resource
  • Opt-in for any feature a resource or attribute depends on
Authentication
Basic authentication over SSL, a SAML 2.0 bearer token, or a JWT in the HTTP header, under the oracle/multi_token_over_ssl_rest_service_policy.

Limits

  • PATCH on a receivables invoice can change only InvoiceStatus, PaymentTerms, and TransactionDate
  • Some resources, such as /receivablesDisputes and /ledgerBalances by key, do not support GET
  • Updating an invoice date by REST does not recompute dependent fields such as terms date or due date
  • Bulk loads go through /erpintegrations jobs rather than row-by-row REST calls

Access and pricing

Reference listing. Fibric builds the connector under a managed deployment when you request it. Your quote covers the build, capabilities, usage, and support.

Request Oracle Fusion Cloud ERP ↗

Questions and answers

What is the base path for the Financials REST resources?
Resources sit under /fscmRestApi/resources/11.13.18.05/ on your REST server, for example https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/invoices. The version segment names Oracle's REST framework version.
Which authentication does Oracle accept?
Three standards under the multi-token policy: basic authentication over SSL, a SAML 2.0 bearer token in the header, or a JWT in the header from which the user name is taken.
Can the connector change an issued receivables invoice?
Only three attributes: InvoiceStatus, PaymentTerms, and TransactionDate. Other changes go through a credit memo or an adjustment on their own resources.
Ask about Oracle Fusion Cloud ERP

Ask about the capabilities and requirements in this listing.

For project-specific requirements, contact Fibric.