My Oracle Support Banner

Where Used Tab Missing Items Present In the Agile Database Schema (Doc ID 2892948.1)

Last updated on JANUARY 24, 2024

Applies to:

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

Symptoms

Actual Behavior

Where Used tab missing the items that is present in the database.
The number of Items showing in the Where Used tab of the certain Item is smaller than the number of the Item returned when running below sql:


Expected Behavior

The number of items returned by the sql query and the ones listed under Where Used tab should be same.


Steps

The issue can be reproduced at will with the following steps:

  1. Log into sqlplus as agile database user, and run the sql query to retrieve the where used data from item
  2. Log into Web Client, and search and open the same Item. Go to Where Used tab to check the Item Number
  3. Compare the result of the sql and the Item showing in the Where Used tab. There are items those returned by sql but not showing in Where used tab




Cause

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
Symptoms
Cause
Solution


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