IBE:Problem With Filling Of The IBE_CT_IMEDIA_SEARCH Table After Change Of Web Status To 'PUBLISHED' (Doc ID 1563806.1)

Last updated on MARCH 17, 2019

Applies to:

Symptoms

IBE_CT_IMEDIA_SEARCH table contains rows with different category_set_id for one item

Steps to reproduce
-----------------------

1. Look into the MTL_SYSTEM_ITEMS_B table for any web_status=UNPUBLISHED item which belongs to IBE Category Set.
2. Run the below query before changing the item status
    select * from IBE_CT_IMEDIA_SEARCH where INVENTORY_ITEM_ID = <inventory_item_id>;
3. Change the item's web status to PUBLISHED

4.In table IBE_CT_IMEDIA_SEARCH, there are many rows with different category_set_id for one item, but this is wrong.
FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671) returns one category_set_id.
And only this very category_set_id should be in the IBE_CT_IMEDIA_SEARCH table.

Changes

Cause

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