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.
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.
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