Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Uvaraja Sadhana
    BIP Report to read file from UCM
    Topic posted February 11, 2019 by Uvaraja SadhanaRed Ribbon: 250+ Points, tagged BI Publisher, OBI Answers, OBIEE Answers, Reports 
    143 Views, 3 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

    • 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