My Oracle Support Banner

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


To view full details, 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 a vibrant support community of peers and Oracle experts.