AVIO Consulting

How to Integrate with Oracle Fusion Applications

Aug 29, 2018 | General

Oracle Fusion Applications provides web services as one of many mechanisms to integrate with and extend Oracle Fusion Applications in Oracle Applications Cloud Services.

These cloud applications include the following product families associated with these functional areas:

  • Oracle Fusion Customer Relationship Management. Manages customers, contacts, and resources, including data quality configuration.
  • Oracle Fusion Financials. Manages financial flows, including assets, ledgers, cash cycle, invoices and payments, accounts receivable, collections, and setup of sub-ledger accounting and tax configuration.
  • Oracle Fusion Governance, Risk, and Compliance. Integrates business intelligence, process management, and automated controls enforcement to enable sustainable risk and compliance management.
  • Oracle Fusion Human Capital Management. Provides employee management.
  • Oracle Fusion Procurement. Manages the procurement process, including requisitions, purchase orders, and supplier negotiations.
  • Oracle Fusion Project Portfolio Management. Manages projects, including how to plan, budget, forecast, collect costs, bill customers, and report performance.
  • Oracle Fusion Supply Chain Management. integrates and automates all key supply chain processes, from design, planning, and procurement to manufacturing and order fulfillment.

Oracle Fusion Applications

Integration Patterns


Extracts in the Oracle Fusion cloud-based world is a flexible way to generate data files with a defined definition. The definition consists of:

  • One or more extract data groups, depending on how many logical entities you want to extract.
  • One or more extract records depending on how many groups of information you want to collect.
  • One or more attributes depending on how many individual fields of data you want to collect.

Extracts can be very useful when you need to get larger datasets such as employee demographic data or budgets. Supported output formats for Oracle Fusion extract include: CSV, XML, Excel, HTML, RTF, and PDF. These extracts can be configured to drop on to an SFTP server, send an email, or to be retrieved as a response to a web service. Data can also be encrypted using OOB features with client-specific keys, which will make your security team happy.


BI Reports defined in Fusion will give the ability for consumers to set the query parameters to get filtered data; for example, a particular group of employees rather than the entire dataset. These reports can be accessed by using a web service that makes them data integration friendly.

The response will be in base64 encoded format and output format includes Microsoft Word, Adobe Acrobat, Microsoft Excel, Adobe Flash, and BI Publisher’s own layout editor. Data cannot be encrypted since the transaction is being done over an HTTPS URL with a secured password.

Extracts vs Reports

When to choose an extract over a report or vise versa? The short answer is – it all depends on the use case. Some of the use cases and preferred approaches include employee demographic data to downstream systems. Extracts make sense in this use case because the data is going to be huge and will have a standard definition.


Reports make more sense for lookups since they typically need selection criteria.

SOAP and REST Services: Oracle Fusion’s underlying complex of relational complicated data models don’t make it easy to use web services or REST services for all the functionalities. 

There are several web services offered by Oracle for integrating with different modules which are pretty straightforward to use. Even though Fusion was SOAP dominant earlier, Oracle is now offering more and more support to REST services in their recent releases. Web services can be used even with ESS jobs.

Atom Feeds:

HCM Atom feeds provide notifications of Oracle Fusion Human Capital Management (HCM) events and is tightly integrated with REST services. When an event occurs in Oracle Fusion HCM, the corresponding Atom feed is delivered automatically to the Atom server.

 The feed contains details of the REST resource on which the event has occurred. Subscribers who consume these Atom feeds use the REST resources to retrieve additional information about the resource. These are the following primary Atom feeds:

  • Employee Feeds
  • New Hires
  • Terminations
  • Employee Updates
  • Assignment creation, updates, and end dates
  • Work Structures Feeds (Creation, update, and end date)
  • Organizations
  • Jobs
  • Positions
  • Grades
  • Locations

Data through Atom feeds is particular to those feed enabled resources which means if it is not possible to get entire employee data for an action of employee update. Since each enterprise has its own challenges, there is no silver bullet to establish an integration pattern that fits all the needs. It all depends on the use case.

Is Oracle Fusion Applications the Right Integration Product for Your Enterprise?

As more software and applications have become available and business has become more sophisticated, Oracle integration no longer offers the same benefits it once did.

MuleSoft, on the other hand, provides innovative integration solutions that give you what you need faster, easier, and for a lower cost.

If you’re working with Oracle, ask yourself: Would you be better served with a solution that’s more efficient, quicker, and easier to implement and can provide you with better support? If yes, MuleSoft is your optimum solution.

Are you interested in implementing MuleSoft integrations into your organization? Get in touch with us at AVIO today.