Search In Catalog Not Returning Results When Searching With Partial String Even With '%' Character (Doc ID 2524588.1)

Last updated on AUGUST 02, 2021

Applies to:

Symptoms

Catalog search with partial string match in the middle doesn't return any results. For example: When using the string 'string' or '%string%' to search for roles in Catalog search, one would expect the following roles to come up as results:

<STRING_ON01EAST_1>
<STRING_ON02EAST_2>
<STRING_ON03EAST_3>

But search does not show these roles.

How to resolve this issue?

Cause

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