Guides

Oracle Fusion data, explained by people who extract it every week

Practical, tested answers on BICC, PVOs and getting Fusion data into your lakehouse — from running production pipelines, not from the docs.

BICC · Incremental loads · 8 min

Oracle Fusion BICC incremental extraction: what actually controls what you get

Why the same rows keep coming back, why a “full load” returns 43 rows, and the two job settings that really decide what an extract contains.

BICC · Troubleshooting · 5 min

BICC extract fails with ORA-00918 “column ambiguously defined”? Curate the column list

Some wide Oracle Fusion PVOs can't be extracted with every column selected. Here's why, and the fix that makes them run.

BICC · Troubleshooting · 4 min

Columns missing from your BICC extract? Check isPopulate

Your model lists 502 columns but the file has 501. Some PVO columns are switched off by default — and rebuilding a job from the live job keeps them off.

Pipelines · Production · 9 min

Oracle Fusion to Azure or Databricks with BICC: a production checklist

What it takes to run 200+ PVOs every week without silent gaps — ordering, network load, delete detection and verifying every delivery.

Reference · 489 schemas

Oracle Fusion star-schema library

Browse fact and dimension models for Fusion subject areas across Financials, HCM, SCM, Projects and more.