Amazon Contextual Product Ads

Wednesday, 25 May 2011

How to get rid of “Query has exceeded XXX rows” error message in OAF page


If you have inside your framework page ViewObject that brings o lot of data you probably will get at some point “Query has exceeded XXX rows” message”

In my case it was a dropdown list that displayed a list of EBS users


After digging into View Object definition for about an hour and finding nothing I finally found that limit value controlled by EBS profile called “FND: View Object Max Fetch Size”. I put the value of 6000 and the message disappeared


No comments:

Post a Comment