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 DECEMBER 22, 2020

Applies to:

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


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.

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.


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

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