Find Account Service Returns A NullPointerException When Querying Using The Following Custom Field (Doc ID 2306145.1)

Last updated on NOVEMBER 18, 2020

Applies to:

Symptoms

On  : 11.12.1.0.0 version, Accounts, Contacts, Households

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

OrganizationDEO_IS_SiebelIntegrated_acc_c

URL: https://<ENV>.crm.em2.oraclecloud.com:443/crmCommonSalesParties/AccountService
Request xml

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body>
<ns3:findAccount xmlns:ns10="commonj.sdo" xmlns:ns11="http://xmlns.oracle.com/oracleas/schema/oracle-fault-11_0" xmlns:ns2="http://xmlns.oracle.com/apps/crmCommon/notes/flex/noteDff/" xmlns:ns3="http://xmlns.oracle.com/apps/crmCommon/salesParties/accountService/types/" xmlns:ns4="http://xmlns.oracle.com/adf/svc/errors/" xmlns:ns5="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns6="http://xmlns.oracle.com/apps/crmCommon/salesParties/accountService/" xmlns:ns7="http://xmlns.oracle.com/apps/crmCommon/salesParties/commonService/" xmlns:ns8="http://xmlns.oracle.com/apps/cdm/foundation/parties/organizationService/" xmlns:ns9="http://xmlns.oracle.com/apps/crmCommon/notes/noteService">
<ns3:findCriteria>
<ns5:fetchStart>0</ns5:fetchStart>
<ns5:fetchSize>50</ns5:fetchSize>
<ns5:filter>
<ns5:group>
<ns5:item>
<ns5:attribute>OrganizationDEO_IS_SiebelIntegrated_acc_c</ns5:attribute>
<ns5:operator>ISBLANK</ns5:operator>
</ns5:item>
</ns5:group>
</ns5:filter>
<ns5:findAttribute>PartyId</ns5:findAttribute>
</ns3:findCriteria>
</ns3:findAccount>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Response xml

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

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

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

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

Cause

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