mergeOrganization — SOAP payload to add a party site to an organization
mergeOrganization on the CDM Foundation Parties Organization Service adds a PartySite (an address, with one or more site uses) to an existing organization party in Trading Community Architecture. Mandatory elements: PartyId (the organization), LocationId (an existing HZ location), CreatedByModule (e.g. HZ_WS), and SiteUseType on each PartySiteUse (e.g. BILL_TO). Source: Oracle 'Create a Party Site' SOAP example.
WSDL
https://<your-fusion-host>:443/crmService/OrganizationService?WSDLPOST the SOAP envelope to the same URL without ?WSDL. Replace <your-fusion-host> with your pod host.
Purpose
Attach a party site (address usage) to an existing organization party. The service namespace is http://xmlns.oracle.com/apps/cdm/foundation/parties/organizationService/ — confirm the exact deployed WSDL path for your pod from Setup and Maintenance > SOAP web services. POST the envelope to the WSDL URL without ?WSDL with a WS-Security UsernameToken.
Parameters
PartyIdrequiredPARTY_ID of the existing organization party the site is added to (HZ_PARTIES).LocationIdrequiredLOCATION_ID of an existing address (HZ_LOCATIONS) to use for the site.CreatedByModulerequiredCreating module code — 'HZ_WS' for web service inserts. Required on the PartySite and on each PartySiteUse.SiteUseTyperequiredPurpose of the site use on PartySiteUse, e.g. BILL_TO, SHIP_TO (HZ_PARTY_SITE_USES).Example request
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <ns1:mergeOrganization xmlns:ns1="http://xmlns.oracle.com/apps/cdm/foundation/parties/organizationService/applicationModule/types/"> <ns1:organizationParty xmlns:ns2="http://xmlns.oracle.com/apps/cdm/foundation/parties/organizationService/"> <ns2:PartyId>1003</ns2:PartyId> <ns2:PartySite xmlns:ns3="http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/"> <ns3:LocationId>970</ns3:LocationId> <ns3:CreatedByModule>HZ_WS</ns3:CreatedByModule> <ns3:PartySiteUse> <ns3:SiteUseType>BILL_TO</ns3:SiteUseType> <ns3:CreatedByModule>HZ_WS</ns3:CreatedByModule> </ns3:PartySiteUse> </ns2:PartySite> </ns1:organizationParty> </ns1:mergeOrganization> </soap:Body> </soap:Envelope>
Example response
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<ns0:mergeOrganizationResponse
xmlns:ns0="http://xmlns.oracle.com/apps/cdm/foundation/parties/organizationService/applicationModule/types/">
<ns3:result xmlns:ns2="http://xmlns.oracle.com/apps/cdm/foundation/parties/organizationService/"
xmlns:ns1="http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/">
<ns2:Value>
<ns2:PartyNumber>1003</ns2:PartyNumber>
<ns2:PartyId>1003</ns2:PartyId>
<ns2:PartyType>ORGANIZATION</ns2:PartyType>
<ns2:PartyName>OrgTest01282013mnb</ns2:PartyName>
<ns2:PartySite>
<ns1:PartySiteId>300100573317048</ns1:PartySiteId>
<ns1:PartyId>1003</ns1:PartyId>
<ns1:LocationId>970</ns1:LocationId>
<ns1:PartySiteNumber>CDRM_815835</ns1:PartySiteNumber>
<ns1:StartDateActive>2021-09-15</ns1:StartDateActive>
<ns1:EndDateActive>4712-12-31</ns1:EndDateActive>
<ns1:Status>A</ns1:Status>
<ns1:CreatedByModule>HZ_WS</ns1:CreatedByModule>
<ns1:Address1>1800 Satellite Drive</ns1:Address1>
<ns1:City>Chattanooga</ns1:City>
<ns1:State>TN</ns1:State>
<ns1:PostalCode>37401</ns1:PostalCode>
<ns1:Country>US</ns1:Country>
<ns1:PartySiteUse>
<ns1:PartySiteUseId>300100573317049</ns1:PartySiteUseId>
<ns1:SiteUseType>BILL_TO</ns1:SiteUseType>
<ns1:BeginDate>2021-09-15</ns1:BeginDate>
<ns1:Status>A</ns1:Status>
<ns1:CreatedByModule>HZ_WS</ns1:CreatedByModule>
</ns1:PartySiteUse>
</ns2:PartySite>
</ns2:Value>
</ns3:result>
</ns0:mergeOrganizationResponse>
</env:Body>
</env:Envelope>Call lifecycle
- 01
WS-Security UsernameToken in the SOAP header.
- User needs the Trading Community / customer data privilege
- POST to the WSDL URL without ?WSDL
- 02
- 03
- 04
Related Oracle objects
HZ_PARTIES
CuratedThe organization party referenced by PartyId.
Key columns
HZ_LOCATIONS
CuratedThe physical address referenced by LocationId.
Key columns
HZ_PARTY_SITES
CuratedThe party site the call creates — PartySiteId in the response is this table's key.
Key columns
Related questions
Retrieved from the curated Oracle knowledge layer — table metadata, joins and process flows.