if you get the following error when you set Access Mode“=”Range Paging” to avoid all the records to be fetched and cached in ADF BC

oracle.jbo.InvalidOperException: JBO-25011: Rowset _LOCAL_VIEW_USAGE_model_EmployeesView_DepartmentsView1_0 is forward only

The “ListRangeSize” property of the List of Value is always set to “-1”  contradicting that

• you are using the “Range Paging” “Access Mode”, you fetches a limited number of records for the View Object
• you are using the “ListRangeSize” = -1 fetches ALL the records for the List Of Values

so to avoid the above error increase the ListRangeSize property