How can I force FND_FLEX_VALUES_TL to update to the latest values for Description?
After updating the Name of Department from
'60508-East Operations-508'
to
'60508-Operations-508'
via Setup & Maintenance > Manage Departments > Update > Submit
The FND_FLEX_VALUES_TL does not update with the new name that comes in the Description column.
This is a query I am using to check the table values vs what is shown in the UI itself
select
hlafv.INTERNAL_LOCATION_CODE as LOC_CODE,
hlafv.DESCRIPTION as LOC_NAME,
haoufv.ATTRIBUTE6 as DEPT,
ffvt.DESCRIPTION as DEPARTMENT_NAME,
ffvt.LANGUAGE
from HR_LOCATIONS_ALL_F_VL hlafv
left join HR_ALL_ORGANIZATION_UNITS_F_VL haoufv
Tagged:
0