Agile Quick Search Does Not Return Any Results After the Object Number Is Changed on Oracle Database 12.1.0.1 Environment (Doc ID 1938139.1)

Last updated on JUNE 25, 2017

Applies to:

Oracle Agile PLM Framework - Version 9.3.3.0 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior 
Quick search cannot find object and do not return any results when the object number has been changed


Expected Behavior
Quick search should find the objects when the object number has been changed

What is Working
Advanced Search finds the changed object

Fact
Oracle database version 12.1.0.1.0

Steps
1. Create an object (Item, Change, etc.) and save.
2. Search for the new object using Quick search, object is found.
3. Edit the objects number that was created in step 1.
4. Perform a Quick search for the edited number, object is not found.
Note: When doing a Quick search using the old object number (before the edit), the search brings up the object, but with the new edited object number.



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms