Search 800 + Posts

Jul 21, 2026

Connecting the Wrench to the Route: Integrating Oracle Fusion Enterprise Asset Management with Oracle Field Service Cloud

Asset-intensive organizations run into the same wall eventually: their maintenance planning lives in one system, and the people actually turning the wrench live in another. Oracle Fusion Enterprise Asset Management (EAM) is where work orders get created, parts get planned, and asset history gets tracked. Oracle Field Service (OFS) Cloud is where the technician's day actually gets built — scheduled, optimized, and executed. Without a solid integration between the two, planners end up re-keying data, dispatchers work off stale information, and technicians show up without the parts or context they need.



Oracle Integration Cloud (OIC) is the natural bridge here, and Oracle has documented reference patterns for exactly this pairing. Here's what a well-built integration actually looks like.

Jul 15, 2026

Modernizing Employee Onboarding: Integrating Oracle EBS on OCI with ServiceNow

 


Jul 14, 2026

BICC vs. the New Data Extraction Tool: What's Actually Changing in Oracle Fusion

The Data Extraction tool is designed as the modern, high-performance successor to the Business Intelligence Cloud Connector (BICC). While both tools serve the same core purpose—moving bulk data out of Oracle Fusion for use in downstream systems like data warehouses—they differ significantly in their underlying architecture, performance, and user experience.

The following are the key differences between BICC and the Data Extraction tool:

1. Data Source and Application Load

  • BICC: Queries the live transactional database of Oracle Fusion Applications. Because of this, large BICC extracts can compete for resources with the live application, creating high load and potentially impacting transactional performance.

  • Data Extraction Tool: Queries a Read-Optimized Data Store (RODS), which is a continuously refreshed replica of the transactional data. This isolation means the tool has near-zero load on the core application database, allowing for faster and more reliable extractions without affecting live users.

2. Performance and Scalability

  • Performance: BICC is rated as having "Medium" performance, whereas the Data Extraction tool is rated as "Very High".

  • Incremental Support: Both tools support incremental (delta) extracts. BICC has offered this for years against the live database. The Data Extraction Tool also supports full and incremental extracts, but runs them against the replicated RODS layer — meaning incremental extraction adds no additional load to the transactional database, which isn't guaranteed with BICC's live-database queries.

  • Execution Models: The new tool supports both synchronous processing for small, immediate requests and asynchronous/batch processing for high-volume scheduled pipelines.

3. Query Language and Schema

  • Query Language: BICC uses standard extract definitions often based on BI Publisher-style report definitions. The Data Extraction tool uses BQL (Business Object Query Language), a language purpose-built for this extraction layer.

  • Schema Type: BICC utilizes complicated views, while the Data Extraction tool leverages a business object data model with "clean" business and extraction views that simplify data organization.

    The Data Extraction tool is being extended to support data extraction for integration use cases, where SQL queries can be modeled as business object queries against the Read-Optimized Data Store. These extract queries can be defined across multiple entities and include filter conditions to produce the required data shape for integration requirements.

    An AI Agent, Data Extraction Query Transformer, is available to convert SQL statements into extract queries. These extract queries can be executed on demand in synchronous mode within integrations or included as part of the existing asynchronous data extracts.

    For data extraction from Oracle Fusion Applications, use Read-Optimized Data Store based data extraction instead of Oracle Analytics Publisher.

4. User Experience and Interface

  • User Interface: BICC uses a legacy UI, while the Data Extraction tool features a modern, Redwood-based experience.

  • Ease of Use: The new tool is designed for self-service with a point-and-click interface for selecting pillars (e.g., Supply Chain & Manufacturing), functional areas, and specific attributes.

5. Data Delivery and Coverage

  • Output Delivery: BICC can be configured to push data directly to an external Storage Cloud (like an OCI bucket). Currently, the Data Extraction tool's native output lands in Universal Content Management (UCM); moving these files to an OCI bucket requires a custom automation layer.

  • Object Coverage: BICC is a proven tool with established coverage across Fusion. The Data Extraction tool is in its initial release phase with growing coverage—Oracle is actively expanding support module-by-module.

    For the full deep dive  see the companion long-form post 

Summary Comparison Table

Feature

BICC

Data Extraction Tool

Data Source

Live Fusion Database

Read-Optimized Data Store (RODS)

Performance

Medium

Very High

Load on Apps

High

Near-zero

Query Language

Extract Definitions

BQL (Business Object Query Language)

UI

Legacy

Redwood

Schema

Complicated views

Clean business object views

Native Output

UCM or External Cloud Storage

UCM (Requires automation for OCI)


Tags : Oracle Fusion Cloud , Oracle RODS,Read-Optimized Data Store,Data Extraction Tool,Oracle BICC,BICC Migration,Oracle Autonomous Data Warehouse,Oracle ADW,BQL

