The choice list value is disappearing in production

[reeba1]

Hello,

There were 5 options in the dropdown list for the field "waiting for". But one of the options disappeared suddenly. I added it again through "configure choicelist", then this value appeared, but after few days, another option disappeared. The disappeared options do not appear even in "show choice list"

The issue is happening only in production. In dev and test instances it is working fine.

Can someone please help me to find the root cause?

Regards,

Reeba

[Ankur Bawiskar]

Hi Rebba,

Are you doing some type of data load on that table and have mapped that choice field?

Also check whether any schedule job is making it inactive from script

Regards

Ankur

[reeba1]

Hi Ankur,

The choice is not visible in the "show choice list". If it was inactive, it would shown as inactive.

But here, it has just disappeared.

What else do you think i should check?

Regards,

Reeba

[Varsha Jadhav1]

Hello Rebba,

It might be possible that you have given same value for different choices, so it would prefer first choice

eg. select department

find below attachment:

[Manish Vinayak1]

Hi Reeba,

• If the choices are still there and are in inactive state (I see you mentioned you can't see that after clicking on show choice list, but still including the possible steps to debug), bring the updated by / updated on field to see who made it inactive.

• If the choices are getting removed, navigate to System Definition > Deleted Records, and try to look for that record, to see who deleted it and when. You will need to find out the record deleted from "sys_choice" table.

Once you have figured out by whom and when they got deleted, you can try to figure out the root cause if it happened because of a manual load, or was it a scheduled import / job, etc.

Hope this helps!

Cheers,

Manish