How do we increase the number of records that are retrieved? By setting the value for the profile option FND: View Object Max Fetch Size

How do we increase the number of records that are retrieved?

By setting the value for the profile option FND: View Object Max Fetch Size

How to maximum number of projects returned by the Project List is 200.

Go to System Administrator :

Profile option ‘FND: View Object Max Fetch Size’

To many people, the system profile option FND: View Object Max Fetch Size may sound ambiguous, but the value of this profile can be very useful in altering the user experience in Oracle Projects.

So, what does this profile option do? The best way to explain it is to use an example.

When one accesses the Project List in Oracle Projects, a table of projects is returned restricted by projects security, your search criteria, and where applicable, any criteria contained within a personalized view. The records in the Project List table are a sub-set of the View Object utilized by the page*. By default, the maximum number of projects returned by the Project List is 200. So what happens if your search criteria should return more than 200 projects? Well, you will only see the first 200 projects returned by the query. I have seen this default setting cause problems for users in the following Projects pages:-

Project List (as detailed above)

Work/Financial Breakdown Structures (where projects have more than 200 tasks)

Planning Resource Lists (where the are more than 200 resources in a list)

So how do we increase the number of records that are retrieved? By setting the value for the profile option FND: View Object Max Fetch Size we can determine how many records are fetched by View Objects in all of the E-Business suite applications. The profile value is set at site level to 200 by default, so it may need to be changed to a more appropriate value depending on local requirements. Please note that this profile option applies globally to self service pages, so if changing the default value it is best to set it at application level e.g. Projects

Another consideration to be made when setting this profile value is performance. The higher the value, the longer pages will take to load. It is therefore best to set the profile value sufficiently high enough to suit user needs, and not to an arbitrarily high value.