We have some custom lookups and since the upgrade to 16.1.0 the value displayed on the grid is incorrect.
Query behind the lookup
SELECT
@SELECT:0:ID@,
@SELECT:X.INDICADOR:INDICADOR@
FROM(SELECT
T.ORDEN ORDEN,
T.INDICADOR INDICADOR
FROM(SELECT CASE WHEN (Z_EXAMPLE(NVL(@WHERE:PARAM:USER_DEF:INTEGER:ID_CARTERA@,0),'CARTERA','BLOQUEANTE') = 0) THEN 'Blocking Alerts'
ELSE 'NO Blocking Alerts'
END INDICADOR,
1 ORDEN
FROM DUAL
UNION
SELECT
' ' INDICADOR,
2 ORDEN
FROM DUAL
)T
ORDER BY T.ORDEN
)X
WHERE @FILTER@
AND ROWNUM = 1
The query states if VALUE 0 then display 'Blocking Alerts'
The DB shows a value of 0
The object instance details show the appropriate message
The Details Flyout on the grid show also the appropriate message
But the column on the grid view shows the wrong message: 'NO Blocking Alerts'
In 16.0.1 this was not an issue
Few changes related to lookup performance improvement (caching) went into 16.0.3.
There is a feature toggle 'PARAMETERIZED_LOOKUP_OPTIMIZATION' to enable/disable Performance related changes.
SELECT * FROM cmn_features WHERE code = 'PARAMETERIZED_LOOKUP_OPTIMIZATION'
Value is set to 1. Update it to 0
update cmn_features set enabled = 0 where code = 'PARAMETERIZED_LOOKUP_OPTIMIZATION'
Restart the services afterwards