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:

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

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