My Oracle Support Banner

Advanced Search Criteria List of Values (LOV) Is Triggered When Choose "Starts With" or "Contains" -- Only Expect LOV For "Is" Operator (Doc ID 2194508.1)

Last updated on MAY 02, 2018

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The list of values appears when the user is entering "starts with" and "contains" criteria.

What is working
This worked correctly in R12.1.3.

Expected Behavior
Expect 'starts with' and 'contains' to NOT trigger the list of values.

Steps
1. Choose development manager (or product data hub data Librarian) > Item Advanced Search
2. Add criteria
3. Select a UDA with a list of values (LOV)
4. Add attribute
5. Select starts with/contains
6. The LOV ICON is appearing

Business Impact
Cannot search using 'starts with' or "contains".
Makes it difficult to quickly find items.

Changes

Upgraded to R12.2. Worked on R12.1.3.

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!

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