11G Can We Limit The Number Of Rows To Be Displayed In BI Publisher Reports? (Doc ID 1533256.1)

Last updated on OCTOBER 04, 2016

Applies to:

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

Goal

Does Oracle Bi Publisher have an option to limit the number of rows any query should fetch from the database from the system level at any one time? Something similar to the row limit in OBI Enterprise Edition Answers, which defaults to 6500.  Option to limit number of rows queries can fetch from the database.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms