My Oracle Support Banner

Stopword at Beginning of Account Search Causes Strange Search Results With Oracle Text Search (Doc ID 856005.1)

Last updated on MAY 22, 2020

Applies to:

Oracle WebCenter Content - Version 10.0 and later
Information in this document applies to any platform.


Using Oracle Text Search with the Accounts field optimized can cause searching irregularities when searching and stopwords are at the beginning of the account search value.  For example, if there are accounts setup like the following:

When a search is performed on the value "any/sd/admin", values were erroneously returned from the "int/sd/admin" and "dept/sd/admin" accounts.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.