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 laterInformation 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:
- Log into sqlplus as agile database user, and run the sql query to retrieve the where used data from item
- Log into Web Client, and search and open the same Item. Go to Where Used tab to check the Item Number
- 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 |