Specific Agile Object Not Returned with Any Search but Gets Error '{Number} already exists' When Attempting to Create an Object with the Same Number
(Doc ID 2224023.1)
Last updated on OCTOBER 03, 2023
Applies to:
Oracle Agile Product Collaboration - Version 9.3.5.0 and laterOracle Agile Product Governance and Compliance - Version 9.3.5.0 and later
Oracle Agile PLM Framework - Version 9.3.5.0 and later
Information in this document applies to any platform.
Symptoms
When searching for a specific object (i.e. Change/Declaration/Item/Manufacturer Part), it cannot be found.
The object is not searched by any search: quick search, advanced search and recycle bin search.
When attempted to create a new object with the same number, the Agile system states that the object with the same number already exists.
The issue can be reproduced at will with the following steps:
- Log into Web Client an run quick search for the object with its number. No result found
- Run Advanced search for the object with its number. No result found
- Try to create a new object with the same number. Gets error: {Number} already exists
- Log into sql developer as agile database user, and run below sql, depending on which class the object belongs to:
-- For Change object
select * from CHANGE where CHANGE_NUMBER ='{Number}';
-- For Declaration object
select * from MATERIAL_DECLARATION where NAME ='{Number}';
-- For Item object
select * from ITEM where ITEM_NUMBER ='{Number}';
-- For Manufacturer Part
select * from MANU_PARTS where PART_NUMBER ='{Number}'; - See the record is found.
Changes
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 |
Changes |
Cause |
Solution |