This discussion is archived
1 Reply Latest reply: Feb 26, 2013 5:21 PM by DeborahCRM-Oracle RSS

Part number search without listing Related as well as Substitute items

933676 Newbie
Currently Being Moderated
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.
  • 1. Re: Part number search without listing Related as well as Substitute items
    DeborahCRM-Oracle Journeyer
    Currently Being Moderated
    Hello,

    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


    Thank You,
    Deborah Bourgeois, Oracle Customer Support

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points