Thursday, July 08, 2010

Query has exceeded 200 rows. Potentially more rows exists, please restrict your query


If any OAF page gives the above error, then you may try increasing value of profile option FND: View Object Max Fetch Size (VO_MAX_FETCH_SIZE). This should not be increased too much becuase it wil have some performance implications. Instead of increasing it's value, it might be better to identify the problem query that returns more than 200 rows and fix it.\

No comments:

Post a Comment