When you want to select a User to populate an "Assigned To" field, you normally expect a list of users from the assignment group already entered. No users may be listed, even though you know users are members of that group, and the Assigned to field is set as dependent on the Assignment Group field in the dictionary.

With Session Debug turned on for SQL Debug, while opening the search popup, you may see "SELECT ... FROM sys_user WHERE ..." is including an unexpected field in the WHERE clause from the sys_user table.


There is a good chance that the following known problem is the cause:

PRB705148 A reference qualifier to sys_user_group breaks if more than one field on sys_user references sys_user_group

Article Information

Last Updated:2020-06-30 02:17:26