oracle apex 5 LOV Wrong number of columns selected in the LOV SQL bug

Question

I created a list of values in my APEX app, with query like below:

select JMENO as display_value, JMENO as return_value 
  from VW_DISTINCT_JT_PARTY
 order by 1

But when I execute the form whereI use the LOV for text field with autocomplete, it shows the error message

Anybody can help me out?

Answer 1

The LOV for a Text Field with Autocomplete item must contain only one column, which is used as lookup and display. When you think about it, it wouldn't make sense for it to work otherwise!