How to avoid duplicate values in a LOV on a adf input table

817 Views Asked by At

I have a input table with a LOV field. Values in the LOV are coming from a VO which is join based VO. So key attributes are from all the Eos which are joined. My LOV is defined over one of the key attribute of a EO. So i am getting duplicate values in the LOV due to joins. What can be fix for this ?

1

There are 1 best solutions below

0
On

Did you try introducing the "Distinct" into your query? https://www.techonthenet.com/oracle/distinct.php