Product Master Data Management

Get Involved. Join the Conversation.

Comments

  • Abhishek Sahu

    Hi Vignesh , 

    Thanks for your prompt reply. Client doesn't have Oracle ICS so this option is ruled out. Is it possible to enter web services details inside SOA composite used for PDH ?

    Audit Report means BI report ? If yes, for email and FTP options , user has to poll for files, for which they are not ready. Also, we are generating files at UCM location using publication framework in PDH ?

    Please let me know your thoughts.

    Regards

    Abhishek

     

  • Vignesh Chandran

    Did you have adfdi plugin in your excel. 

  • Vignesh Chandran

    hi Abhishek,

    with Middleware: Using ICS sales cloud adapter, you can trigger the items updated to another system

    without middleware: using audit report, send as email or FTP method. 

    Regards,

    Vignesh Chandran

  • Abhishek Sahu

    Hello Vignesh, 

    Did you face any requirement of sending change in items information to third party application. I am looking for information on sending information in real time to client application either from UCM or on trigger of event in PDH. Client is not ready to Pool UCM. So, how to notify them in case of change.

    Regards

    Abhishek

  • Gaurav Kasliwal

    Cool. Thanks!

  • Vignesh Chandran

    Thanks Gaurav !

    I tried with another way . Please see the below information. 

    Upload the document to UCM - using webservice:

     

    Webservice WSDL : https://XXXXXXX/publicFinancialCommonErpIntegration/ErpIntegrationService?WSDL

     

    We can upload the csv, txt or zip(it contain any). The only thing we need to convert that file into base64 encoding. That encoded detail we need to use in content tag of the xml request payload.

     

    Request payload:

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/" xmlns:erp="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/">

       <soapenv:Header/>

       <soapenv:Body>

          <typ:uploadFileToUcm>

             <typ:document>

                <erp:Content>UEsDBBQAAAAIACFkKUzuzkTbVIUEANzXBAAHAAAASUNTLnBkZqxaBVxT3xfHn4FOsRgiUkNAhgijkVZSOmVKSgwYscGAUQIqDqRDQloGiEgp3SgoHdKMbYR0i5T0/yH/…MIME ENCODED CONTENT…+bTci/3qP+aWLmLu4/bLp/piSqDCYioKLS15N4Y+dWPi/SU5I3QXuAfglp5+7sJabI+CXt3YmbxgIBPo17x8AUEsBAj8AFAAAAAgAIWQpTO7ORNtUhQQA3NcEAAcAJAAAAAAAAAAgAAAAAAAAAElDUy5wZGYKACAAAAAAAAEAGAAPl4XjF4nTAan6hOMXidMBW6GKwBeJ0wFQSwUGAAAAAAEAAQBZAAAAeYUEAAAA</erp:Content>

             <erp:FileName>Attach10.zip</erp:FileName>

                <!--Optional:-->

                <erp:ContentType>zip</erp:ContentType>

                <!--Optional:-->

                <erp:DocumentTitle>attachzip</erp:DocumentTitle>

                <!--Optional:-->

                <erp:DocumentAuthor>ICS.admin</erp:DocumentAuthor>

                <!--Optional:-->

                <erp:DocumentSecurityGroup>FAFusionImportExport</erp:DocumentSecurityGroup>

                <!--Optional:-->

                <erp:DocumentAccount>scm$/item$/import$</erp:DocumentAccount>

                <!--Optional:-->

                <erp:DocumentName>ATTACH10000010</erp:DocumentName>

             </typ:document>

          </typ:uploadFileToUcm>

       </soapenv:Body>

    </soapenv:Envelope> 

  • Gaurav Kasliwal

    Hi Vignesh,

     https://<your pod detail>/idcws/GenericSoapPort?wsdl is the WSDL used to upload file. Below is the sample payload that you can try in SOAP UI. In the below payload Contents tag contain the base64 format of the file that you want to upload. Make the necessary changes in the file location. In addition, you need to provide user name and password in Auth(Basic) tab in SOAP UI.

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ucm="http://www.oracle.com/UCM">
       <soapenv:Header>
        </soapenv:Header>
       <soapenv:Body>
          <ucm:GenericRequest webKey="cs">
             <ucm:Service IdcService="CHECKIN_UNIVERSAL">
                <ucm:Document>
                      <ucm:Field name="dDocTitle">PersonAccrualDetail</ucm:Field>
                      <ucm:Field name="dDocType">Document</ucm:Field>
                      <ucm:Field name="dDocAuthor">HCM.USER</ucm:Field>
                      <ucm:Field name="dSecurityGroup">FAFusionImportExport</ucm:Field>
                      <ucm:Field name="dDocAccount">hcm$/dataloader$/import$</ucm:Field>
                      <ucm:File name="primaryFile" href="PersonAccrualDetail.zip" >
                         <ucm:Contents>UEsDBBQAAAAIAJyL7krm624TqAAAAO4AAAAXAAAAUGVyc29uQWNjcnVhbERldGFpbC5kYXRtjssKwjAURPeC/+AfNJVC6TKQYBX7oA3qTmJ6F9UmkTRBCvfjrVDBhcuZ4TCn4IIyKijW4EZrqFIuyIGBl/2ASxLTE5a9DPoGDutBmlJqwLN1DwFOj9/BWdUx6QFPcgiAtLuH0WswvgE589ja4BS00+hBVy8zI7/NvluvCt7s+H8ddqhEjpdLRkg2Hyjpe2s2HxnkYqm3JE4jkkZxgjFB5EXOjgtyTd5QSwECFAAUAAAACACci+5K5utuE6gAAADuAAAAFwAAAAAAAAABACAAAAAAAAAAUGVyc29uQWNjcnVhbERldGFpbC5kYXRQSwUGAAAAAAEAAQBFAAAA3QAAAAAA</ucm:Contents>
                      </ucm:File>
                   </ucm:Document>
             </ucm:Service>
          </ucm:GenericRequest>
       </soapenv:Body>
    </soapenv:Envelope>

     

     

    Thanks!

  • Vignesh Chandran

    hi Magesh,

     

    I tried this, its working....some modification.

     
                <item:ItemAttachment>
                   <item:DatatypeCode>FILE</item:DatatypeCode>
                   <item:UsageType>S</item:UsageType>
                   <item:DmType>Document</item:DmType>
                   <item:DmDocumentId>UCMFA00003256</item:DmDocumentId>
                   <item:DatabaseTitle>XXXXGenerator.zip</item:DatabaseTitle>
                   <item:Attachment>XXXXGenerator.zip</item:Attachment>
                   <item:DmRepository>FusionAppsContentRepository</item:DmRepository>
                   <item:CategoryName>MISC</item:CategoryName>
                   <item:DownloadStatus>Y</item:DownloadStatus>
     
    Thanks !
    Vignesh Chandran
  • Magesh Kesavapillai

    You may want to check with Webcenter team.
    I have come across one CHECKIN_UNIVERSAL service: https://docs.oracle.com/cd/E14571_01/doc.1111/e11011/c05_core003.htm#CSSRG2201

  • Vignesh Chandran

    Thanks ! Magesh. 

    I will try this one. Do you have any idea to bring the physical file to UCM using Webservice. 

     

    I saw this webservice in instance.  

    • ERP Object Attachment Service. 

    Will this work? 

     

    Regards,

    Vignesh Chandran

  • Magesh Kesavapillai

    It is supported, though I havenot tried. A sample here:


                             <ns2:DatatypeCode>FILE</ns2:DatatypeCode>
                             <ns2:DatabaseDescription>***</ns2:DatabaseDescription>
                             <ns2:FileName>ABC.zip</ns2:FileName>
                             <ns2:UsageType>S</ns2:UsageType>
                             <ns2:DmFolderPath>Folder/Path</ns2:DmFolderPath>
                             <ns2:DatabaseTitle>Title</ns2:DatabaseTitle>
                             <ns2:DmRepository>FusionAppsContentRepository</ns2:DmRepository>
                             <ns2:DocumentAttributes></ns2:DocumentAttributes>
                             <ns2:CategoryName>Category</ns2:CategoryName>
           <ns2:DmType>Document</ns2:DmType>
                             <ns2:DownloadStatus>N</ns2:DownloadStatus>

  • Gopinath Kartheesan

    Try this query

    select hz.party_name, hz.party_id, hza.party_usage_code from HZ_PARTY_USG_ASSIGNMENTS hza, hz_parties hz where hz.party_id = hza.party_id and hza.party_usage_code = 'MANUFACTURER'

  • Courtney Mark

    You are correct.  If you query up a few manufacturers, yes you can export to Excel.  I need to export ALL manufacturers, so I don't want to have to enter a bunch of queries to then export them in each query.

  • Gopinath Kartheesan

    You should be able to do this from the UI where you can inquire for Trading partners with type as "Manufacturer" and export them or you can get it from OTBI report.

  • Courtney Mark

    Is there an export option for all manufacturers?