Getting "ORA-01791: not a SELECTed expression" when selecting unified audit policies in tree mode (4376766)

1. Connect to 19c or newer
2. Open Schema Browser and change to treeview mode
3. Expand Unified Audit Polices

WORKAROUND 1

 Use schema browser in drop-down mode instead of treeview

WORKAROUND 2

In Treeview mode, Instead of expanding, right-click on Unified Audit Polices and choose “Filter Unified Audit Policies”
Check “Custom Filter”
Check “View/Edit Query Before Executing”
Click OK
A Dialog appears.
Change the query to the following

Select distinct UAP.policy_name as object_name, o.created, o.last_ddl_time
from   sys.DBA_OBJECTS o, SYS.AUDIT_UNIFIED_POLICIES UAP
where  o.owner (+) = 'SYS'
and    o.object_name (+) = UAP.policy_name
and    o.object_type (+) = 'UNIFIED AUDIT POLICY'
order by 1

STATUS

Issue fixed in Toad for Oracle 2024 R2 - v24.2.275.4664 (Released on Nov 4th 2024).

The latest version of Toad can be downloaded here:

Windows 

Mac