I need to search by part number. Right now if I search for 'abc-' the result will be like 'abc-gd','bvc','hhdh'... etc. ie all Related as well as Substitute items are listing. I just need to remove Related as well as Substitute items. Exact search ie if I search for 'abc' can come 'abc-bbc', 'abc', 'abcsomething' etc.
Can anybody post a query for the same. i am using r12.
Be sure you do not have Fuzzy search enabled -
"IBE: Enable Fuzzy Search" profile should not be set to Yes.
The item search for iStore is based on the part number, product name (description column), and product description (long description column).
You can modify the search package (IBEVCSKS.pls and IBEVCSKB.pls) based on your business requirement for iStore searching.
Also see: 'Customizing Search' section on page 7-36, Oracle iStore Implementation and Administration Guide Release 12.1 Part No. E13575-06
Deborah Bourgeois, Oracle Customer Support