Oracle Fusion SaaS Applications High Frequency Data Extraction and Ingestion on OCI

October 31, 2023 | 4 minute read
Matthieu Lombard
Consulting Solution Architect
Text Size 100%:


Content validated on 10/31/2023 with

  • ADW Version Oracle Database 19c Enterprise Edition Release - Production Version

  • Oracle Cloud Application 23C (

  • Oracle Data Integrator on Marketplace ODI V12.


In today's data-driven world, having access to fresh data is a fundamental aspect of staying competitive and agile. It empowers companies to make informed decisions, minimize risks, enhance operational efficiency, and meet the evolving needs of customers and markets.

This document is an attempt to describe a technical architectural pattern for Oracle Fusion Application Cloud data extract at a higher frequency than it is typically used in a Data Management and Analytics context to enable organization to meet the data recentness requirements in a Finance, Supply Chain Management or Customer Experience context.

It will first describe the various business cases and benefits for the functional domains cited above.

Then it will describe the technical architecture on Oracle Cloud Infrastructure (OCI) of the proposed solution, specifically the Data Extraction layer and the Data Transformation and Load layer.

Having close to near real-time data updates in Enterprise Resource Planning (ERP), Supply Chain Management (SCM), and Customer Experience (CX) offers significant business benefits by providing decision-makers with up-to-date information. In today's fast-paced business environment, real-time data enables organizations to make agile and informed decisions. For ERP systems, it means that financial and operational data is constantly refreshed, allowing for precise financial forecasting, inventory management, and production planning. This, in turn, helps in optimizing resource allocation, reducing costs, and ensuring that business processes are aligned with current market conditions. In SCM, real-time data enables enhanced visibility into the supply chain, allowing companies to respond promptly to disruptions, optimize inventory levels, and meet customer demand efficiently. This results in reduced lead times, lower carrying costs, and improved customer satisfaction.

 Oracle Fusion SaaS Applications High Frequency Data Extraction and Ingestion on OCI Whitepaper

Please access the link here to read the whitepaper.

Good reading!


A-Team Blogs on Partition Exchange

Using Oracle Partition Exchange with ODI

Configuring ODI with Oracle Partition Exchange

BI Cloud Connector

BI Cloud Connector Performance Recommendations

A-Team BICC Blogs

Database Design Best Practices

Statistics gather best practices

Get the best out of partitioning

Managing Automatic Partitioning on Autonomous Database Oracle Documentation

Automatic Partitioning with Autonomous Database Blog

 Want to Learn More?

Click here to sign up to the RSS feed to receive notifications for when new A-team blogs are published.


This document discussed the importance of up-to-date data in various business domains, including Finance, Supply Chain Management, and Customer Experience. It emphasizes that near real-time data is crucial for informed decision-making, operational efficiency, regulatory compliance, and customer satisfaction. 
It also introduced a technical architectural pattern for extracting Oracle Fusion Application Cloud data at a higher frequency, outlining the benefits and use cases for each functional domain. 

It covered aspects like accurate financial reporting, improved supply chain visibility, and enhanced customer support. Additionally, it described a technical solution architecture involving Oracle Cloud Infrastructure (OCI) for efficiently extracting and managing data from Oracle Fusion SaaS Applications, highlighting components like Oracle Data Integrator, Data Extraction, Data Storage, Data Transformation, Load, and Analytics.

In summary, the text underscored the significance of up to date real-time data in modern business operations and presents a technical solution architecture for achieving high-frequency data extraction and management in Oracle Fusion SaaS Applications on OCI.




Bookmark this post to stay up-to-date on changes made to this blog as our products evolve.

Matthieu Lombard

Consulting Solution Architect

The Oracle A-Team is a central, outbound, highly technical team of enterprise architects, solution specialists, and software engineers.

The Oracle A-Team works with external customers and Oracle partners around the globe to provide guidance on implementation best practices, architecture design reviews, troubleshooting, and how to use Oracle products to solve customer business challenges.

I focus on data integration, data warehousing, Big Data, cloud services, and analytics (BI) products. My role included acting as the subject-matter expert on Oracle Data Integration and Analytics products and cloud services such as Oracle Data Integrator (ODI),  and Oracle Analytics Cloud (OAC, OA For Fusion Apps, OAX).

Previous Post

Securing Oracle Fusion Cloud Supplier Portal with IAM Domains and MFA

Roland Koenn | 7 min read

Next Post

Dynamically Filter Apache Server Access Logs with Python

Shea Nolan | 6 min read