Analytics Catalog/Oracle Fusion ERP/Extraction pattern & data flow
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · How the data flows

Extraction pattern & data flow

Every report in this catalog lands in your warehouse the same way. Rather than repeat it on each report page, here is the pattern once: source modules extract through BICC, land raw, are conformed and reconciled to source, then organized into measures and dimensions as star-schema marts that feed dashboards, financial reporting, and the AI Analyst.

SOURCE · ORACLE FUSIONYOUR CLOUD WAREHOUSEANALYTICSGeneral LedgerPayablesReceivablesFixed AssetsTaxCash ManagementProjectsRaw landingBICC extracts, byte-for-byteConformedcleaned · typed · reconciledMarts · star schemasfacts + conformed dimensionsDashboardsFinancial reportingAI Analystgoverned · read-onlyBICC · DAILYGOVERNED

The four stages

Extraction methods

MethodWhen to use
BICCBulk extract of view objects to object storage, the path owned warehouses run on today
Data ExtractionExtracts from a read-only replica of Fusion through predefined business views. Oracle recommends it for all new extracts and says it will eventually replace BICC and BI Publisher extracts; flexfields are not yet in the views, and the views are a business object model rather than the tables and view objects BICC exposes (Oracle 26C readiness, status October 2026)
BI PublisherPixel-perfect operational output, bursting, schedules
OTBIAd-hoc self-service on seeded subject areas
REST / SOAPOrchestration and targeted lookups (ESS web service + metadata REST API)

How it works

Offerings → data stores → view objects (PVOs). Full or incremental (last-extract-date + prune time, default 1440 min). Runtime filters use __DATASTORE__.<column>. Large VOs chunk by creation-date or primary key. Output: .csv data, .mdcsv metadata, .pecsv keys, .mf manifest — landed to OCI Object Storage, UCM, or Cloud Storage Service.

How we integrate

Default build: Python orchestrating the BICC ESS SOAP web service (submitRequest / getRequestState) and the REST metadata API (/biacm/rest/meta/datastores). Versioned, owned by you, no licence. Tool-agnostic — if you run Informatica, Fivetran, ADF, or Matillion we work with it.