How Does The Intermedia Product Search Work in Oracle Quoting ? (Doc ID 810714.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Quoting - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 05-Jan-2014***

Goal

How to understand the behavior of the product (intermedia) search in Oracle Quoting ?

eg. for a product named - TEST MODEL`XYZ FAMILY 2`ABC`XYZ PRODUCT FAMILY MODEL

The results are for the product search are as below as below :-

"TEST MODEL`XYZ FAMILY 2`ABC`XYZ PRODUCT FAMILY MODEL" returns results (working)
"TEST MODEL`XYZ FAMILY 2`ABC`XYZ PRODUCT FAMILY" returns results (working)
"TEST MODEL`XYZ FAMILY 2`ABC`XYZ PRODUCT " returns results (working)
"TEST MODEL`XYZ FAMILY 2`ABC`XYZ" returns results (working)
"TEST MODEL`XYZ FAMILY 2" returns results (working)
"TEST MODEL" returns results (working)
"XYZ FAMILY%PRODUCT%" returns no results (not working)
"XYZ%FAMILY%PRODUCT%" returns no results (not working)
"XYZ FAMILY PRODUCT" returns no results (not working)
"XYZ FAMILY PRODUCT MODEL" returns no results (not working)

Additionally..

1. MODEL%XYZ%: No rows
2. MODEL% XYZ%: Rows returned
3. MODEL XYZ: Rows returned
4. FAMILY%TEST%MODEL%: No rows
5. FAMILY% TEST% MODEL%: No rows
6. FAMILY TEST MODEL: No rows
7. MODEL% TEST%: No rows
8. MODEL%TEST%: No rows
9. MODEL TEST: No rows
10. PRODUCT%MODEL%FAMILY%: No rows
11. PRODUCT% MODEL% FAMILY%: No rows
12 PRODUCT MODEL FAMILY: No rows
13. PRODUCT%MODEL%: No rows
14. PRODUCT% MODEL%: No rows
15. PRODUCT MODEL: No rows

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