Product Master Data Management

Get Involved. Join the Conversation.

Topic

    Shyam Lakshman
    Notice of feature deprecation in Product Hub Cloud
    Topic posted January 3, 2019 by Shyam LakshmanSilver Medal: 2,000+ Points, last edited August 16, 2019, tagged Product Commercialization, Product Hub 
    83 Views, 1 Comment
    Title:
    Notice of feature deprecation in Product Hub Cloud
    Content:

    The following web service operations will not support Attachments of type File in base64 encoding starting Update 19C:

    Item Version 2 SOAP service - findItem, createItem, mergeItem, processItem operations

    Trading Partner Item Version 2 SOAP service - findTradingPartnerItem, create, merge, process operations

    Using these web services to upload/retrieve attachments in base64 encoding was very inefficient and hence will not be supported going forward.  Instead, the DocId of the attached file will returned in the find payload.  Using the DocId the attachment can be retrieved either using the WCC Document Transfer Utility or web service.

    Comment

     

    • Shyam Lakshman

      The following 2 alternatives are available to get attachments using the web services:

      1. Upload files to UCM in /Contribution Folders first(RIDC upload tool or SOAP Web service) and then provide the path and file name in DmFolderPath and FileName attributes.

      <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

                      <soap:Body>

                                      <ns1:createItem xmlns:ns1="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/types/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

                                                      <ns1:item xmlns:ns2="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/">

                                                                      <ns2:OrganizationCode>V1</ns2:OrganizationCode>

                                                                      <ns2:ItemClass>Root Item Class</ns2:ItemClass>

                                                                      <ns2:ItemNumber>DR_ITEM_ATTACH_SOAP_REV_23May19_3</ns2:ItemNumber>                                                                                                               

                                                                      <ns2:ItemDescription>desc</ns2:ItemDescription>

                                                                      <ns2:PrimaryUOMValue>Each</ns2:PrimaryUOMValue>

                                                                      <ns2:ItemDescription>desc</ns2:ItemDescription>

                                                                      <ns2:ItemStatusValue>Active</ns2:ItemStatusValue>

                                                                      <ns2:ItemClass>Root Item Class</ns2:ItemClass>

                                                                      <ns2:LifecyclePhaseValue>Design</ns2:LifecyclePhaseValue>

                                                                      <ns2:UserItemTypeValue>Finished Good</ns2:UserItemTypeValue>

                                                                      <ns2:ItemRevision>

                                                                                      <ns2:RevisionCode>B</ns2:RevisionCode>

                                                                                      <ns2:ItemRevisionDescription>Rev Desc</ns2:ItemRevisionDescription>

                                                                                      <ns2:RevisionReasonValue></ns2:RevisionReasonValue>

                                                                                      <ns2:EffectivityDate>2019-12-06T16:55:21</ns2:EffectivityDate>                                                                                                                                                          

                                                                                      <ns2:RevisionAttachment xmlns:ns3="http://xmlns.oracle.com/apps/flex/fnd/applcore/attachments/model/">

                                                                                                      <ns2:DatatypeCode>FILE</ns2:DatatypeCode>

                                                                                                      <ns2:DatabaseDescription>desc</ns2:DatabaseDescription>

                                                                                                      <ns2:FileName>F2.txt</ns2:FileName>

                                                                                                      <ns2:UsageType>S</ns2:UsageType>

                                                                                                      <ns2:DatabaseTitle>F2.txt</ns2:DatabaseTitle>

                                                                                                      <ns2:CategoryName>MISC</ns2:CategoryName>

                                                                                                      <ns2:DownloadStatus>N</ns2:DownloadStatus>

                                                                                                      <ns2:SharedFlag>false</ns2:SharedFlag>

                                                                                                      <ns2:DmFolderPath>/Contribution Folders/PIM</ns2:DmFolderPath>

                                                                                                      <ns2:DmRepository>FusionAppsContentRepository</ns2:DmRepository>                                                                               

                                                                                      </ns2:RevisionAttachment>                                                                       

                                                                      </ns2:ItemRevision>                                      

                                                      </ns1:item>

                                      </ns1:createItem>

                      </soap:Body>

      </soap:Envelope>

       

      1. Provide corresponding file DmDocumentId and DmVersionNumber attribute values directly in item soap service using the following payload

       

      <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

                      <soap:Body>

                                      <ns1:createItem xmlns:ns1="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/types/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

                                                      <ns1:item xmlns:ns2="http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/">

                                                                      <ns2:OrganizationCode>V1</ns2:OrganizationCode>

                                                                      <ns2:ItemClass>Root Item Class</ns2:ItemClass>

                                                                      <ns2:ItemNumber>DR_ITEM_ATTACH_SOAP_08Aug19_1</ns2:ItemNumber>                                                                                                               

                                                                      <ns2:ItemDescription>desc</ns2:ItemDescription>

                                                                      <ns2:PrimaryUOMValue>Each</ns2:PrimaryUOMValue>

                                                                      <ns2:ItemDescription>desc</ns2:ItemDescription>

                                                                      <ns2:ItemStatusValue>Active</ns2:ItemStatusValue>

                                                                      <ns2:ItemClass>Root Item Class</ns2:ItemClass>

                                                                      <ns2:LifecyclePhaseValue>Design</ns2:LifecyclePhaseValue>

                                                                      <ns2:UserItemTypeValue>Finished Good</ns2:UserItemTypeValue>

                                                                      <ns2:ItemAttachment xmlns:ns5="http://xmlns.oracle.com/apps/flex/fnd/applcore/attachments/model/">

                                                                                      <ns2:DatatypeCode>FILE</ns2:DatatypeCode>

                                                                                      <ns2:DmDocumentId>UCMFA00095394</ns2:DmDocumentId>

                                                                                      <ns2:DmVersionNumber>95394</ns2:DmVersionNumber>

                                                                                      <ns2:CategoryName>MISC</ns2:CategoryName>                                                                            

                                                                      </ns2:ItemAttachment>

                                                                      <ns2:ItemRevision>

                                                                                      <ns2:RevisionCode>B</ns2:RevisionCode>

                                                                                      <ns2:ItemRevisionDescription>Rev Desc</ns2:ItemRevisionDescription>

                                                                                      <ns2:RevisionReasonValue></ns2:RevisionReasonValue>

                                                                                      <ns2:EffectivityDate>2019-12-06T16:55:21</ns2:EffectivityDate>                                                                                                                                                                 

                                                                                      <ns2:RevisionAttachment xmlns:ns3="http://xmlns.oracle.com/apps/flex/fnd/applcore/attachments/model/">

                                                                                                      <ns2:DatatypeCode>FILE</ns2:DatatypeCode>

                                                                                                      <ns2:DmDocumentId>UCMFA00095394</ns2:DmDocumentId>

                                                                                                      <ns2:DmVersionNumber>95394</ns2:DmVersionNumber>

                                                                                                      <ns2:CategoryName>MISC</ns2:CategoryName>

                                                                                                                                                                                     

                                                                                      </ns2:RevisionAttachment>                                                                       

                                                                      </ns2:ItemRevision>                                                                      

                                                      </ns1:item>

                                      </ns1:createItem>

                      </soap:Body>

      </soap:Envelope>

       

       

      Following is the payload to upload file to UCM and wsdl (https://host.us.oracle.com:443/idcws/GenericSoapPort?wsdl)

       

      <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_UNIVERSAL">

                      <ucm:User />

                      <ucm:Document>

                          <ucm:Field name="dDocTitle">DR_FILE_F5</ucm:Field>

                          <ucm:Field name="dDocType">Document</ucm:Field>

                          <ucm:Field name="dDocAuthor">PIMQA</ucm:Field>

                          <ucm:Field name="dSecurityGroup">FAFusionImportExport</ucm:Field>

                          <ucm:Field name="dDocAccount">scm$/item$/import$</ucm:Field>                   

                          <ucm:File href="DR_FILE_F5_href.txt" name="primaryFile">

                                    <!-- Base64 content-->

                              <ucm:Contents>VGhpcyBpcyB0ZXh0IHR5cGUgYXR0YWNobWVudA==</ucm:Contents>

                          </ucm:File>

                      </ucm:Document>

                  </ucm:Service>

            </ucm:GenericRequest>

         </soapenv:Body>

      </soapenv:Envelope>