Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
We have upgrades our forms from version 10 to 12c.
In the code we do :
rg_id := create_group_from_query(rg_name,lv_text);
temp := populate_group(rg_id);
WHERE rv_domain = ''TYPADR''
AND rv_low_value IN (SELECT sub_cd
WHERE boom_cd = ''ADRES''
AND hfd_cd = '''||lv_type_hfd_cd||''')
AND rv_low_value NOT IN (''WOFF'',''WCORR'',''WBTW'',''RR'')
ORDER BY rv_meaning';
==> result of this query is a list of value :
OVMB Correspondenten adres
SVMB Correspondenten adres
If we leave out the 'ORDER BY rv_meaning' the lov is not ordered , with 'ORDER BY rv_meaning' the lov is ordered by values starting with 'O%' are not ordered by the second character.
I also tried ordering by 'ORDER BY UPPER(rv_meaning)' ; this gave the same result.
Is this a bug in forms12c?