top of page

Tags

Archive

Download Data from UCM-Oracle Fusion

In this Post , Will show you how to download files from UCM using SOAP WS.


WSDL: https:/POD/idcws/GenericSoapPort


Request Payload To get the Documentid ...

it will take dDocName as Input Parameter which can be found from UCM UI.


<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="GET_SEARCH_RESULTS">
            <ucm:Document>
               <ucm:Field name="QueryText">dDocName &lt;substring> `UCMFA03374703`</ucm:Field>
               <ucm:Field name="resultCount">25</ucm:Field>
               <ucm:Field name="sortField">dDocName</ucm:Field>
               <ucm:Field name="sortOrder">ASC</ucm:Field>
               <ucm:Field name="startRow">1</ucm:Field>
            </ucm:Document>
         </ucm:Service>
      </ucm:GenericRequest>
   </soapenv:Body>
</soapenv:Envelope>

dDocName can be found from the below .

Content ID = dDocName


Response Payload :



Response_payload_UCM-Get-Search-Results
.xml
Download XML • 30KB

Capture the below did from above response .


Using the same WSDL , Prepare the below Payload to download the actual file.


Request 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="GET_FILE">
            <!--Optional:-->
            <!--Optional:-->
            <ucm:Document>
               <!--Zero or more repetitions:-->
               <ucm:Field name="dID">3403205</ucm:Field>
               <!--Zero or more repetitions:-->
               <!--Zero or more repetitions:-->
               <!--Zero or more repetitions:-->
            </ucm:Document>
         </ucm:Service>
      </ucm:GenericRequest>
   </soapenv:Body>
</soapenv:Envelope>


Response Payload :



Response-File_Downoad-UCM
.xml
Download XML • 22KB

The Contents Tag will hold the Encoded file Contents .



Encoded Data :


UEsDBBQAAAAIAEh4fFQU+sL03AAAAAAGAAATAAAAUG96U3VwcGxpZXJzSW50LmNzdtWSXQuCMBSG74P+w37AucjvupxzpSQ6/AjpRsSChHIy6v/n0AiSKPIm33EuNrax59khEcUJhSzbhC4OUJwy5ns0UgAUVdMNE4Bw0XBRXCteQ3xrmnN1FAAxo4GT4zRxw8jbUwdkUF+A0rg/by1X7VI3PubLbT/FLq7lKcfKY94+fz4jT/ptOoC3RsA/6KcBn9Dh1y/f0KNv8NX2CllTwGceIaEfDgSsRgnQdFXWFATs6IYm+JXfXIzjl/jmBPofX46iKosa2YVAa36rDx1vJ0EZI0FTDU120h9LuANQSwECFAAUAAAACABIeHxUFPrC9NwAAAAABgAAEwAAAAAAAAABACAAAAAAAAAAUG96U3VwcGxpZXJzSW50LmNzdlBLBQYAAAAAAQABAEEAAAANAQAAAAA=

Go to Online Decode to file tools and download the file .


https://base64.guru/converter/decode/file




Click On Application.zip file to see the file contents .


Hope this Helps . Happy Learning .



2,643 views0 comments

Recent Posts

See All

In this Post I will show you how to create the Payable Invoice using FBDI. To Successfully Create the Invoice , we need to follow the below steps . Get the FBDI file from OER - oracle Enterprise repos

In this Post I will Explain how to Create Payable invoice using the fronted -UI you need below information for successful creation of AP Invoice. Business Unit Supplier Name Supplier Number Supplier S

Other Posts you may Interested