My Oracle Support Banner

OLM: Warning Message Saying 'Query has exceeded 300 rows' on Catalog Tab in Learner Self-Service (Doc ID 395011.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Learning Management - Version 11.5.9 and later
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
When a learner logs in and accesses the Catalog tab a warning message stating

ERROR
'Query has exceeded 300 rows. Potentially more rows exist, please restrict your query.'

-- Steps To Reproduce:

1. a user logs on with learner self-service responsibility
2. the message above is displayed
3. log as system administrator and changes the profile option :
     'FND: View Object Max Fetch Size'  set to 500
4. the user logs back on with learner self -service responsibility and the error message remains unchanged.(still with 300)

Changes

A setup has been changed.

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.