Team Coding Dashboard reports incorrect object names
In v12.6 there is an issue with Team Coding when a very specific set of events that need to have occurred in a database that lead to Oracle assigning a database object the same Object_ID as an older object that had since been deleted from the database.
Tables 'tc_objstatus' and 'tc_objstatus_vcs' contain the information about Team Coding database managed objects. When an object already registered in these tables changes its status from "checked in" to "checked out" or viceversa, an appropriate update is issued.
UPDATE TOAD.TC_OBJSTATUS SET PSL_CHECKED_OUT = 'Y', PSL_CHECKED_OUT_BY = 'GEN$D', PSL_CHECK_OUT_TIMESTAMP = SYSDATE, PSL_COMMENTS = 'just a test' WHERE
PSL_OBJECT_ID = 90709
As can be seen, the pls_object_name is not updated. This leads to an issue when an object has the same object_id than another object in the past, Team Coding reports the old object name instead of the current one.
This select statement shows potential objects that suffer this issue:
from toad.tc_objstatus tco, dba_objects d
Waiting for fix in a future release of Toad for Oracle