My Oracle Support Banner

BI Publisher Increase maximum allowable nested table row count for reports Having Large Nested Tables (greater than 20000 rows) (Doc ID 2813802.1)

Last updated on OCTOBER 18, 2021

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.0 to 12.0 [Release 12.0]
Information in this document applies to any platform.

Goal

When attempting to generate BI Publisher reports with large output data the report will generate successfully, but with a limit of 20000 to the number of rows generated in the inner nested tables, and will include an additional spreadsheet titled “Errors” containing the following Error message:

The issue can be reproduced at will with the following steps:

1. Login to Bi Publisher

2. Navigate to Catalog 

3. Run the report which can export rows more than 20000

4. Observe the new excel tab Error for detailed log 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.