This page handle the issue of duplicate objects displayed in the search box results of CED

For example you will get the following result

Step by Step scenario

1. Run analysis and take snapshot
2. open CED
3. Search for an object

Action Plan

To troubleshoot this issue, you need the following Relevant input

1. Check if the full name and type of object is different, if it not then this is an expected behavior, else go to the next step
2. If you get two objects with same type and name but different object_ids then check the GUID of these objects using the page SQL Queries - CAST Knowledge Base - Queries on objects - How to get object GUID 
3. If the GUID is different then it is expected behavior, if the GUID is same then follow the page SQL Queries - CAST Knowledge Base - Queries on objects - How to get and delete GUID of duplicate objects in KB
4. If your issue is still not resolved after applying the above steps or if your case is something different then please contact CAST Technical Support and provide the Relevant input. 

Relevant input

1. Sherlock export with the following options: Export Logs (feature checked by default), Export Configuration files (feature checked by default), Export CAST Bases, Export source code
2. Screenshot showing the issue

Check if the full name and type of object is different

Please run the following query on the local schema:

SELECT dss.object_name, 
       dss.object_id, 
       t.typnam 
FROM   dss_objects dss 
       JOIN typ t 
         ON dss.object_type_id = t.idtyp 
WHERE  object_name = <object_name>

For example:

SELECT dss.object_name, 
       dss.object_id, 
       t.typnam 
FROM   dss_objects dss 
       JOIN typ t 
         ON dss.object_type_id = t.idtyp 
WHERE  object_name = 'AR_TRANS_ENTRY_CORE_PKG'

Query result:

AR_TRANS_ENTRY_CORE_PKG ; 2048608 ; CAST_Oracle_PackageHeader 
AR_TRANS_ENTRY_CORE_PKG ; 2076228 ; CAST_Oracle_PackageBody 

Here we can see that there are two objects with same name but one is a PackageHeader and the other is packageBody. So they are not duplicate objects.

But if you get result like this then you need to goto next step

ABC_CORE_PKG ; 2234 ; CAST_Oracle_PackageHeader 
ABC_CORE_PKG ; 2235 ; CAST_Oracle_PackageHeader

Ticket # 8007