DEV Community

Naveen
Naveen

Posted on

OIC Developer Guide to Create AR Customer Contact Email & Phone in Oracle Fusion Using SOAP (mergePerson)

#api #cloud #sql #tutorial

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
Enter fullscreen mode Exit fullscreen mode

Party Information

select * from fusion.hz_parties where party_id= 300000159607277
Enter fullscreen mode Exit fullscreen mode

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>Addtest@test.com</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>
Enter fullscreen mode Exit fullscreen mode

Step 4: Validate Data in Frontend Screen

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';
Enter fullscreen mode Exit fullscreen mode

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 ♥

Top comments (0)