Search Contains Operator Don't Get Results Correctly

(Doc ID 2369328.1)

Last updated on MARCH 13, 2018

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.12.1.0.0 version, Accounts, Contacts, Households

Contains Operator don't get results correctly. The contains operator only output results when putting the exact first letters of the First name or Last name in Contact (as an example) and when adding the % wild card at beginning and the ending of the words its get the results correctly. That should be output from Contain Operator without using wild cards

What is the functionality of Contain Operator ?
 

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