iStore - EBS (MOSC)

MOSC Banner

Does Istore administration need to refresh the interMedia search index every time a new product is a

edited Feb 19, 2015 10:01AM in iStore - EBS (MOSC) 2 commentsAnswered

User is unable to query a model for which published flag and orderable over web was not set,I changed the flags and ran a program that does the work of below command.

The following Triggers were enabled

MTL_SYSTEM_ITEMS_B_T2_IBE 

  MTL_SYSTEM_ITEMS_B_T3_IBE 

  MTL_SYSTEM_ITEMS_TL_TA_IBE 

  MTL_CATEGORIES_B_TA_IBE 

  MTL_ITEM_CATEGORIES_TA_IBE

But still do I need to refresh the interMedia search index every time a new product is added or an existing product is changed or deleted by refreshing the interMedia index IBE_CT_IMEDIA_SEARCH_IM through the Oracle Enterprise Manager utility, or by executing the command "ctx_ddl.sync_index" in SQL*Plus as follows: exec ctx_ddl.sync_index('IBE_CT_IMEDIA_SEARCH_IM').

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS iStore Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center