Tuesday, May 26, 2015
BI Publisher API Example – Creating PDF Report from XML/RTF?
Oracle has shared us a set of BI Publisher Java Classes for performing various BI Publisher function like converting RTF to XSL-FO, generating PDF output from XSL-FO and XML etc.
In this post, we will generate a PDF output from XML file using the standard Oracle BI Publisher API’s (Java based).
STEP1: Prepare and Convert RTF template to XSL-FO file
Oracle have provided a Java Class to generate PDF output based on XSL-FO file and XML input. Hence, first step is to generate the XSL-FO file based on RTF template. Details are available in another article,
Now, we should be having a XSL-FO file.
STEP2: Prepare the Java wrapper Class for calling Standard class FOProcessor
import java.io.InputStream;import java.io.OutputStream;import oracle.apps.xdo.template.FOProcessor;import oracle.apps.xdo.template.fo.util.FOUtility;import java.io.*;import oracle.apps.xdo.common.pdf.util.PDFDocMerger;import oracle.apps.xdo.batch.DocumentProcessor;public class convertxmltopdf {public static void main(String[] args){try{FOProcessor processor = new FOProcessor();processor.setData(args[0]); //input XMLprocessor.setTemplate(args[1]); //input XSL templateprocessor.setOutput(args[2]); // output PDF File// Set output format (for PDF generation)processor.setOutputFormat(FOProcessor.FORMAT_PDF);// Start processingprocessor.generate();}catch (Exception e){e.printStackTrace();System.exit(1);}System.exit(0);}}
STEP3: Compile the Java wrapper
javac -classpath $CLASSPATH convertxmltopdf.java
Step 4: Copy the Wrapper Class to JAVA_TOP
cp convertxmltopdf.class $JAVA_TOP
STEP5: Verify the Sample RTF template, XSL-FO file and XML File
Input XML:
![clip_image001[6]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAa4JRilcQU4108al_GFdvUyiyZUop5HobPuDwHltszDAQSat56uCK39TFveBWrrk8IBMd0duk9dEzIK6hxRpSbZA0fXlJEErw2cO6clj1i6OnGODqEeqeenutXynGQbj4v6-3-pa9xh7G/s1600-h/clip_image001%25255B6%25255D%25255B2%25255D.png "clip_image001[6]")
Actual RTF:
![clip_image003[6]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0V7uHi9mcDZNkcbT-CDO1d5InDVfIh5rygtNt4ODqyyY0Fk6HTOOItdGFeDfW21qvt15XUJiYY5QxULECy97OGLALzxBB-UPAUIuRqfQ-iRMNCMI2pU6h8mCuoeCY-kBIZH_kY3Ywz0TW/s1600-h/clip_image003%25255B6%25255D%25255B2%25255D.jpg "clip_image003[6]")
Generated XSL-FO based on Step 1:
![clip_image005[6]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_j_cfeCG5R0AdL0WrFZOhZxXFHaeLrFeoztynSbeIZSC82vanmyGyAHu5RGmCNAKT909V7bNRyrZyd9FJB8fsY52lZMREitYwsIF1gaHRKLVzRdt2zpVsOVd0euu0d9474k0l2G2NxW7_/s1600-h/clip_image005%25255B6%25255D%25255B2%25255D.jpg "clip_image005[6]")
Step6: Place the XSL-FO and Input XML file in Desired Directory and Call the Wrapper Java Class
java -classpath $CLASSPATH convertxmltopdf ./INPUTDATAXML.xml ./RTFTEMPLATEEX.xsl ./RTFTEMPLATEEX.pdf
![clip_image007[6]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQfN6VuY2qtVjuYbx0jplGrBdara3ugSXj0ENkSN856Q-iKbpWnKxQyKGps_awEBxRx8ByBYh4MGfD2e0TNlozk2S5XHXQ3MaPyEyoPh0YRG-TnEm6eYU2rVsewZaNXam4REQnC0rksNZg/s1600-h/clip_image007%25255B6%25255D%25255B2%25255D.jpg "clip_image007[6]")
Output PDF:
![clip_image009[6]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSmCAr71wljRUacGyzegjsT-6T2QR97T7jD1vq36KdWERzDbUffxDkmR_C9dGbAbWi_p0Pfa0s-2qZrMaLT-b_pJWM2Qz6JQcDBklN4lxclM0RiEpO79Idi6WAymf3XWjy6wfDd8xd7lx4/s1600-h/clip_image009%25255B6%25255D%25255B2%25255D.jpg "clip_image009[6]")
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
1 Responses to “BI Publisher API Example – Creating PDF Report from XML/RTF?”
February 28, 2021 at 9:10 PM
Hi Team,
Do we have a way to we can call the XML report which is attached in data definition via API. I understand this example is placing the data definition and RTF template at the particular direcotry and processing the output. But i like to know is there a way where we can use the data definition which is attached in the XML administrator respondibility data defintion screen. Thanks in advance.
Post a Comment