Find Account Service Returns A NullPointerException When Querying Using The Following Custom Field

(Doc ID 2306145.1)

Last updated on SEPTEMBER 24, 2017

Applies to:

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


On  : version, Accounts, Contacts, Households

Find Account Service returns a NullPointerException when querying using the following custom field


URL: https://<ENV>
Request xml

<SOAP-ENV:Envelope xmlns:SOAP-ENV="">
<ns3:findAccount xmlns:ns10="commonj.sdo" xmlns:ns11="" xmlns:ns2="" xmlns:ns3="" xmlns:ns4="" xmlns:ns5="" xmlns:ns6="" xmlns:ns7="" xmlns:ns8="" xmlns:ns9="">

Response xml

<tns:message>JBO-29000: Unexpected exception caught: java.lang.NullPointerException, msg=null</tns:message>

JBO-29000: Unexpected exception caught: java.lang.NullPointerException,

The issue can be reproduced at will with the following steps:
1. Open SOAP UI
2. Load this wsdl URL https://<ENV>
3. Call findAccount with Date ISBLANK operator
4. Getting an error

The issue has the following business impact:
Due to this issue, users cannot get the responses back from Sales Cloud due to an error


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