OIC Developer Guide to Create AR Customer Contact Email & Phone in Oracle Fusion Using SOAP (mergePerson)
DEV Community Grade 8 9d ago

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

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 ♥

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: 300000159607277 300000159607279 HZ_PARTIES HZ_WS BUSINESS Addtest@test.com HZ_PARTIES HZ_WS BUSINESS 2128811223 999 MOBILE 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 ♥ Top comments (0)
Read on DEV Community ↗ ← Back to News

Comments

No comments yet. Start the discussion.