Wild Card % In The Item Advanced Search Does Not Display The List Of Values (LOV): Gives Error: R11i Works
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