My Oracle Support Banner

"Is Blank" Operator Is Not Working In Account Advanced Search For Search Field "Parent Account" (Doc ID 2422560.1)

Last updated on MARCH 26, 2019

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Goal

How to search using Parent Account = blank search criteria ?
"Is Blank" search operator is not working in Account Advanced Search for the search field "Parent Account".

On searching for Accounts for which "Parent Account" field is blank, not getting any results.

Even though relevant Account records are available and should show up.

Steps:
1. Go to Accounts Work Area.
2. Go to Advanced Search. Use following criteria in advanced search:
a. Record Set: Equals: All records I can see
b. Parent Account: Is blank
c. Type: Equals: Customer
3. This search criterion doesn’t return any result even though there are Account records which fulfill these criteria.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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