Team Coding Dashboard reports incorrect object names (4241164)

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.

For example:
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:

select d.object_id,d.object_name,d.object_type,d.owner,tco.psl_object_name,tco.psl_object_type
from toad.tc_objstatus tco, dba_objects d
where d.object_id=tco.psl_object_id
  and d.object_name!=tco.psl_object_name
================