How to retrieve all contact details for accounts to which a contact is associated, including related accounts using OrganizationService? (Doc ID 2203683.1)

Last updated on DECEMBER 05, 2016

Applies to:

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

Goal

How to retrieve all contact details for accounts to which a contact is associated including related accounts using OrganizationService?

This payload will do all but those for related accounts:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ns1:findOrganization xmlns:ns1="http://xmlns.oracle.com/apps/cdm/foundation/parties/organizationService/applicationModule/types/">
<ns1:findCriteria xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/">
<ns0:fetchStart>0</ns0:fetchStart>
<ns0:fetchSize>100</ns0:fetchSize>
<ns0:filter>
<ns0:conjunction>And</ns0:conjunction>
<ns0:group>
<ns0:conjunction>And</ns0:conjunction>
<ns0:item>
<ns0:conjunction>And</ns0:conjunction>
<ns0:upperCaseCompare>false</ns0:upperCaseCompare>
<ns0:attribute>Relationship</ns0:attribute>
<ns0:operator>EXISTS</ns0:operator>
<ns0:nested>
<ns0:group>
<ns0:conjunction>And</ns0:conjunction>
<ns0:upperCaseCompare>false</ns0:upperCaseCompare>
<ns0:item>
<ns0:conjunction>And</ns0:conjunction>
<ns0:upperCaseCompare>false</ns0:upperCaseCompare>
<ns0:attribute>PartyName</ns0:attribute>
<ns0:operator>=</ns0:operator>
<ns0:value>FirstName LastName</ns0:value>
</ns0:item>
</ns0:group>
</ns0:nested>
</ns0:item>
</ns0:group>
</ns0:filter>
</ns1:findCriteria>
</ns1:findOrganization>
</soap:Body>
</soap:Envelope>

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