Query page does not show specific record
EBS 12.2.10
Database 19c (19.18.0.0.0)
JDeveloper 10.1.3.5.0
I have a custom OAF page in which I am providing a unique value in search page lov input. Problem is it fetching other records as well.
For example if I provide 1 in query page, then it is showing all records which start from 1 like 11, 12, 16, 17 etc. I also appended a Record ID attribute but when I click on Go, it disappears and shows all records. This field (Transfer Number) is VARCHAR2 type in database.