oracle.jbo.InvalidOperException: JBO-25011

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

2 thoughts on “oracle.jbo.InvalidOperException: JBO-25011

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s