Integrations and Extensions

Enterprise Resource Planning

Topic

    Kesava Rao Katuri
    PPM Project - ErpObjectAttachmentService - Update Attachment
    Topic posted August 19, 2019 by Kesava Rao KaturiRed Ribbon: 250+ Points, tagged File Based Data Integration - FBDI, Import Bulk Data, Integrated Cloud Services, PaaS - SaaS Extensions, Project Portfolio Management 
    31 Views, 12 Comments
    Title:
    PPM Project - ErpObjectAttachmentService - Update Attachment
    Summary:
    How to update/override the existing attachement in ERP
    Content:

    Hi All

    Using ErpObjectAttachmentService (SOAP), we can either upload or download the attachment(s) which are attached to a particular project.

    Is there a way to update/delete the existing attachment  through API?

    Thanks

    Kesava

    Comment

     

    • Kunal Sonje

      Hi Kesava,

      You can refer DELETE_DOC operation of https://{host}/idcws/GenericSoapPort?wsdl

      Refer https://docs.oracle.com/cd/E14571_01/doc.1111/e11011/c05_core003.htm#CSSRG2237 for more details.

      Thanks,

      Kunal

      • Kesava Rao Katuri

        Thanks Kunal for the response.

        I tried this approach as well.

         

        URL

        https://ucf1-zfpu-fa-ext.oracledemos.com:443/idcws/GenericSoapPort

        Request

        <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
           <soap:Body xmlns:ns1="http://www.oracle.com/UCM">
              <ns1:GenericRequest webKey="cs">
                 <ns1:Service IdcService="GET_SEARCH_RESULTS">
                    <ns1:Document>
                       <ns1:Field name="QueryText">dDocTitle &lt;contains> 'Attach'&lt;</ns1:Field>
                    </ns1:Document>
                 </ns1:Service>
              </ns1:GenericRequest>
           </soap:Body>
        </soap:Envelope>

        Response

        <ns2:Field name="StatusMessage">Unable to retrieve search results. The query text is invalid.</ns2:Field>
        <ns2:Field name="QueryText">dDocTitle &lt;contains&gt; 'Attach'&lt;</ns2:Field>
         
        Not sure what is the issue in query text. I got stuck here.
         
        • Kesava Rao Katuri

          This query not working

          <ns1:Field name="QueryText">dDocTitle &lt;contains> 'Attach'</ns1:Field>

        • Jayashree Keerthivasan

          Hi Kesava,

          Can you please have a look at the below Doc Id and try the combinations which are shown as sample examples

          Sample Soap Requests for Use in WebCenter Content (WCC/UCM) 11g Calls to GenericSoapService (GenericSoapPort) (Doc ID 1334471.1)

          Regards,

          Jayashree

           

          • Kesava Rao Katuri

            Thanks Jayashree.

            If I changed the query text as follows

                  <ns1:GenericRequest webKey="cs">
                     <ns1:Service IdcService="GET_SEARCH_RESULTS">
                        <ns1:Document>
                           <ns1:Field name="dDocTitle">&lt;contains> 'Attach'</ns1:Field>
                        </ns1:Document>
                     </ns1:Service>
                  </ns1:GenericRequest>

             

            getting the difference privileges issue

                        <ns2:Document>

                           <ns2:Field name="StatusCode">-32</ns2:Field>

                           <ns2:Field name="IdcService">GET_SEARCH_RESULTS</ns2:Field>

                           <ns2:Field name="StatusMessageKey">!csServiceDataException,GET_SEARCH_RESULTS,getSearchResults!$!csUnprivilegedSystemError</ns2:Field>

                           <ns2:Field name="StatusMessage">Unable to execute service GET_SEARCH_RESULTS and function getSearchResults.

            The error was caused by an internally generated issue. The error has been logged.</ns2:Field>

                           <ns2:Field name="dDocTitle">&lt;contains> 'Attach'</ns2:Field>

                           <ns2:Field name="dUser">BALA.GUPTA</ns2:Field>

                           <ns2:Field name="localizedForResponse">1</ns2:Field>

                        </ns2:Document>

            Is there any issue with webkey="cs" ??? Actually I need to pull the details of a project's attachment.

            I have uploaded that Project attachment using https://ucf1-zfpu-fa-ext.oracledemos.com:443/fscmService/ErpObjectAttachmentService

            Thanks

            Kesava

            • Jayashree Keerthivasan

              Hi Kesava,

              If it is uploaded using ERPObjectAttachementservice , we do have the "downloadAttachment" operation within the same webservice.

              This can be used for downloading the attachment by giving EntityName,CategoryName,UserKeyA and other details.

              Please let me know incase if you need more details on this.

              Regards,

              Jayashree

               

              • Kesava Rao Katuri

                Jayashree

                Basically I need to update the existing project's attachment, uploaded by https://ucf1-zfpu-fa-ext.oracledemos.com:443/fscmService/ErpObjectAttachmentService.

                Since ERP service supports only upload and download, I don't have any option to update the existing file.

                For that I thought update functionality can be achieved by DELETE  and then UPLOAD.

                So trying to fetch the document/attachement details from UCM in order proceed further but stuck on privileges and/or other issues.

                Thanks

                Kesava

            • Kunal Sonje

              Hi Kesava,

              Can you hit https://ucf1-zfpu-fa-ext.oracledemos.com:443/cs/idcplg?IdcService=GET_SEARCH_RESULTS&QueryText=dDocTitle+%3Cstarts%3E+%60Attach%60&ResultCount=20&ftx=&SortField=dInDate&SortOrder=Desc from browser?

              Check if you are getting any results or not?

              Thanks,

              Kunal

              • Kesava Rao Katuri

                Kunal

                It returning empty results

                Thanks

                Kesava

                • Kunal Sonje

                  Hi Kesava,

                  Can you check with https://ucf1-zfpu-fa-ext.oracledemos.com/cs/idcplg?IdcService=GET_SEARCH_RESULTS&QueryText=dDocTitle+%3Cstarts%3E+``&ResultCount=200&ftx=&SortField=dInDate&SortOrder=Desc ?

                  This will return you files uploaded to UCM. Check if it is returning any results or not?

                  Thanks,

                  Kunal