InvalidOperException: JBO-25011: Rowset <name> is forward only For a LOV In Range Paging Access Mode

(Doc ID 1225174.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle JDeveloper - Version: and later   [Release: and later ]
Information in this document applies to any platform.


You are developing an ADF Faces/BC application in JDeveloper
The application should include List of Values (LOVs) returning a huge amount of records.
As explained in the ADF Developer's Guide, "39.1.5 Efficiently Scrolling Through Large Result Sets
Using Range Paging
" you should use the "Access Mode"="Range Paging" to avoid all these
records to be fetched and cached in ADF BC.

However, when doing so, you are unable to run your application:; you get the following error:
oracle.jbo.InvalidOperException: JBO-25011: Rowset _LOCAL_VIEW_USAGE_model_EmployeesView_DepartmentsView1_0 is forward only.
at oracle.jbo.server.ViewObjectImpl.validateRangeSizeForRangePaging(
at oracle.jbo.server.ViewRowSetIteratorImpl.setRangeSize(
at oracle.jbo.server.ViewRowSetImpl.setRangeSize(
at oracle.jbo.common.AbstractListBinding.<init>(
at oracle.jbo.server.ListBinding.<init>(


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