My Oracle Support Banner

Initial Query Not Respecting 'maximum Rows Per Page' Report Attribute On Apex 18.1 Interactive Report (Doc ID 2476450.1)

Last updated on FEBRUARY 18, 2021

Applies to:

Oracle Application Express (APEX) - Version and later
Information in this document applies to any platform.


On : version, MICC Transfer to TSC

Initial query not respecting 'maximum rows per page' report attribute on apex 18.1 interactive report

Query back %1% on a reference and you will notice in bottom right corner it says records 1-50.
Click the "Next" arrow and it refreshes the first page and now displays records 1-15. It changed from 1-50 to 1-15 and stayed on the first page.
Our 'maximum rows per page' attribute has been set to 15

It only seems to respect this when the query has been refreshed, eg next page


 APEX upgraded from 5.1.2. 


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

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