Offer - Warning: Query Has Exceeded 1000 Rows. Potentially More Rows Exists, Please Restrict Your Query
(Doc ID 2779965.1)
Last updated on JUNE 04, 2021
Applies to:Oracle Trade Management - Version 12.2.6 and later
Information in this document applies to any platform.
On : 12.2.6 version, Offers
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.
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
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