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 laterInformation 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 |