Creating Oracle BI Publisher Report using Template Builder / Blogs / Perficient

Template Builder is an add-in to Microsoft Word that simplifies the development of RTF templates for creating Reports.

In this example we will create a template for an Invoice which will be used to create an Invoice Report in BI.

Create a New Data Model .
In This example , the following SQL Query is used and the Data is generated.

select C.PARTY_NAME,C.ADDRESS1,C.CITY,C.STATE,

O.NAME,O.OPTY_ID,O.EFFECTIVE_DATE,

R.QTY,R.UNIT_PRICE,R.REVN_AMT,R.COST_AMT,R.EXPECT_AMT,

P.INTERNAL_NAME

FROM

HZ_PARTIES C,MOO_OPTY O,MOO_REVN R,QSC_PROD_GROUPS_B P

WHERE (C.PARTY_TYPE = ‘ORGANIZATION’)

AND (O.NAME = ‘New Invoice’)

AND (O.CUST_PARTY_ID =C.PARTY_ID )

AND (O.OPTY_ID = R.OPTY_ID)

AND (R.PROD_GROUP_ID = P.PROD_GROUP_ID)

ORDER BY O.LAST_UPDATE_DATE DESC

Choosing a Global Software Development Partner to Accelerate Your Digital Strategy

To be successful and outpace the competition, you need a software development partner that excels in exactly the type of digital projects you are now faced with accelerating, and in the most cost effective and optimized way possible.

Get the Guide

Note: (Create Sample Data by selecting the option Save As Sample Data)

Then, we shall create a RTF Template using Microsoft Word Template Builder.

Select the Data Model from the Catalog and Click on Create Report.

5.After the report is created the template can be designed by adding fields, Tables or forms. The functionalities of Word can be used to enhance the template design.

6.Save the template as RTF file and on the BI, and create a New Report. In this Case we are using the Data Model that was created earlier to build the Report.