Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Extracting file attachments associated with Fusion entities

Received Response
465
Views
3
Comments
Pankaj Arora-23597
Pankaj Arora-23597 Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Summary

Extracting file attachments associated with Fusion entities

Content

Fusion Applications support file attachments to be associated with Fusion objects/tables e.g., Sales Order object. If one creates a BIP report to extract one sales order at a time (say in XML format), what should be done to also get the associated attachments for that sales order all downloaded together? Is this something that BI Publisher supports? If so, could you please point to the documentation that describes this.

Answers

  • timdexter
    timdexter Rank 6 - Analytics Lead

    Its going to depend on the format of the attachments. There are ways to embed HTML and images in the layout template inline to a PDF output.

    There are also a set of java APIs that allow you to attach any files to an existing PDF output.

    1. There is one that allows you to append PDF documents to an existing PDF - PDFDocMergeer

    2. Another than lets you embed attachments inside the PDF rather than append - PDFFileAttacher

    Both are covered herehttps://blogs.oracle.com/xmlpublisher/file-attachments

    Cheers

    Tim

  • Pankaj Arora-23597
    Pankaj Arora-23597 Rank 1 - Community Starter

    Thanks, Tim.

    My question was somewhat different. Fusion Applications (FA) have a central repository to store file attachments. The FK reference to the appropriate table in FA that the attachment corresponds to is stored in this repository (UCM) along with that table/entity name.

    Given this, how can one create a BI Publisher report that can produce an output that consists of the content from the parent table as well as the associated attachments from UCM? So if a given row in some FA table has 3 associated attachments, the output would be the xml file (with the data in that row) plus the 3 attachment files (archived into a zip file, say).

  • timdexter
    timdexter Rank 6 - Analytics Lead

    Hi

    If you want to pull the attachment files and zip them and then attach them to the BIP output. Thats a post processing step for your code. The BIP APIs that I mentioned could help you out but that functionality would reside in your code ie BIP can not pull, zip (or not zip) and attach on its out, out of the box.

    Regards

    Tim