Wednesday, 3 February 2021

Oracle Fusion ERP and SCM Cloud Application - Custom Object - Create Entity - SOAP Envelop - Request and Response Sample payload

--ERP and SCM Cloud Application - Custom Object WSDL Link--

https://servername/fscmService/FscmCustomReferenceService?WSDL 


--SOAP Request--

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns2="http://xmlns.oracle.com/apps/custom/extnService/types/" xmlns:ns1="http://xmlns.oracle.com/apps/custom">

   <env:Body>

      <ns2:createEntity>

         <ns2:object xsi:type="ns1:Party_c" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

            <ns1:RecordName>Test3</ns1:RecordName>

            <ns1:PartyNumber_c>1001</ns1:PartyNumber_c>

            <ns1:PartyName_c>Test3</ns1:PartyName_c>

         </ns2:object>

         <ns2:objectName>Party_c</ns2:objectName>

      </ns2:createEntity>

   </env:Body>

</env:Envelope>


--SOAP Response--

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing" xmlns:typ="http://xmlns.oracle.com/apps/custom/extnService/types/">

   <env:Header>

      <wsa:Action>http://xmlns.oracle.com/apps/custom/extnService//FscmCustomReferenceService/createEntityResponse</wsa:Action>

      <wsa:MessageID>urn:uuid:b4d84f48-ffc0-4554-ae34-227e57ed79eb</wsa:MessageID>

   </env:Header>

   <env:Body>

      <ns0:createEntityResponse xmlns:ns0="http://xmlns.oracle.com/apps/custom/extnService/types/">

         <ns2:result xsi:type="ns1:Party_c" xmlns:ns2="http://xmlns.oracle.com/apps/custom/extnService/types/" xmlns:ns1="http://xmlns.oracle.com/apps/custom" xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

            <ns1:Id>300000012482600</ns1:Id>

            <ns1:RecordName>Test3</ns1:RecordName>

            <ns1:CreatedBy>test.scm</ns1:CreatedBy>

            <ns1:CreationDate>2021-02-03T12:02:00.0Z</ns1:CreationDate>

            <ns1:LastUpdatedBy>test.scm</ns1:LastUpdatedBy>

            <ns1:LastUpdateDate>2021-02-03T12:02:00.519Z</ns1:LastUpdateDate>

            <ns1:ObjectVersionNumber>1</ns1:ObjectVersionNumber>

            <ns1:RecordNumber>4010</ns1:RecordNumber>

            <ns1:LastUpdateLogin xsi:nil="true"/>

            <ns1:UserLastUpdateDate xsi:nil="true"/>

            <ns1:CurrencyCode>USD</ns1:CurrencyCode>

            <ns1:CurcyConvRateType>Corporate</ns1:CurcyConvRateType>

            <ns1:CorpCurrencyCode>USD</ns1:CorpCurrencyCode>

            <ns1:PartyNumber_c>1001</ns1:PartyNumber_c>

            <ns1:SelectedRow xsi:nil="true"/>

            <ns1:PartyName_c>Test3</ns1:PartyName_c>

         </ns2:result>

      </ns0:createEntityResponse>

   </env:Body>

</env:Envelope>

3 comments:

  1. Replies
    1. Hi Hany this is the oracle provided rest API's only, only we need to initialize our object API name in that payload.

      Delete
  2. Custom objects created in Oracle Fusion CRM or FSCM applications are by default REST API enabled (get, post, delete and patch ) and can be invoked using any REST API client.

    FSCM custom objects:
    https://<%your saas name%>.oraclecloud.com:443/fscmRestApi/resources/11.13.18.05/<%custom object name%>

    CRM application custom objects
    https://.oraclecloud.com:443/crmRestApi/resources/11.13.18.05/<%crm custom object name%>

    because Fusion FSCM extensions does not support SOAP oracle has provided an object to access the custom objects created in CRM and FSCM application using below object and WSDLS
    FSCM custom objects look for WSDL for FscmCustomReferenceService object
    CRM custom objects look for WSDL for CustomReferenceService object

    run below REST API to get the WSDL files
    FSCM Service WSDL URL: https://servername/fscmService/FscmCustomReferenceService?WSDL
    CRM Service WSDL URL: https://servername/crmService/CustomReferenceService?WSDL

    ReplyDelete