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 MAY 07, 2019

Applies to:

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

Symptoms

On : 18.1.0.00.45 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

Changes

 APEX upgraded from 5.1.2. 

Cause

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
Symptoms
Changes
Cause
Solution
References


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