Query Exceeds 200 Rows

If you get the error message "Query has exceeded 200 rows. Potentially more rows exist, please restrict your query" in a situation where you cannot restrict your query—for example, you have more than 200 Domains created, or more than 200 Applications in a Domain, or more than 200 Work Areas in an Application Area, or more than 200 object instances in a Work Area—then you may want to reset the Oracle Applications profile FND: View Object Max Fetch Size. This profile is set to 200 by default. See Setting Profile Values for further information.

However, use caution because changing this value affects all your Oracle Applications queries as well as all your Oracle Life Sciences Data Hub queries.