CSXSRISR.FMB NEEDS FILTER BEFORE DISPLAY = YES ON LOV'S

(Doc ID 2322101.1)

Last updated on OCTOBER 27, 2017

Applies to:

Oracle Customer Support - Version 12.2.5 and later
Information in this document applies to any platform.

Goal

The FORMS_RECORD_GROUP_MAX = 30,000, the form is correctly
enforcing this parameter. However when restricting the query with a value + %
it is still only retrieving values that are present in the first 30,000
records.

For example if there are 35,000 records and the 30,001 record starts with XX
a query on XX% would not return any records. So all records after the 30,000
record are not able to be retrieved in the LOV.

How can this be resolved?
 

Solution

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