My Oracle Support Banner

SOAP: How To Insert/query Multi Level Account Hierarchy (Doc ID 2498853.1)

Last updated on SEPTEMBER 28, 2023

Applies to:

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

Goal

On : 11.13.18.10.0 version, Accounts, Contacts, Households


How to insert/query multi level account Hierarchy
 
To reproduce the issue: Open any Account-->Profile Tab-->Click Manage Account Hierarchy-->Here you can create hierarchy manually and can also see the hierarchy that you have imported.

We were trying with the sample payload for single level hierarchy

WSDL : https://pod-name.oraclecloud.com:443/crmService/SalesPartiesAccountService?WSDL
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/crmCommon/salesParties/accountService/types/" xmlns:acc="http://xmlns.oracle.com/apps/crmCommon/salesParties/accountService/" xmlns:com="http://xmlns.oracle.com/apps/crmCommon/salesParties/commonService/" xmlns:not="http://xmlns.oracle.com/apps/crmCommon/notes/noteService" xmlns:not1="http://xmlns.oracle.com/apps/crmCommon/notes/flex/noteDff/" xmlns:org="http://xmlns.oracle.com/apps/cdm/foundation/parties/organizationService/">
<soapenv:Header/>
<soapenv:Body>
<typ:createAccount>
<typ:account>
<!--Optional:-->
<acc:SourceSystem>CSV</acc:SourceSystem>
<!--Optional:-->
<acc:SourceSystemReferenceValue>1-11jan18</acc:SourceSystemReferenceValue>
<!--Optional:-->
<acc:OrganizationName>11Jan181</acc:OrganizationName>
<!--Optional:-->
<acc:OwnerPartyId>300000002138982</acc:OwnerPartyId>
<!--Optional:-->
<acc:ParentAccountPartyId>300000003394534</acc:ParentAccountPartyId>
<!--Optional:-->
<acc:ParentAccountPartyNumber>22371</acc:ParentAccountPartyNumber>
<!--Optional:-->
<acc:ParentAccountSourceSystem>CSV</acc:ParentAccountSourceSystem>
<!--Optional:-->
<acc:ParentAccountSourceSystemReferenceValue>300000003394534</acc:ParentAccountSourceSystemReferenceValue>
</typ:account>
</typ:createAccount>
</soapenv:Body>
</soapenv:Envelope>

Solution

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
Goal
Solution
References


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