My Oracle Support Banner

Run Where Used Report Window Displays Items Type Field to Display All Item Subclass by Default (Doc ID 2368383.1)

Last updated on JANUARY 24, 2022

Applies to:

Oracle Agile Product Collaboration - Version and later
Information in this document applies to any platform.


Run Where Used Report window displays all Item subclass by default on Items Type field even if it subclass is disabled
or user does not have any read or discover privilege for that subclass.

How to limit the subclass of Items Type field to not appear from this window?


  1. Create a new subclass : InactivePart with Enabled : No
  2. Create a new Criteria

    Name : yoPartSubClass
    Object Type : Part            <--- subclass: Part

  3. Create a new privilege and assign criteria for both yoPartSubClass

    yoDiscoverPartSubClass    <---- Discover Privilege
    yoReadPartSubClass         <---- Read Privilege
  4. Create new Role : 0228_changeanalyst and include privilege

    Run Product Reports

  5. Assign role: 0228_changeanalyst to user : user1
  6. Login to Web Client in user1
  7. Go to Reports and Analytics > Standard Reports > Product Reports > Where Used Report
  8. Click Execute button
  9. Click Next
  10. Select Item for the Report : p00006
  11. Click Next
  12. Item Types field displays all Item Subclass


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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