How-toOracle Fusion Cloud ERPOracle Integration Cloud (OIC) / Fusion Adapter

Connect Oracle Integration Cloud (OIC) To Fusion ERP

Question
How to connect Oracle Integration Cloud to Fusion ERP

Also searched as

  • OIC Fusion ERP adapter connection setup
  • Oracle Integration Cloud integration with Fusion Applications
  • OIC ERP Cloud adapter authentication
  • when to use OIC instead of direct REST calls to Fusion

Short answer

OIC connects to Fusion ERP primarily through the prebuilt ERP Cloud Adapter, which wraps Fusion's REST and SOAP web services with OAuth-based authentication and pick-list discovery of available business objects and operations, instead of you hand-building every REST call. Use the adapter for standard integrations; drop to a generic REST or SOAP adapter only when the ERP Cloud Adapter does not yet expose the specific service you need.

Applies to: Oracle Integration Cloud (OIC Gen 3), Oracle Fusion Cloud ERP and SCM, standard ERP Cloud Adapter

Set up an OIC connection to Fusion ERP

  1. 1In OIC, create a new Connection and select the Oracle ERP Cloud Adapter (or Oracle ERP Cloud - for Integration) from the adapter catalog.
  2. 2Enter the Fusion instance host URL and choose the security policy - typically OAuth-based (Resource Owner Password Credentials or a configured confidential application) or Basic Authentication with an integration user, depending on what your tenant's identity setup supports.
  3. 3Test the connection; a successful test confirms OIC can reach the Fusion instance and authenticate, not that any specific business object is accessible yet.
  4. 4Create an integration flow (App Driven or Scheduled) and add the ERP Cloud connection as an invoke; the adapter wizard lets you browse and pick the business object, operation, and whether it is a SOAP or REST-based service.
  5. 5Map source and target payloads in the integration canvas; for BI Publisher-based extracts, use the adapter's report/BIP options instead of manually calling BI Publisher's web service.
  6. 6Add error handling with a fault scope or Business Identifiers so failed instances are traceable in OIC's Monitoring, and configure retry policy for transient Fusion-side errors like a Blocked ESS job.
  7. 7Activate and test end to end with realistic data volumes before relying on scheduled or event-driven triggers in production.

Why Use The Adapter Instead Of Raw REST

The ERP Cloud Adapter discovers available Fusion REST and SOAP services, exposes their operations and payload structures inside the OIC design canvas, and handles OAuth or Basic Auth token mechanics for you. Calling Fusion REST endpoints directly with a generic REST adapter still works and is sometimes necessary, but you lose the guided object picker and take on more manual payload and auth handling.

Authentication Choices

Most ERP Cloud Adapter connections authenticate with either Basic Authentication against a dedicated integration user, or an OAuth flow backed by an Identity Cloud or OCI IAM application registered for Fusion. The right choice depends on what your tenant's identity provider is configured to support - check with whoever administers Fusion's Identity and Access Management before building the connection, since a mismatch here is the most common reason a connection test fails.

Event-Driven Vs Scheduled Integrations

