Can't see a table name in the "Table" field picker on UI action or client script form (in any application scope but Global) - Support and Troubleshooting

Can't see a table name in the "Table" field picker on UI action or client script form (in any application scope but Global) Issue  Overview This article focuses on the scenarios where a certain table name doesn't show up in the "Table" field picker on either a UI action form or a client script form. (in any application scope but Global)

Affected Versions/Releases Kingston, London and Madrid.

Example and Cause Switch to any application scope but Global. Let's say "task" table is not visible on the Table field picker when you create a UI action or a client script. Navigate to "System Definition" > "Tables & Columns" in the application filter navigator. Look for "Task [task]" table entry and select it under "Or, select a table to browse its columns and indices". Click "Edit Table" button at the bottom. A form view opens on "sys_db_object" for this table. Under the form section "Application Access", look for field "Accessible from". (Should be "All application scopes" by default) Right-click on the header of the form and go to "Show XML". A pop-up opens and look for the values in fields "actions_access" (for "Allow UI actions") and ""client_scripts_access" (for "Allow client scripts"). Their values should be by default "true". If any of them has value "false", that explains why this table doesn't show up in the respective picker. These fields are unfortunately not visible on the form for "admin" users, implying that they are never supposed to be touched/modified.

If you see any of the values not matching with the respective fields, kindly import an OOB update set of this same record from one of your personal development instance(s) (PDI) and that should fix this issue.

Additional Information For table administration kindly refer our product documentation (Madrid): https://docs.servicenow.com/csh?topicname=c_TableAdministration.html&version=latest