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

 

Error while querying workflow notification to view the history.

Solution:

This is the expected behavior. The application throws the warning message 'Query has exceeded 200 rows. Potentially more rows exist, please restrict your query.' , when the process crosses the 200 row limit which is being set in profile

FND: View Object Max Fetch Size.

The profile FND: View Object Max Fetch Size can be changed to a higher value.  However, as per Oracle Applications guidelines increasing the value can have a performance impact.

1. Go into the responsibility: System Administrator (or equivalent).
2. Navigate to Profiles > Query the profile FND: View Object Max Fetch Size at Site, Application (Oracle Configurator)
and User Level
3.Change the value from 200 to a higher value (i.e. 250, 300 etc..).
4. Log out of the Application and back in.
5. Please retest the issue.
6. If the issue is resolved, please migrate the solution as appropriate to other environments.