My Oracle Support Banner

CSXSRISR.FMB NEEDS FILTER BEFORE DISPLAY = YES ON LOV'S (Doc ID 2322101.1)

Last updated on DECEMBER 05, 2019

Applies to:

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

Goal

With FORMS_RECORD_GROUP_MAX = 30,000, the Service Request form form (CSXSRISR) is correctly enforcing this parameter. However when restricting the query with a value plus % 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.