I just noticed that if I click on a table in the Schema Browser, then select the “Used by” tab in the RHS, it doesn’t show any objects, even for a table which (in my case) is used by a package, which in turn is used by other packages.
It seems to have broken with 12.7, and is still broken in 126.96.36.199 beta. With 12.6 GA, it works fine.
I studied the spooled SQL from both 12.6 and 12.7, and it looks like 12.7 somehow gets the object id of the table changed to something else along the way.
I can see the query which finds the object id:
Select created, last_ddl_time, object_id, status
where object_name = :nm
and object_type = :t
:nm(VARCHAR,IN/OUT)=(my table name)
It is the same in both versions. If I execute that myself, I get the correct id (100833 in my case).
Later, the following query, also the same in the two version, should give the dependency tree:
Select to_char(object_id) object_id, to_char(referenced_object_id) referenced_object_id, to_char(level) “LEVEL”
from (select object_id, referenced_object_id
where referenced_object_id <> object_id) pd
connect by prior pd.object_id = pd.referenced_object_id
start with pd.referenced_object_id = :ObjID
But in 12.7, the :ObjID is 84534 (as shown here), while in 12.6, it uses the correct one, 100833.
I don’t seem to have any object at all (of any type) in USER_OBJECTS with id 84534 (nor, for that matter, in ALL_OBJECTS when loggod on as SYS).