Oracle Forms

Hi All,

We are facing an issue in Oracle Applications across different seeded Oracle forms in the Release R12 wherein it seems the number of values being retrieved/fetched in the Lov's are being limited now.

This is causing issues in different forms as the user is trying to search the value but it says the search is limited by Maximum Limit of 10,000 values.

We could see that there is a Forms enviornment variable named FORMS_RECORD_GROUP_MAX which is currently being set to the value of 10,000.

We had couple of questions..

1. When i see the sql query of the record group to which the LOV is tied , i could see it fetches some 50,000 values,
but when i click the LOV it just displays the first 10,000 results only.

Could someone please let us know that where in the actual form code means where in the .fmb this forms enviornment variable is being used to limit the values of the record group query to 10,000 ..means how this is designed/being done in the R12 release of Oracle Applications.

I don't see the rownum being used in the sql query ..so where in the record group or how this forms eneviornment variable is getting trigerred when we click the Lov.

2.Is there any way we could override this selectively for a few seeded oracle forms wherein we need the user to see the entire result set of the Record Group Sql query..so that whatever they search they are able to find..

Could this be done because if we increase this forms env variable to a very high value then it would cause performance issue with the forms run time session consuming more of the memory.

So is there any way we could keep this variable to lets say 10,000 but for some lov's we could override this value to show entire query results...Is it possible...this is a very critical issue for our go live and we are looking for a qorkaround here...

3. Also currently even if the user gives the search criterion on the lov as "51%" to see only the values starting with 51 , the Lov still shows the first 10,000 values fetched by the Sql query in the record group.

Could someone please help us with these questions..as we are stuck because of this issue..

Regards
Sachin.