You can use the Advance Search functionality to achieve this. Basically, you want an Orphan Parts report. Refer to the attached screen shot for details.
Alternatively, you can configure a report using the same search query as well.
Hope this helps.

The above search query will give you the list of parts that does not have both Parent parts as well as no Child parts.

Thanks., this is what I have been looking for, but unfortunately in our install (9.3.1.1) WhereUsed is not searcheable and I have tried to go in under Classes>Items>Documents/Parts but cannot make any of the WhereUsed Tab Attributes available for search.

Any way to manage this or is it something that only became available in later versions?

We had a similar issue in 9.3.1 but upgraded to 9.3.3 last year so now can replicate Viswanath approach.

Its not exactly standard functionality, but we got round it before the upgrade by querying the database directly with something like

SELECT  i.item_number,
                    i.description,
                    rr.rev_number
FROM    item I
JOIN        released_rev rr ON i.id = rr.item
WHERE  i.class = 10000
AND         i.item_number NOT IN (SELECT bom.item_number FROM bom)
 AND        i.id NOT IN (SELECT bom.item FROM bom);

Hope that helps.

The reason could be because of Privilege setting (Discover Privilege). Try the above as an admin user and I am sure this works on the previous releases of Agile as well.

Thanks, Adrian. May have to try this as a last resort – but was really hoping to use standard system functionality until upgrading to 9.3.4 this summer.

Viswanath – thanks again for your prompt reply.

I logged in as admin and get the same result. 

Looking at ‘Discovery’ privileges there does not seem to be anything controlling down to attribute level – discovery controls objects. Or am I missing something?

I could never figure it out via searches on 9.3.1, and asked a similar question on the oracle community agile page on the support site. I got directed down the SQL script route by an Oracle staff contributor.

See document “What’s New in Agile PLM White Paper” for release 9.3.3, page 14:

5.12 Enable New Search and SDK Methods to Identify Parts Without Parents (Orphans)

During a product development cycle, the product team can be creating many new part numbers for their designs. At the end of the cycle analysts often want to learn which

parts were never used. This feature allows analysts to perform an advanced search for Where Used Item Number, for latest or all revisions, is Null. Analysts can then

obsolete or recycle the part numbers that were never used in a design.

Tai, the Originator of this query is using an earlier release of Agile 9.3.1. The question is, can we get this working in 9.3.1?

He is pointing out it was introduced in 9.3.3 so its not available in 9.3.1.1 which was my experience. So he has to  wait until he upgrades or do it via SQL direct in the DB.