Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Uvaraja Sadhana
    BIP Report to read file from UCM
    Topic posted February 12, 2019 by Uvaraja SadhanaRed Ribbon: 250+ Points, tagged BI Publisher, OBI Answers, OBIEE Answers, Reports 
    301 Views, 5 Comments
    Title:
    BIP Report to read file from UCM
    Summary:
    Need to read file in UCM using BIP Report
    Content:

    Hi Team,

    Could you please let us know whether it is possible to read file from UCM via BIP report ? If anyone has document could you please share.

    Regards,

    Uva

    Comment

     

    • Zoltan Tar

      Hi Uva

      We have built a report which is Content Server data source to show a txt file content in the report output.

      The file was an attachment for an object, so we have built a simple SQL query to select out the right attachment record, then added a Content Server data source and connected the SQL with Content server group using DM_VERSION_NUMBER column from fnd_documents_tl table.

      Regards,

      Zoltan

      • Karl Zettlemoyer

        Hello Zoltan,

        I am attempting to pull documents from UCM from an OTBI report (accessed through dashboard) and found your post and wondering if you can share how you did this. I have created what you mention above (screen Shot attached) & it returns the data, but I need the actual image displayed or a link to click on to view. Ideally I would have to a group of images belonging to the same employee (same as displayed from the skills & qualifications Attachment Section Screen). Any advice or feedback is greatly appreciated. 

        Thanks Much!

        Regards,

        Karl

    • Uvaraja Sadhana

      Hi Zoltan,

      Thanks for your reply.

      I assume, in your case File was uploaded by Ess Job, am i correct  ?

      But, in my case, if I manually upload Text file to UCM using File Import/Export. Can I view that text file using BI Report ?

       

      Thanks in advance.

      Uva

      • Zoltan Tar

        Hi Uva,

        In our case the file was uploaded using the Attachment feature that's why it was reachable through attachment tables.

        Regarding manual upload: The Content Server component is requiring at least one SQL query in the same model prior adding a Content Server data source this SQL should provide file metadata (somehow) So after manual upload you need to select out the file meta data somewhere from Fusion, but I am not aware about the place.

        Regards,

        Zoltan

      • Volodymyr Faranosov

        Hi Uva,

        Have you been able to achieve your requirements? We have a similar one and I am wondering if it's doable?

        Kind regards,

        Volodymyr