Oracle · 6 min read

Oracle Fusion Integration Architecture: REST, SOAP, FBDI, BICC and OIC

Most Oracle Fusion Cloud implementations don't run in a bubble. HCM, ERP, SCM and a handful of third-party systems all need to talk to each other, and Oracle gives you five ways to make that happen:…

Written by Aniket Mittal

Oracle Fusion integration architecture

Most Oracle Fusion Cloud implementations don't run in a bubble. HCM, ERP, SCM and a handful of third-party systems all need to talk to each other, and Oracle gives you five ways to make that happen: REST, SOAP, FBDI, BICC and Oracle Integration (OIC). Each one was built to solve a different problem. Use the wrong one and you'll end up dealing with slow syncs, messy governance, and licensing costs you didn't need to take on.

Integration Strategy Is an Architectural Decision

Too many implementations default to "whatever API is easiest to call," without evaluating throughput, cadence, or downstream consumption.

Three questions should drive every integration decision in Fusion:

  • Volume — How much data moves per cycle?
  • Urgency — Does the receiving system need it instantly, or on a schedule?
  • Nature — Is this a transactional exchange or an analytical one?

Get these three right, and the choice of protocol becomes obvious.

REST APIs — Built for Real-Time, Transactional Exchange

Oracle Fusion's REST layer uses resource-oriented endpoints and lightweight JSON payloads. It's the natural fit for synchronous, low-to-medium volume operations.

Best suited for:

  • Creating a single supplier invoice
  • Updating a worker's assignment record
  • Triggering an approval workflow
  • Any user-facing app expecting a near-instant response

Why do architects favor it?

  • OAuth 2.0 / SAML token-based authentication
  • Field-level selection reduces payload bloat
  • Pagination support for list operations
  • Oracle's clear long-term roadmap priority over SOAP

These aren't arbitrary choices either — NIST's guidance on securing microservices-based systems (NIST SP 800-204) lays out the same token-based, least-privilege access patterns that REST implementations in Fusion follow. Worth a look if your security team wants a standards reference to point to during review.

Where does it break down?

REST isn't built to push tens of thousands of records in one call. Rate limits and timeout thresholds turn bulk operations into a bottleneck fast.

SOAP Web Services — Legacy Compatibility, Not a Starting Point

SOAP still earns its place — just not for new builds.

Retain SOAP when:

  • Legacy ESBs (Enterprise Service Buses) are already configured around SOAP envelopes
  • Contract-first design with strict XML schema typing is mandatory
  • Specific HCM extract triggers or SCM composite operations lack a REST equivalent

The trade-offs

  • Heavier XML envelope overhead versus JSON
  • More rigorous schema management required
  • Slower to evolve than REST

Architect's rule of thumb: treat SOAP as a bridge technology for legacy dependencies — never the default for greenfield integration work.

FBDI — Engineered for High-Volume Batch Loads

File-Based Data Import (FBDI) replaces thousands of individual API calls with predefined CSV templates mapped directly to Fusion's interface tables.

Ideal use cases:

  • Initial data conversion during implementation
  • Periodic mass uploads — payroll batches, journal entries, item masters
  • Any load running into tens or hundreds of thousands of records

How does it work architecturally?

  1. Data lands in interface tables via structured CSV templates
  2. Built-in validation catches structural errors before they hit base tables
  3. Scheduled or on-demand import jobs process the batch

FBDI is strictly inbound — it loads data into Fusion, not out. That makes it the natural partner for ETL tools or scheduled file drops from upstream systems.

BICC — The Extraction Engine for Reporting and Analytics

If FBDI handles what comes in, BI Cloud Connector (BICC) governs what goes out at scale.

BICC pulls data from Fusion's predefined extract views — spanning HCM, ERP and SCM — and stages it in:

  • UCM (Universal Content Management), or
  • Cloud storage — Object Storage, Amazon S3, etc.

Why does it matter for reporting?

  • Optimized for full or incremental large-dataset extraction
  • Runs on scheduled cadence — hourly, nightly, or custom
  • Feeds data warehouses and BI platforms without overloading transactional APIs

Don't try to replicate this with REST polling. Repeated large-scale REST pulls for reporting purposes become unsustainable almost immediately.

Oracle Integration (OIC) — The Orchestration and Governance Layer

OIC sits above every protocol discussed so far. It's the iPaaS (Integration Platform as a Service) layer that ties REST, SOAP, FBDI and BICC-driven flows into one governed, monitored process.

What OIC adds that raw API calls don't:

  • Prebuilt adapters for Fusion and third-party SaaS platforms
  • Visual process orchestration
  • Centralized error handling and retry logic
  • A single monitoring dashboard across all integration flows

A hybrid example

An OIC process might trigger a real-time REST call for immediate transaction posting, then fall back to an FBDI batch load overnight for reconciliation — all inside one monitored workflow.

For enterprises juggling multiple touchpoints across HCM, ERP and external systems, this centralization is what keeps technical debt from piling up.

Quick Decision Framework

RequirementRecommended Method
Real-time, moderate-volume transactionsREST APIs
Legacy contract compatibilitySOAP
High-volume inbound batch loadsFBDI
Scheduled outbound reporting/analyticsBICC
Multi-system orchestration & governanceOracle Integration (OIC)

Frequently Asked Questions

What are the main integration methods in Oracle Fusion Cloud?

Oracle Fusion offers five integration methods: REST APIs, SOAP web services, File-Based Data Import (FBDI), BI Cloud Connector (BICC) and Oracle Integration (OIC). Each one is built for a different job, from real-time transactions and legacy compatibility to bulk data loads, large-scale extraction and orchestration.

When should I use REST APIs instead of FBDI?

Use REST APIs for real-time, low-to-medium volume transactions, such as creating a single supplier invoice or updating a worker's assignment. Use FBDI for high-volume inbound batch loads, such as initial data conversion, payroll batches or journal entries running into tens or hundreds of thousands of records.

Is SOAP still used in Oracle Fusion?

Yes, but mainly for legacy dependencies: existing ESBs built around SOAP envelopes, contracts that require strict XML schema typing, or operations that have no REST equivalent. SOAP should be treated as a bridge technology, not the default for new integration work.

What is the difference between FBDI and BICC?

FBDI is strictly inbound. It loads data into Fusion through CSV templates mapped to interface tables. BICC is outbound. It extracts large datasets from Fusion's predefined extract views into UCM or cloud storage to feed data warehouses and BI platforms.

What role does Oracle Integration (OIC) play?

OIC is the orchestration and governance layer that sits above REST, SOAP, FBDI and BICC. It adds prebuilt adapters, visual process orchestration, centralized error handling and retry logic, and a single monitoring dashboard across all integration flows.

How do I choose the right integration method?

Start with three questions: how much data moves per cycle (volume), whether the receiving system needs it instantly or on a schedule (urgency), and whether the exchange is transactional or analytical (nature). Once these are clear, the right method usually becomes obvious.

Conclusion

There's no single "best" integration method in Oracle Fusion — just the one that fits your volume, your latency needs, and which way the data's flowing. Companies that actually plan around this, instead of reaching for whatever they already know, end up with integrations that scale without turning into a maintenance headache down the line.

Tags: Oracle Fusion, Integration, REST API, OIC

All blog posts