Oracle fusion gives many options to approach this and this can cause confusion.
My first approach some years ago was to use the exposed task flows of the BPM worklist:
This is mostly because i am up to my head with new projects, BPM, SOA, BI and other fusion middleware technologies. Also because:
By default when you type a value in an input list of values the query is executed always with the LIKE operator.
This is very annoying for users that do heads-down data entry.
Also if the field is a number executed query force full table scan causing performance issues.
We just need the option to disable auto-suggest behavior (on design time) so that the query is executed with '=' operator and the LOV does not open when the value entered is valid.