How to Customize Search, so Product Number takes a precedence over Description (Doc ID 1626530.1)

Last updated on MARCH 15, 2017

Applies to:

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

Goal

Currently when product searched in Quoting or iStore, it uses intermedia search table, IBE_CT_IMEDIA_SEARCH
This table uses intermedia index based on combination of product number, description and long description.
However, the order in which this search string was built was like this:
Product Description + Product Long Description + Product Number

Above works fine for most cases but for some cases, user may see unexpected products when user searches by Product Number.
If users always searches by product number not by description much, then one may need to customize the way search table data was built by changing the order sequence of fields,

From:
    Product Description + Product Long Description + Product Number
To:
    Product Number + Product Description + Product Long Description

Solution

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