My Oracle Support Banner

Offer - Warning: Query Has Exceeded 1000 Rows. Potentially More Rows Exists, Please Restrict Your Query (Doc ID 2779965.1)

Last updated on AUGUST 14, 2023

Applies to:

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

Symptoms

On : Offers

ACTUAL BEHAVIOR
---------------
Offer - Warning: Query has exceeded 1000 rows. Potentially more rows exists, please restrict your query.

When opening an offer that is using the custom attribute type, users are reporting seeing a warning message. When reviewing the product lines, there are only 6 lines. The warning message indicates that there are more than 1000 lines which would exceed the profile option FND: View Object Max Fetch Size = 1000 setting. Message then disappears once user scrolls down in offer and comes back to top of screen.

Steps:
----------
Trade Management > Trade Planning > Offers
Quick Find, search for offer
Select the offer
Page showing Warning message.
  --Query has exceeded 1000 rows. Potentially more rows exists, please restrict your query.

Profile: FND: View Object Max Fetch Size = 1000

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
References


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