Fusion can publish business events (through Oracle Integration Cloud's event subscription or the Fusion Applications event framework) that trigger an OIC integration in near real time, which suits things like a new supplier invoice notification. For bulk or batch-style movement - nightly master data sync, period-end extracts - a scheduled integration calling FBDI, HDL, or BI Publisher through the adapter is usually simpler and more predictable than trying to force an event-driven design onto bulk data.

Common Failure Points

A connection that tests fine can still fail mid-flow if the integration user lacks the data security scope for a specific business unit, or if a BI Publisher report referenced by the adapter has been renamed or moved to a different folder in the Fusion BI catalog. Both surface as generic OIC runtime errors, so check the Fusion-side security and report path first before assuming the OIC flow itself is broken.

Common pitfalls

  • !Reusing a personal Fusion login as the integration user instead of a dedicated service account with scoped roles - it breaks when that person's password rotates.
  • !Assuming a successful connection test in OIC guarantees access to every business object - function and data security are still evaluated per API call.
  • !Building bulk data movement as an event-driven integration when a scheduled FBDI/HDL-based flow through the adapter would be simpler and more reliable.
  • !Not setting a retry policy for transient Fusion errors, such as an ESS job temporarily Blocked, causing an integration to fail permanently on a condition that would have cleared in minutes.
  • !Hardcoding a BI Publisher report path in the integration instead of confirming it against the current Fusion BI catalog folder structure after a report gets moved or renamed.
  • !Skipping realistic volume testing, so pagination limits and governance thresholds only surface once the integration is already in production.

How an ERP-grounded AI assistant handles this

ERPray grounded on both your Fusion tenant and your integration landscape can trace a failed OIC-to-Fusion flow back to its actual cause - a data security gap, a renamed BI Publisher report, or a Blocked ESS job on the Fusion side - instead of you switching between OIC Monitoring and Fusion Scheduled Processes to piece the failure together manually.

See ERPray

Frequently asked questions

Do I need the ERP Cloud Adapter, or can I use a generic REST adapter?

The generic REST or SOAP adapter can call any Fusion web service directly and works fine, but you lose the ERP Cloud Adapter's object picker, prebuilt operation list, and simplified authentication handling. Most implementations prefer the ERP Cloud Adapter for anything it already supports and fall back to generic REST only for newer or niche services it does not yet expose.

Can OIC trigger a Fusion FBDI or HDL load directly?

Yes - the ERP Cloud Adapter can invoke the Load Interface File for Import and related scheduled processes, or drop files for HDL pickup, as part of an OIC integration flow, letting you orchestrate file generation, upload, and job submission from a single integration rather than scripting each step separately.

Why does my OIC integration fail only for certain business units?

This is almost always a Fusion-side data security gap: the integration user's role has function access to the API but not the data role or security profile covering that particular business unit or ledger, which produces an access error only when the flow touches that scope.

Is Basic Authentication still supported for OIC to Fusion connections?

It remains a commonly used option for the ERP Cloud Adapter alongside OAuth-based flows, but which one your tenant supports depends on how Identity and Access Management is configured for Fusion. Confirm the current supported options with your Fusion security administrator before building the connection.

Related

How-to

Paginate And Authenticate Oracle Fusion REST API Calls Correctly

Oracle Fusion Cloud REST APIs authenticate with HTTP Basic Authentication, an integration user's credentials, over HTTPS by default, and paginate with limit and offset query parameters rather than a page number. Loop on the hasMore flag in the response until it returns false to retrieve a full result set.

How-to

HCM Data Loader Vs FBDI: Which One Loads Your Fusion Data

HCM Data Loader (HDL) is the dedicated bulk tool for HCM business objects - workers, assignments, compensation, absences - and uses a plain-text .dat file with METADATA and MERGE or DELETE action lines, not a spreadsheet template. FBDI is the general Financials and SCM bulk-load framework built on Excel macro templates that stage data into interface tables. If the object lives in HCM, use HDL; if it lives in Financials, Procurement, or SCM, use FBDI.

Error fix

Clear An Oracle Fusion ESS Job Stuck In Blocked Status

A Blocked status on an Oracle Fusion Enterprise Scheduler (ESS) job almost always means an earlier instance of the exact same job is still running or stuck, and the job definition does not allow simultaneous requests. Find and finish, or cancel, the earlier request first; only then does the Blocked request move to Running.

Error fix

Fix The Oracle Fusion "You Don't Have Access To This Data" Error

This generic Oracle Fusion security message means the function privilege and the data security scope did not both line up for that user on that record - most often the job role is assigned but the matching data role, security profile, or business unit and ledger context in Manage Data Access for Users is missing. Fix it by checking data access setup for the user's role, not by re-granting the same job role again.

Error fix

Fix FBDI Import Failures From Interface Table Validation Errors

When a Fusion FBDI import job errors out, the cause is almost always bad data in the interface tables (an invalid value set, a wrong date format, or a missing required column), not the ESS job itself. Open the process's Interface Errors Report or the Correct Import Errors spreadsheet to see the exact rejected rows and reason codes, fix the source data, and resubmit from the interface tables instead of re-running the whole FBDI load.

How-to

OTBI vs BI Publisher: Which One Should You Use

Use OTBI when a business user needs ad hoc, self-service, real-time analysis with no fixed layout. Use BI Publisher when you need a pixel-perfect, scheduled, high-volume, or externally distributed document such as an invoice, check, or statutory report. Most Fusion implementations end up using both, not one instead of the other.

AI for ERP

Fusion Cloud ERP AI: OCI Generative AI Service vs. a Private LLM

Oracle's OCI Generative AI Service is a real option for Fusion Cloud ERP, but not the only one. Compare it honestly against a private LLM for sensitive data.

AI for ERP

Oracle ERP AI Consulting: What a Partner Should Deliver

What to demand from an Oracle ERP AI consulting partner across EBS, JD Edwards, NetSuite, and Fusion Cloud: interface tables, APIs, and buyer questions.

Stuck on Oracle Fusion Cloud ERP?

Talk to engineers who work inside Oracle Fusion Cloud ERP every week, and who build private AI that answers these questions from your own ERP data.

Talk to an ERP engineerBrowse ERP Help
All ERP Help articles