Analytics Catalog/Oracle Fusion ERP/The export ceiling
Explore the catalogModulesWhat the extract does not carryReporting tools guideReporting without memoryInventory as of any date
Oracle Fusion · Extraction · Reference

Where the exports stop

The report is correct, the export is short, and nobody said so. Every path out of Oracle Fusion reporting has a ceiling, the ceilings differ by path and format, and the numbers are scattered across support notes and forum folklore. Here they are in one table.

RuleKnow which ceiling applies before promising an extract. The cap depends on path and format, not on the report.
Nevertreat a report tool as a pipeline. The ceilings exist because reporting shares the machine that runs the business.
Why the ceilings existthe caps are protection, not oversight.

Delivered reporting queries the same pod that processes invoices and payroll. An unbounded export is a denial of service against your own close, so Oracle bounds them: row limits on screens, row and cell limits on spreadsheet exports, line limits on scheduled deliveries, memory guards on long queries. In a hosted service, administrators cannot raise them; that this is so is practitioner-observed, and the enhancement requests asking for it sit open for years.

The mistake is not the caps. It is teams discovering them one truncated file at a time, then building chunk-by-date-range rituals on a tool that was never the right vehicle. Volume belongs on the extract service and the warehouse; the table below is for knowing where the walls are until you get there.

The matrixpath by path, each figure labeled by its source.
PathCeilingSource of the figure
Analysis on screen65,000 rows displayed.Vendor-documented, release-dependent.
Analysis export to spreadsheet25,000 rows and 50,000 cells.Vendor-documented.
Formatted spreadsheet exportAbout 75,000 rows in current releases.Practitioner-observed; the subject of open enhancement requests.
Unformatted data exportAbout 300,000 rows.Practitioner-reported; varies by release.
Scheduled agent delivery25,000 lines, spreadsheet or comma-separated alike.Oracle support note, confirmed by title.
Publisher online queriesMemory guard timeouts on long-running data sets.Vendor-documented mechanism; thresholds release-dependent.
Bulk extract filesOutput splits near 5 gigabytes per file; behavior at the boundary is reported as silent truncation with a successful job status.Split setting vendor-documented; truncation behavior practitioner-reported. Verify counts every run.

Two practitioner notes belong beside the table. Figures shift across quarterly releases, which is why each row carries its source class rather than a citation to a moment in time. And a recent release removed the bulk extract logs from the interface, so diagnosing a short file now means reading manifest counts, one more reason the completeness habit below matters.

Above the ceilingthe pipeline that has none, and the habit that catches everything.

The unbounded path is the one built for it: the bulk extract service into your own storage, landed raw and modeled in your warehouse, where a query competes with nobody's invoice processing. What that path does and does not carry is its own page, what the extract service does not carry, and the toolchain choice is the reporting tools guide.

Whatever the path, one habit converts every silent ceiling into a loud one: count at the source, count what landed, and fail the run on a difference. Truncation, trimming, and splits all fall to the same check, which is the discipline this catalog applies from payables ties to payroll. Sample figures above are caps, not client data.

Use case
Problem
Exports truncate at caps that differ by path and format, the numbers are scattered across support notes, and files that look complete quietly are not.
What we build
An extraction pipeline into your own warehouse with no export step, and source-to-landed counts checked on every run.
What you get
Volume answers with no ceiling, and any truncation anywhere surfaced as a loud failure instead of a wrong decision.
Tired of finding the ceiling one short file at a time?
We build the pipeline with no export step at all, counts checked every run.
Talk to us
Terms on this page
ERP
Enterprise resource planning, the system of record for operations and finance.
OTBI
Oracle Transactional Business Intelligence, the delivered reporting layer.
BICC
Business Intelligence Cloud Connector, the bulk extract service.
GB
Gigabyte, roughly a billion characters of data.
agent
A scheduled report delivery to email or storage.
memory guard
A limit that cancels queries consuming too much memory.
governor
A deliberate cap protecting shared infrastructure.
manifest
The extract service file listing what each batch contains.
pod
The hosted environment a Fusion customer runs in, shared by reporting and operations.