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:
Oracle Fusion CX Sales Cloud Service - Version 11.12.1.0.0 and laterInformation 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! |
In this Document
Symptoms |
Cause |
Solution |
References |