Where-used Top Level Latest Released Revision Only Advanced Search Is Showing Inaccurate Results (Doc ID 2820509.1)

Last updated on NOVEMBER 11, 2021

Applies to:

Symptoms

Where-used Top Level Latest Released Revision Only advanced search is showing inaccurate results.

The item appears in the results of the Where-used Top Level Latest Released Revision Only advanced search but, does not return in the Where-used All Levels Latest Released Revision Only advanced search.

The child item does not appear on the BOM Explosion Report.

EXPECTED BEHAVIOR
Expect the Where-used Top Level Latest Released Revision to not return the item as it is not returned in both the Where-used All Levels Latest Released Revision Only & the BOM Explosion Report.

STEPS
1. Login to Web Client

2. Run the following advanced search:

Items Parts Where-used Top Level Latest Released Revision Only
Number Equal To P001

.

Results shows ---> MDF0000645 ---> This item should Not be showing up!

.

27 Rows Returned

3. Run the following advanced search:

Items Parts Where-used All Levels Latest Released Revision Only
Number Equal To P001

.

*Note:  MDF0000645 is Not shown

.
745 Rows Returned

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.