Update Customer Profile at Account Level using SOAP Webservice – Oracle Fusion

Posted by on in Oracle Home

There are situations when Customer Accounts are created without Profile (Profile History tab) at the Account level in Oracle Fusion Application.

Profile History at Customer account level

The following webservice can be used to create the Profile History.

SOAP WSDL: https://<yourservername>.oraclecloud.com/fscmService/ReceivablesCustomerProfileService?WSDL

Run the following query to get the following details that you will be using in the payload. 

select cust_account_id, account_number, party_id
from hz_cust_accounts
where account_number = p_account_number;

Payload: 

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/receivables/customers/customerProfileService/types/" xmlns:cus="http://xmlns.oracle.com/apps/financials/receivables/customers/customerProfileService/" xmlns:cus1="http://xmlns.oracle.com/apps/financials/receivables/customerSetup/customerProfiles/model/flex/CustomerProfileDff/" xmlns:cus2="http://xmlns.oracle.com/apps/financials/receivables/customerSetup/customerProfiles/model/flex/CustomerProfileGdf/">
   <soapenv:Header/>
   <soapenv:Body>
      <typ:createCustomerProfile>
         <typ:customerProfile>
            <cus:AccountNumber>999123001</cus:AccountNumber>
            <cus:CustomerAccountId>300000029861098</cus:CustomerAccountId>
            <cus:ProfileClassName>DEFAULT</cus:ProfileClassName>
            <cus:CreditChecking>Y</cus:CreditChecking>
            <cus:CreditHold>N</cus:CreditHold>
            <cus:DiscountTerms>Y</cus:DiscountTerms>
            <cus:DunningLetters>N</cus:DunningLetters>
            <cus:EffectiveEndDate>2030-01-10</cus:EffectiveEndDate>
            <cus:EffectiveStartDate>2022-01-09</cus:EffectiveStartDate>
            <cus:OverrideTerms>Y</cus:OverrideTerms>
            <cus:PartyId>300000029829602</cus:PartyId>
         </typ:customerProfile>
      </typ:createCustomerProfile>
   </soapenv:Body>
</soapenv:Envelope>

If you get the response payload, then the profile history is created.