Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 47 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 286 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 109 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
What is the maximum number of rows that an OTBI report can fetch correctly
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.
Best Answers
-
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.
0 -
@Arnab Das , Welcome to the Oracle Analytics Community!
As mentioned above there is a definitely limit in terms of maximum rows as well as there are few ideas already logged to increase it.
In terms of the issue reported, it will be best to debug it and understand that there are few options how to triage it. I am going to put few options below, please see what fits your need
Split your OTBI report into smaller filtered runs
E.g., break by date range or statuses so each query stays under threshold.Scheduled exports (complex OTBI to email/BI Publisher)
Scheduling and background processing sometimes handles more than interactive runs.Use BI Cloud Connector (BICC) for bulk extracts
Best practice when you want ERP-level data out of Oracle Fusion into external systems or flat files for reconciliation/warehouse.Hope it helps!
0
Answers
-
Hi @Arnab Das,
Additionally, please take a look into the following Oracle Note:
Hope this help.
Thank you.
0 -
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.
0 -
Also, this forum is specifically for the Oracle Analytics, OTBI, BIP, FDI etc in terms of tools and it is okay to ask questions which are more related to the tools/technology etc, you should put the question in the Oracle Customer Connect for the Fusion Product related functionality.
For example, in terms of Payables, Invoice Amount etc, please use Payables, Payments & Cash Management — Cloud Customer Connect. Hope it helps!
0 -
Thank you @Bhaskar Konar @RVohra for your inputs. Much appreciated. I have voted in for the idea as well.
1 -
0