Columns that reference sys_choice can be created, but break when the list is edited.

Steps to Reproduce

  1. Navigate to Tables or to Dictionary
  2. Create a column of type reference with the referenced table being sys_choice
  3. Observe the column is created but it will not allow to be edited


Reference columns on sys_choice are not supported. This is because when a sys_choice entry changes, the entire list for that table.element are regenerated, and all of the choices get new sys_ids. Any columns that reference sys_choice need to be re-implemented so as not to point to the sys_choice table.

The unexpected behaviour when trying to edit was addressed in Jakarta by a UI Policy warning the administrator that Choice[sys_choice] is not a valid reference field target on a Dictionary form of a Reference field referencing the Choice table.


Related Problem: PRB713817

Seen In

Fuji Patch 13 Hot Fix 1
Helsinki Patch 3

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-21 11:41:19