My Oracle Support Banner

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:

Oracle iStore - Version 12.1.3 and later
Information in this document applies to any platform.

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

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
References


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