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