In Oracle Fusion, AR Customer Contacts are stored as Party Relationships. Adding or updating contact details such as phone number and email address requires interaction with the Foundation Person Service SOAP API.
This guide walks you through:
- Identifying required data (PartyId & RelationshipId)
- Using SOAP API to create contact points
- Verifying data in backend tables
Step 1: Identify Customer Contact Details
Relationship Information
select * from fusion.hz_relationships where relationship_id=300000159607279
Step 2: Use SOAP API to Create Contact Details
WSDL Endpoint:
Use SOAP API /crmService/FoundationPartiesPersonService to add new phone number and email for this AR Customer Contact
Operation:mergePerson
This API is used to update or merge person-related information, including contact points.
Step 3: Sample SOAP Request
Below is a working payload to create both email and phone:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:typ="http://xmlns.oracle.com/apps/cdm/foundation/parties/personService/applicationModule/types/"
xmlns:per="http://xmlns.oracle.com/apps/cdm/foundation/parties/personService/"
xmlns:rel="http://xmlns.oracle.com/apps/cdm/foundation/parties/relationshipService/"
xmlns:con="http://xmlns.oracle.com/apps/cdm/foundation/parties/contactPointService/">
<soapenv:Header/>
<soapenv:Body>
<typ:mergePerson>
<typ:personParty>
<per:PartyId>300000159607277</per:PartyId>
<per:Relationship>
<rel:RelationshipId>300000159607279</rel:RelationshipId>
<!-- Email Creation -->
<rel:Email>
<con:OwnerTableName>HZ_PARTIES</con:OwnerTableName>
<con:CreatedByModule>HZ_WS</con:CreatedByModule>
<con:ContactPointPurpose>BUSINESS</con:ContactPointPurpose>
<con:EmailAddress>[email protected]</con:EmailAddress>
</rel:Email>
<!-- Phone Creation -->
<rel:Phone>
<con:OwnerTableName>HZ_PARTIES</con:OwnerTableName>
<con:CreatedByModule>HZ_WS</con:CreatedByModule>
<con:ContactPointPurpose>BUSINESS</con:ContactPointPurpose>
<con:PhoneNumber>2128811223</con:PhoneNumber>
<con:PhoneExtension>999</con:PhoneExtension>
<con:PhoneLineType>MOBILE</con:PhoneLineType>
</rel:Phone>
</per:Relationship>
</typ:personParty>
</typ:mergePerson>
</soapenv:Body>
</soapenv:Envelope>
Step 5: Validate Data in Backend Tables
After successful API execution, verify using:
SELECT CONTACT_POINT_ID,
CONTACT_POINT_TYPE,
PHONE_TYPE,
OWNER_TABLE_ID,
RELATIONSHIP_ID,
PHONE_NUMBER,
EMAIL_ADDRESS
FROM fusion.hz_contact_points
WHERE creation_date > SYSDATE - 1
AND created_by_module = 'HZ_WS'
AND owner_table_name = 'HZ_PARTIES';
Step 6: From OIC
With same WSDL :https:/crmService/FoundationPartiesPersonService?WSDL
create Connection.Call the connection in OIC with mergePerson Operation
Pass respective Values to it
Conclusion:
We successfully updated the Customer communication details using SOAP WSDL in Oracle Fusion ♥
SOCIAL SHARE CARD GENERATOR