12.2.4: Item Created From UI Not Visible In Simple Search, Records missing in EGO_ITEM_TEXT_TL table (Doc ID 2180825.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Product Hub - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Catalog items

ACTUAL BEHAVIOR
---------------
12.2.4: Items created from UI are not visible in Simple Search. These are missing in EGO_ITEM_TEXT_TL eventhough all triggers are enabled and valid.

EXPECTED BEHAVIOR
-----------------------
Simple search should return item created from UI immediately, No Additional steps required here.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Development Manager > Create Item > Finish
2. Simple Search > Search for item

--> See item is not returned.

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