Jul 12, 2026

Oracle RODS and the Data Extraction Tool: A Quick Primer

Oracle Fusion Cloud is rolling out a new architecture for bulk data extraction, and if you're running BICC pipelines today, it's worth understanding where this is headed.

RODS (Read-Optimized Data Store) is a continuously refreshed replica of Fusion's transactional data, built on Autonomous AI Lakehouse technology. Oracle GoldenGate replicates changes from the live Fusion database into RODS in near real-time. The point is separation: extraction workloads run against this isolated copy instead of competing with live business transactions on the production database.

Oracle RODS and the Data Extraction Tool: A Practical Guide for Fusion Data Teams

If you run Oracle Fusion Cloud Applications and have spent any time building extraction pipelines with BI Cloud Connector (BICC), you've probably run into the same tension: BICC is reliable, but it's batch-oriented, and large extracts can compete for resources with the live application. Oracle's answer to this is a new architectural layer called RODS (Read-Optimized Data Store), paired with a new customer-facing Data Extraction Tool. This post walks through what both are, how they fit together, and how they compare to the extraction tools most Fusion teams already know.



download copy is available in our linkedin Post - https://tinyurl.com/mv8k6sck

Youtube link our channel post - https://youtu.be/uaQ93AOaxDg?si=PV6XCz7L9ZN87NcN

What Is RODS?

RODS stands for Read-Optimized Data Store. It's built on Oracle Autonomous AI Lakehouse technology and is designed specifically for high-volume, read-intensive workloads. Rather than being a customer-facing product in its own right, RODS is best understood as an architectural layer — a continuously refreshed, read-optimized replica of Fusion's transactional data, sitting alongside the live application database.

The core idea is separation of concerns: extraction workloads should never compete with live transaction processing. Traditionally, reporting and integration tools like BICC, REST APIs, or BI Publisher either query the live Fusion database directly or are constrained to scheduled batch windows. RODS solves this by giving extraction tools an entirely separate environment to query, one that's kept in sync with Fusion but isolated from operational traffic.

Jul 8, 2026

FDI or OAC-to-Fusion? Choosing the Right Path for Oracle Fusion Analytics

 If Oracle Fusion Data Intelligence (FDI) comes with prebuilt pipelines, a ready-made star schema, and out-of-the-box dashboards — why would anyone still connect Oracle Analytics Cloud (OAC) directly to Fusion and build reports from scratch?



It's a fair question, and one we hear often from clients evaluating their Fusion analytics roadmap. The honest answer is: both approaches are valid — they just solve different problems. At BizInsight, we've implemented both, and this post breaks down when each one makes sense, so you can make that call with your eyes open instead of defaulting to whichever one a vendor pitched first.

The Two Flavors, in One Sentence Each

Jun 14, 2026

An IT Architect's Guide to Implementing the Oracle Analytics Cloud AI Agent

What happens after the Business Analyst hands you the design — ADW views, ODI pipelines, dataset governance, security, and everything the agent needs to actually work in production.

This is Part 2 of a two-part series on OAC AI Agent design. Part 1 — The Business Analyst's Guide — covers discovery, dataset field design, knowledge document structure, and supplemental instructions from the BA perspective. This blog picks up where the BA handoff package ends and focuses on the IT Architect's implementation responsibilities.

If you have read Part 1 of this series, you know that a Business Analyst's job is to define what the OAC AI Agent needs — the questions it must answer, the fields it requires, the policies it must reference, and the vocabulary it must understand. A well-executed BA design produces a complete handoff package: field specifications, derived metric formulas, knowledge document drafts, vocabulary maps, and supplemental instructions ready to paste into OAC.

Download complete Guide from our linkedIn Page

The IT Architect's job is to make that design technically real — and to make it trustworthy at scale. Not just for the first agent, but for every agent the organisation will build after it. That requires a different mindset than building a dashboard or a report. It requires thinking about data lineage, pipeline governance, security boundaries, and the architectural foundation that determines whether AI answers can be trusted at all.

This blog covers the seven technical implementation decisions that separate a production-grade OAC AI Agent from a demo that works once and breaks in real life.

The core risk to understand upfront: An OAC AI Agent will give confident, fluent, well-formatted answers regardless of whether the underlying data is correct, governed, or complete. The agent has no way to tell the user "I am not sure about this number." It answers with the same confidence whether the data is perfect or wrong. The IT Architect's job is to ensure the data behind the agent is never the thing that fails.

Jun 12, 2026

What are the three essential components for a successful OAC AI agent?

A successful Oracle Analytics Cloud (OAC) AI Agent is built upon three essential components that function as the actual "product," while the agent itself is merely the container. These three components are: