My Oracle Support Banner

The Number of Records Returned (xxx) Has Exceeded the Maximum Configured Limit Of 1000 (Doc ID 1352926.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Global Trade Management - Version 6.1.5 and later
Information in this document applies to any platform.

Symptoms

If the number of child records exceed 1000 on any view or edit screen, these child records will not be displayed on the screen. As an example, if an invoice has more than 1000 lines, the invoice view and invoice edit screens will not display any rows for the invoice line items  and will throw the below message. This number (default 1000) is controlled by a new app server property, glog.query.limit.max.

The number of records returned (xxx) has exceeded the maximum configured limit of 1000.
NOTE: xxx is the number of returned records.

Changes

 

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


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