CrmCommonReferenceService Find Entities Only Using Attribute RecordName Issue

(Doc ID 2323134.1)

Last updated on NOVEMBER 03, 2017

Applies to:

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

Goal

Customer is using CrmCommonReferenceService web service to search records in the Custom Object "RegisteredSupplier_c" using this payload

 

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/cdm/foundation/custextn/extnService/types/" xmlns:typ1="http://xmlns.oracle.com/adf/svc/types/">
<soapenv:Header/>
<soapenv:Body>
<typ:findEntity>
<typ:findCriteria>
<typ1:fetchStart>0</typ1:fetchStart>
<typ1:fetchSize>-1</typ1:fetchSize>
<!--Optional:-->
<typ1:filter>
<!--1 or more repetitions:-->
<typ1:group>
<!--1 or more repetitions:-->
<typ1:item>
<typ1:upperCaseCompare>false</typ1:upperCaseCompare>
<typ1:attribute>RecordName</typ1:attribute>
<typ1:operator>=</typ1:operator>
<typ1:value>98001301_C09</typ1:value>
</typ1:item>
</typ1:group>
</typ1:filter>
<!--Optional:-->
</typ:findCriteria>
<typ:findControl>
<typ1:retrieveAllTranslations>false</typ1:retrieveAllTranslations>
</typ:findControl>
<typ:objectName>RegisteredSupplier_c</typ:objectName>
</typ:findEntity>
</soapenv:Body>
</soapenv:Envelope>

 

But the payload is working for some records and not returning the results for others.
 

Solution

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