What is the current row limit of OTBI in Oracle Fusion?

Question

Hello Experts,

I’ve recently created an OTBI report to generate a customer list and managed to fetch around 500,000 rows.

Can anyone confirm the maximum row limit or suggest how much data we can realistically extract?

Any insights would be appreciated!

Regards,

Akhil

Nathan CCC · Answer

Ankil,

The limits on data is not just rows but columns and what data is in the values of the cells (bytes) and also by time and database resources used. For analysis in OTBI you have a default maximum query row limit of 75k rows of which a default max 500 can be displayed in a table online.  Other limits for pivot tables, tables with prompts and sections etc. For a report in OTBI you have a timeout maximum query response time for the data model is default 30 mins maximum 5 hours but there is also a limit on the bytes of data including the tags in the XML results. Also you have "guardrails" running on the database which will kill your session if you are using too many resources in the database no matter how many rows again. For bulk data extract the recommended solution is BICC cloud connector to extract data to CSV on object storage/UCM.