Wild Card % In The Item Advanced Search Does Not Display The List Of Values (LOV): Gives Error: R11i Works

(Doc ID 1901417.1)

Last updated on MAY 21, 2018

Applies to:

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


Item Advanced search does not allow to populate search criteria using % in the list of values (LOV) like lifecycle phase.

-- Error --
You must enter a value to search. Values cannot start with "%" or "_"

-- What is working --
In 11i we were able search using %.

-- Workaround --
If one knows the lifecycle phase, they can enter the first initial like P% and the LOV works.

Expect find list of values (LOV) to allow % on lifecyclephase.

1. Navigate to Development Manager > Advanced Search > Choose an item catalog category.
2. Use LOV for Lifecycle Phase
3. Enter % and Go.
4. Get the error.

More time consuming as users must know the lifecycle name or starting letters.


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