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.
◆ 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.
| Path | Ceiling | Source of the figure |
|---|---|---|
| Analysis on screen | 65,000 rows displayed. | Vendor-documented, release-dependent. |
| Analysis export to spreadsheet | 25,000 rows and 50,000 cells. | Vendor-documented. |
| Formatted spreadsheet export | About 75,000 rows in current releases. | Practitioner-observed; the subject of open enhancement requests. |
| Unformatted data export | About 300,000 rows. | Practitioner-reported; varies by release. |
| Scheduled agent delivery | 25,000 lines, spreadsheet or comma-separated alike. | Oracle support note, confirmed by title. |
| Publisher online queries | Memory guard timeouts on long-running data sets. | Vendor-documented mechanism; thresholds release-dependent. |
| Bulk extract files | Output 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.
- 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.