Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Too many matching records found. Specify additional criteria to limit the number of records

I have a LOV in the UI. Upon clicking it, it shows the values in it. Upon selecting a particular value in that LOV, the following error pops up saying that:
"Too many matching records found. Specify additional criteria to limit the number of records."
This happens only for the first value that I am selecting from the LOV. If I select a different value from the LOV again, this error doesn't appear.
Please help! Thanks in advance.

Comments

Timo Hahn

User, tell us your exact JDev version, please!
You normally get this message if the VO or collection behind the LOV has duplicate entries. If you now select one of the duplicate values you get this error as the e.g. selectOneChoice can only select one.
If you use a VO behind the LOV check if you have selected a primary key in the VO and rewrite your query that it returns unique values.

Timo

User508065-Oracle

JDev version is 11.1.1.9.0
Also, the VO behind the LOV has a primary key defined.

Timo Hahn

And the query for the LOV returns unique values?
If yes, do you have a reproducible test case?
Timo

User508065-Oracle

Yes, the issue can be reproduced on one of our Fusion env. I think it will be easier to show you via a zoom if possible.

Timo Hahn

Sorry, this is a public forum and we should keep it this way. Zoom is not an option here as it would not address everybody.
I'm not the only member that might be able to help you solve the problem.
Timo

1 - 5

Post Details

Added on Jul 22 2021
5 comments
583 views