OIC Developer Guide to Create AR Customer Contact Email &...

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

Party Information

select * from fusion.hz_parties where party_id= 300000159607277

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>

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';

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 ♥

推荐订阅源

DEV Community