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 JANUARY 24, 2024

Applies to:

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

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