Descriptive flexfield saved data is not appearing on UI
Position descriptive flexfield value has been saved in HR_ALL_POSITIONS_F table but not appearing on UI.
Have created a Position Descriptive flexfield of type number. which is a list of value. Value set is based on below query
select hapf.ATTRIBUTE_NUMBER1 + 1
from HR_ALL_POSITIONS_F hapf where
TRUNC (SYSDATE) BETWEEN hapf.effective_start_date AND hapf.effective_end_date AND hapf.ACTIVE_STATUS = 'A'
and hapf.ATTRIBUTE_NUMBER1 = (select max(hapf1.ATTRIBUTE_NUMBER1) from HR_ALL_POSITIONS_F hapf1 where TRUNC (SYSDATE) BETWEEN NVL ( hapf1.effective_start_date, SYSDATE) AND NVL ( hapf1.effective_end_date, SYSDATE) AND hapf1.ACTIVE_STATUS = 'A'