A field choice that is unchangeable even though the choice is not available in choice list

[ChuanYanF]

Dear experts,

I have encountered a problem which is during data migration, some data values for choice fields are not matching with the existing choices hence it will create another new choice. But when I deleted the wrongly added choices fields and try to change to the existing choice fields that I configured myself in the system, the field choices will not get updated and will maintain the choices from the data migration even though the choice is not in the choice list under the dictionary entry for the field. Like the screenshot below, the choices that are wrongly imported is coloured in blue, and the correct ones are black in colour. How do I fix this situation?

[Kieran Anson]

Can you share your script that you used to update the value? And also a screenshot of the sys_choice values showing the display value and internal value

[AnveshKumar M]

Hello @ChuanYanF 

Ideally it should work. Have you ✅ the "Run Business Rules and Engine" field?

[ChuanYanF]

Hi Anvesh,

Thanks for the reply, but I think the problem here is the max value is only 40 so it does not matter whether I change the value using data management or not.