How to call Oracle Fusion ERP UCM Web Service

Oracle Fusion ERP UCM Web service allows external applications to interact with content stored in Fusion ERP. We can use it to import/export files and the content is categorized based on account in UCM e.g. it has separate account for GL journal, suppliers and fixed assets etc. since ESS jobs which run for respective modules can access the content in UCM. Here’s how to call the Oracle Fusion ERP UCM web service:

Obtain WSDL and prepare File Upload Request

We will use SOAP Ui to call the standard UCM webservice provided in Oracle Fusion ERP. In SOAP Ui, start a new project and give wsdl url as https://your-erp-instance.idcws/GenericSoapPort?wsdl. Put your ERP instance in this URL. SOAP Ui will load the WSDL with operations. Under GenericSoapOperation, add a request and replace the request payload with payload given below and also shown in screenshot. Replace with your values as mentioned in payload.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ucm="http://www.oracle.com/UCM">
<soapenv:Header/>
   <soapenv:Body>
      <ucm:GenericRequest webKey="cs">
         <ucm:Service IdcService="CHECKIN_NEW">
            <ucm:Document>          
              <ucm:Field name="dUser">ur Integration User</ucm:Field>
              <ucm:Field name="dDocTitle">content.txt</ucm:Field>
              <ucm:Field name="dDocType">Document</ucm:Field>  
	      <ucm:Field name="dDocAuthor">ur Integration User</ucm:Field>                            
	      <ucm:Field name="dSecurityGroup">FAFusionImportExport</ucm:Field>                            
	      <ucm:Field name="dDocAccount"></ucm:Field>                            						
              <ucm:File name="primaryFile" href="content.txt">
              <ucm:Contents>paste your base64 encoded file string here
              </ucm:Contents>
              </ucm:File>			
             </ucm:Document>
           </ucm:Service>
       </ucm:GenericRequest>
     </soapenv:Body>
</soapenv:Envelope>

Since we need to convert the file to base64 before we can put it in request payload, we will use a Base64 conversion utility provided at https://www.motobit.com/util/base64-decoder-encoder.asp. Upload the file to this site and generate base64 string and copy it and paste it in request payload. After providing credentials in SOAP Ui, run the request and verify the response payload.

Go to File import and export and check if the file is upload. Copy the content id as it will be used to call webservice to download the file as shown below.

UCM Werb Service File Download Request

We will now call the same webservice to download a file from UCM. Add a new request under GenericSoapOperation and replace the whole request with following request payload. Notice IdcService is GET_FILE this time and this is for downloading the file.

After providing credentials in SOAP Ui, run the request and verify the response payload. The file will be available for download in attachment in response payload. Download and change the file extension to appropriate extension to view the file.

Conclusion

Calling the Oracle Fusion ERP UCM web service allows external applications to interact with content stored within Fusion ERP. By following the steps outlined above and leveraging the appropriate authentication mechanisms and client code generation tools, developers can integrate UCM functionality seamlessly into their applications.