Flexfield Value Selection Issue – Value Always Defaults to First value on the list

Summary:

Hi All,

I have configured a flexfield with a table based value set. I am encountering an issue where the field consistently defaults to the first value in the list, even after selecting a different option.

Value set details

FROM Clause: HR_ORG_UNIT_CLASSIFICATIONS_F HOUCF, HR_ALL_ORGANIZATION_UNITS_F HAOUF, HR_ORGANIZATION_UNITS_F_TL HAUFT

Value Column Name: TRIM(SUBSTR(HAUFT.NAME, INSTR(HAUFT.NAME, '-') + 1))

ID Column Name: HOUCF.STATUS

WHERE Clause:

HAOUF.ORGANIZATION_ID = HOUCF.ORGANIZATION_ID
AND HAOUF.ORGANIZATION_ID = HAUFT.ORGANIZATION_ID
AND HAUFT.LANGUAGE = 'US'
AND HAOUF.EFFECTIVE_START_DATE BETWEEN HOUCF.EFFECTIVE_START_DATE AND HOUCF.EFFECTIVE_END_DATE