NPE when querying with REST WS an Account record based on a custom field which equals NULL

(Doc ID 2372314.1)

Last updated on MARCH 29, 2018

Applies to:

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

Goal

Customer has a custom Account_c field created under Account and they would like to query, via REST, all the Account records which have Account_c as NULL. However, they are getting a NullPointerException when doing so. Why is this happening?
 

Solution

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