New Advanced Search Criteria Operator "Is Not Null" Does Not Work On User Defined Attributes
Last updated on APRIL 30, 2018
Applies to:Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.
New PIM Advanced Search criteria operator "is not null" does not work on UDAs
After applying Patch 5498818:R12.EGO.C, you see two new operators on the Advanced Search criteria : "Is null" and "Is not null". These only work for seeded attributes and do not work - they do not produce any search results - when used on user defined attributes.
"Is null" and "Is not null" should work for UDAs
The issue can be reproduced at will with the following steps:
1. Advanced Search -> Search for items with UDA -> Criteria "Is null" and "Is not null".
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