How to increase maximum LOV rows returned? (Doc ID 255729.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Time and Labor - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

LOV in OTL has maximum of 200 entries. Want to increase maximum LOV rows returned to a form.

Changes

 Due to potential severe performance issues, there is a set number of maximum rows returned. This is why reducing criteria is requested. You have the option to increase this value through Profile Options. The profile option is called 'FND: View Object Max Fetch Size' and is defaulted to 200. Be aware, that your performance will suffer as a very long LOV will consume a lot of CPU time. Reducing the search criteria is the preferred and recommended way to display your LOV's If you opt to increase the maximum rows returned, there will be performance issues the user will encounter as a result. The solution to these performance issues will be to restrict the maximum number of rows.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms