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 11.12.1.0.0 and later
Information in this document applies to any platform.

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

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.