Unable to Create a Report by selecting Data Source as a Database View - Support and Troubleshooting

Unable to Create a Report by selecting Data Source as a Database View Issue A database view is not listed in the data source.

Facts Limitations Database views cannot be created on tables that participate in table rotation. It is not possible to edit data in the database view output. Database view tables cannot be added as a data preserver in clone requests. You can reference a table or database view from a different application scope in a Table Name field. However, if the field belongs to a table that extends sys_metadata, the table or database view must belong to the same application scope as that table. ACLs and database views You do not need to create ACLs on fields in the view. The system honors contextual ACLs (ACLs with a condition or script) that exist on the underlying table. Non-contextual ACLs (ACLs with only role checks) are still honored just as with previous releases. To require explicit read ACLs be added to the database views, set the glide.security.expander.view.legacy property to true. On upgraded instances, add this system property and set it to true. You can still create additional ACLs on the database views. These ACLs are evaluated last and are always honored. Release All releases.

Cause Database views are listed under the Table not Data Source.

Resolution Please select the table as a Data Source when you navigate Reports - create new. If you are creating from the "sys_report_source" table then make sure to select the same scope as your database is in. Then click on the new button, you will see the database view listed.