Sizing Business Intelligence Publisher Components To Handle Large Volumes of Data with E-Business Suite XML Publisher / BI Publisher
(Doc ID 1630732.1)
Last updated on NOVEMBER 16, 2023
Applies to:
Oracle Concurrent Processing - Version 12.2.4 to 12.2.4 [Release 12.2]BI Publisher (formerly XML Publisher) - Version 10.1.3.2.0 to 11.1.1.7.x [Release 10.1 to 11.1]
Information in this document applies to any platform.
Purpose
Provide a consolidated reference for all sizing issues with various technology components of Oracle E-Business Suite and BI Publisher.
Scope
Details
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Purpose |
Scope |
Details |
Oracle database sizing recommendations for BI Publisher |
Recommendations to handle large volumes of data |
1. Insure the latest ATG RUP and XDO patchsets has been applied in your environment for better report processing performance. |
2. Set the heap size value to handle large reports while using Oracle BI Publisher. |
3. Increase the number of Output Post Processor (OPP) to avoid/overcome the "Out of Memory Exception" error. |
4. Enable the scalable feature |
5. Select a temporary file location on your concurrent processing node to avoid/overcome the "Out of Memory Exception" error. |
6. Configure the Output Post Processor's JVM. |
Recommendations on Output Post Processor (OPP) Tuning |
1. Prevent timeout errors by setting recommended OPP related profile option values |
2. Improve performance by tuning the Output Post Processor (OPP) |
Recommendations on Client Side Tools - Excel limits |
1. Be sure to understand Microsoft Excel specifications and limits (See <Note 1469264.1>) |
2. Increase the default amount of 80 characters stored per row to increase the data size to around 20MB (See <Note 889482.1>) |
3. Use Excel binary output files to avoid the large verbose XHTML format output. |
References |