Implementation Guide for Oracle Self-Service E-Billing > Using the Reporting Engine > Components Used by the Reporting Engine >

Creating a PDF Template for Reporting

Oracle Self-Service E-Billing provides preconfigured PDF templates for reporting (listed in Table 43). You can also define additional templates to present other reports in PDF.

To create a PDF template for reporting

1. Download and install Oracle Business Intelligence(BI) Publisher at

   http://www.oracle.com/technetwork/middleware/bi-publisher/downloads/index.html

2. Download the existing or new report in XML format and use this file to create a new PDF template (an RTF) file. See the Template Builder for Word Tutorial in Oracle BI Publisher for assistance creating the RTF template. Training is also available on the Oracle Technology Network.
3. Using the toolbar in Oracle BI Publisher, load the report XML file.
4. Use Microsoft Word formatting and Oracle BI Publisher insert functions to add fields, tables, charts, and conditional formatting to the template appropriate for your organization. Save the file as an RTF.
5. After you create the template file filename.rtf, copy the file to EDX_HOME/template/pdf/filename_ll_CC.rtf from the EDX_SYS_LANG table in the OLTP schema . In the template file, filename is the name of the report template. In the directory where you copy the template file, ll_CC is your default system language code.
6. If the application supports multiple languages, then you can translate your template and name it using the different language code. For example, if you support Spanish (es_ES) as well as American English (en_US), then create a template called filename_en_US.rtf and create a translated template called filename_es_ES.rtf.
7. In EDX_HOME/config/rpt/*.xml, add the following line in <downloadlist> tag for the new report:

   <download name="global.dropdown.pdf" type="pdf" description="PDF download" templateId="PDF_TEMPLATE"/>

8. Add the following line in the <templates> tag for the report. In the line, ll_CC is the default language.

   <template id="PDF_TEMPLATE" downloadable="true" name="template/pdf/filename_ll_CC.rtf"/>

   NOTE:  You do not have to specify additional languages in the XML. Oracle Self-Service E-Billing finds the template that corresponds with the selected language.