Extracting file attachments associated with Fusion entities

Question

Summary

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.

timdexter · Answer

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

Pankaj Arora-23597 · Answer

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 · Answer

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