Skip to content

§00Integrations / ERP

Oracle Fusion Cloud ERP integration: REST for transactions. FBDI for volume. Never an undocumented API.

Oracle Fusion Cloud ERP is SaaS with quarterly updates and clear rules: at most 500 records per REST call in Oracle's SCM and Procurement guidance, FBDI and BICC for volume, and no undocumented REST APIs. PartnerMCP builds on the documented resources — salesOrdersForOrderHub, receivablesInvoices, inventoryOnhandBalances — pins the REST version and confirms every create before it retries. Running Oracle NetSuite instead? It has its own page at NetSuite.

How PartnerMCP connects

01Primary path

Fusion REST resources

https://<server>/fscmRestApi/resources/11.13.18.05/<resource>, and the newer v1 resources where they exist, which need an OAuth token from OCI IAM. Reads are paged with offset and limit, filtered with q and trimmed with fields and onlyData=true.

Product
Oracle Fusion Cloud ERP
Vendor
Oracle
Category
ERP
Runs
Cloud
Connects through
REST (fscmRestApi)
Detects changes with
business events (Oracle Integration) · REST polling
On this page
  1. 01What you can build
  2. 02Objects and events
  3. 03What it handles
  4. 04Questions
  5. 05References
§01—What you can build

What you can build.

Each one starts as a sentence. PartnerMCP answers with a plan in Oracle’s own objects, then builds it against your systems.

01Salesforce Opportunity → Oracle Order Management

“When an Opportunity closes in Salesforce, create the sales order in Oracle Order Management and show fulfillment and invoice status on the Opportunity.”

Build this integration

PartnerMCP will

  1. Start on IsWon = true from Salesforce Change Data Capture.
  2. Create the order in salesOrdersForOrderHub with the Opportunity as the source order reference.
  3. If Oracle answers 504, look the order up before retrying — it may already exist.
  4. Follow Sales Order Notification events or poll the order for holds and fulfillment.
  5. Read receivablesInvoices for invoice status and write it back to the Opportunity.

02Oracle on-hand → Shopify inventory

“Keep Shopify stock in step with Oracle on-hand balances for our web warehouse.”

Build this integration

PartnerMCP will

  1. Read inventoryOnhandBalances for the web organization and subinventory, 500 rows at a time.
  2. Map Oracle items to Shopify variant SKUs.
  3. Adjust Shopify inventory with inventoryAdjustQuantities and an idempotency key.

03Bulk loads through FBDI

“Load our nightly billing file from the legacy system into Oracle instead of sending thousands of REST calls.”

Build this integration

PartnerMCP will

  1. Turn the file into the FBDI template's CSV, zipped with its manifest.
  2. Upload it with uploadFileToUCM and start the import with submitEssJobRequest.
  3. Wait for ErpImportBulkDataEvent, then read the job's results and send rejected rows to review.
§02—Objects and events

Objects and events, by their API names.

The records PartnerMCP reads and writes in Oracle, and the events that start a run.

  • Sales orders

    salesOrdersForOrderHub

    Create, get, patch and delete, plus actions such as applyHold, releaseHold, splitFulfillmentLine and updateActualDeliveryDate.

  • Receivables invoices

    receivablesInvoices

    With child receivablesInvoiceLines.

  • On-hand inventory

    inventoryOnhandBalances

    Summarized by organization, subinventory and locator, with child lots.

  • Purchase orders

    draftPurchaseOrderspurchaseOrders

    Drafts and change orders are created and submitted (…/action/submit) through draftPurchaseOrders; purchaseOrders views and acts on open orders.

  • Customer parties

    hubOrganizations

    Organization parties under crmRestApi; customer accounts and sites are completed partly through SOAP services, per Oracle's integration guidance.

  • Bulk import and export

    erpintegrations

    importBulkData, uploadFileToUCM and submitEssJobRequest for FBDI jobs.

Events

  • Public business events

    For example, a payables invoice creation signal when an invoice is created in the UI or through REST. Events must be enabled and are subscribed through Oracle Integration's ERP Cloud Adapter; private-endpoint adapter connections don't support ERP business events.

  • Sales Order Notification

    Order Management status changes — header and line status, holds, splits, closes — configured on Manage Business Event Trigger Points, optionally delivered to a connector registered on Manage Connector Details.

  • FBDI and export callbacks

    ErpImportBulkDataEvent and ExportBulkDataEvent mark the end of bulk jobs, so PartnerMCP never polls a file that isn't ready.

  • REST polling

    q finders, paged at 500 rows a call, where no event exists.

§03—What it handles

What PartnerMCP handles for you.

The details that break Oracle integrations in production, and what PartnerMCP does about each one.

  1. 01

    500 records per call

    Oracle's REST guidance caps a request at 500 records. PartnerMCP pages with offset and limit and trims each response with fields and onlyData.

  2. 02

    A 504 may still have created the order

    Oracle notes that a timed-out create can still process the order. PartnerMCP checks with a GET on the source reference before any retry, so a timeout never becomes a duplicate.

  3. 03

    Version pinning

    REST framework versions aren't backward compatible, and resources exist as 11.13.18.05, v1 or both. PartnerMCP pins the version per resource and treats an upgrade as a tested change.

  4. 04

    Volume belongs in FBDI and BICC

    Oracle's guidance is FBDI for bulk import and BICC for bulk extract. PartnerMCP uses REST for transactions and switches to them for volume.

  5. 05

    Maintenance windows

    A 503 that mentions maintenance can last up to 8 hours. PartnerMCP pauses the flow and queues work rather than burning retries, and retries 500, 502, 503 and 504 with exponential backoff otherwise.

  6. 06

    Events are built for Oracle Integration

    Most Fusion business events are delivered through Oracle Integration's ERP Cloud Adapter. PartnerMCP uses Order Management's connector delivery where it applies and polling elsewhere, and says which one each flow uses.

  7. 07

    Data security decides what you see

    Fusion applies data security to API users, so a 404 can mean missing business-unit access, not a missing record. PartnerMCP checks access during discovery.

§04—Questions

Oracle integration questions.

Is this page about Oracle NetSuite?

No. This page covers Oracle Fusion Cloud ERP — Financials, Procurement, Supply Chain and Order Management. Oracle NetSuite is a different product with its own API (SuiteTalk REST and SuiteQL) and its own page at NetSuite.

Does Oracle offer an MCP server for Fusion ERP?

Oracle's AI Agent Studio supports MCP as a client, so Fusion agents can call external tools. PartnerMCP connects to Fusion through its REST resources, FBDI and BICC.

Can PartnerMCP receive Fusion events without Oracle Integration?

For Order Management, yes: it can publish Sales Order Notification events to a connector you register on Manage Connector Details. Most other public business events are designed for Oracle Integration's ERP Cloud Adapter, so PartnerMCP polls for those.

How does it handle large volumes?

With Oracle's own split: FBDI for imports, BICC for extracts and REST for transactions. PartnerMCP chooses per flow and shows you which path each step uses.

What about E-Business Suite or JD Edwards?

They're different, on-prem Oracle products and aren't covered here. PartnerMCP can learn their APIs the way it learns any custom system, and reach them through the Edge Agent.

§05—References

Vendor documentation.

The public documentation behind the technical details on this page.

§06Next step

Connect Oracle to the rest of your systems.

Describe what should happen. PartnerMCP shows you the plan before anything is built.