What is the maximum number of rows that an OTBI report can fetch correctly

Arnab Das

I am trying to write an OTBI report from Fusiuon on Payables and I am seeing some incorrect values on invoice amount and few other fields. I am not sure if it is because the total number of records is higher. Is there an Oracle specified limitation on OTBI report data vloumes.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/28044/what-is-the-maximum-number-of-rows-that-an-otbi-report-can-fetch-correctly

Hi @Arnab Das,

Welcome to the Oracle Analytics Community!

OTBI analyses generally have a default maximum limit of 75,000 rows for retrieval. If you are using excel it will be 25K but 75K can be retrieved through CSV format.

Hope this help.

Thank you.

Bhaskar Konar

Hi @Arnab Das,

Additionally, please take a look into the following Oracle Note:

https://docs.oracle.com/en/cloud/saas/sales/fasqa/what-are-the-analysis-and-report-limits.html

Hope this help.

Thank you.

Bhaskar Konar

Hi @Arnab Das,

Here's an idea from the IdeaLab

OTBI Analysis fetches starting 75001 rows only -- how to increase the limit — Oracle

Feel free to vote / comment.

Thank you.