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 09, 2023

Applies to:

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

Symptoms

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.

Cause

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
Symptoms
Cause
Solution

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