BI Publisher: Oracle BI Publisher Tab missing on MS Word 2013

After successful installation of BI Publisher , sometimes we don't see the BI Publisher tab not on
the MS Word doc.

Ensure to check below options:
1. All Microsoft related documents are closed like Word/Excel/Outlook etc.
2. See if BI Publisher is checked under Add ins.
3. Still if above options are of no help, try running below setup from BI Publisher Setup.
   C:\\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\DoNetInstallFiles\Setup

  


 

BI Publisher: To continue header onto next page

When we use header in the body of the word document and header is part of table.
To repeat the header on page break, we can make use of the Word document Table Layout properties.

Below is the snapshot.

BI Publisher: Please close MS Word and try again

When you get below error while installing BI Publisher Desktop version make sure that all MS office related items like Outlook,MS Word etc are closed.
Then try installing again.
This would mostly resolve the issue.

Error: Please close MS Word and try again

BI Publisher: Basics in creating a RTF template

BI Publisher in PeopleSoft helps us to view output in different formats.
We use templates to design the output layouts. Let's see a sample example below.

Data Preparation:
I had an XML file which has Band and Description.
There are 20 rows of data. Now lets load this data into the template.

                                           

Loading Data into the Template:           

Open the MS Window and Go to Add-ins tab and click on Data-->Load XML Data. 

Designing the Template:

After that drag the fields from the Field Brower onto the document as shown below.

Below is the final draft of the document which has Band and Description.

Now Click on Preview to view the Output. In the Output our expectation is to view all 20 rows but to our surprise there is only row which comes up. This is because we have not looped through all the rows of XML.

To loop through all the rows, we need to add the for-each tag. Now let's add this tag and view the output.
Tag used in this example: for-each:@row_Band

Now lets see the preview below. As expected now we get all rows in the output.

This completes the sample example of designing a report layout using RTF template.
We will see in next post on how to place headers in the template.

BI Publisher: Run Date and Run Time in the Output Report

In Reports, we generally place the Report Run Date and Run Time in the Output Report.

Lets see how this can be done in BI Publisher.

Open the BI Publisher Template (RTF), insert the Form field and in the options select the Field Type as Current date for Run Date  and Current Time for Run Time.

Below are the snapshot for the same.

 Now save the template and check the Output in the Preview. Below is the sample Output.

Error No 53 BI Publisher

Error No 53  is because the Java Home Path mentioned is either incorrect or Java JRE is not installed.

Lets take a look at the below example.
I had purposefully entered incorrect JRE Path to replicate the issue.

Now , lets validate the BI Publisher template. We get below error message.

 To resolve this issue, Navigate to Tools --> Options --> Preview and correct the Java Home Path as shown below.

 Now Save the Template and then Validate.

This resolves the issue.

BI Publisher: Page number Reset

Agenda: To reset the page number when there is change in invoice number etc.

In the below example , we reset the page number once the Employee DeptID gets changed.

Below is the sample XML data.

Load the XML data successfully into RTF template.
After that get the data from Table Wizard and group the data by Deptid with Section break selected.
Below are the snapshots.

Edit the code in DeptID field and for-each form field as shown below.

 

Add the Page Number to the Footer at the End as show below.

Now save the template and see the preview. The page number gets reset for change in DeptID as shown below.

XML Publisher Passing Run Control values to PS Query as Data Source

XML Publisher.
Data Source:  PS query

Below is the code to pass values from Application Engine State Record to PS Query prompt record.
Input values are FromDate and ThruDate.

The XML Publisher then runs the report based on input values and generates the output.

import PSXP_RPTDEFNMANAGER:*;

local string &sRptDefn = ‘PAYROLL_RPTDFN’;

/* get report definition object */

&oRptDefn = create PSXP_RPTDEFNMANAGER:ReportDefn (&sRptDefn);

&oRptDefn.Get();

/* fill query runtime prompt record */

&rcdQryPrompts = &oRptDefn.GetPSQueryPromptRecord();

&FieldName1 = &rcdQryPrompts.GetField(1).Name;
&FieldName2 = &rcdQryPrompts.GetField(2).Name;

/* MessageBox(0, "", 0, 0, "The First field name is : " | &FieldName1); */

/* MessageBox(0, "", 0, 0, "The Second field name is : " | &FieldName2); */

&rcdQryPrompts.GetField(1).Value = PS_PAYROLL_AET.FROM_DATE;

&rcdQryPrompts.GetField(2).Value = PS_PAYROLL_AET.TO_DATE;

If Not &rcdQryPrompts = Null Then

  &oRptDefn.SetPSQueryPromptRecord(&rcdQryPrompts);

End-If;

/*generate report*/

&oRptDefn.ProcessReport (&sTmpltID, &sLangCd, &AsOfDate, &sOutFormat);

/*publish report */

XML Publisher Migration objects

The following definition types can be added to projects in Application Designer:

• XMLP Data Src Defn.
  
• XMLP File Defn.
  
• XMLP Report Defn.
  
• XMLP Template Defn.

If the data source for the XMLP report is PS Query or Connected Query, then the query or connected query definition should also be included in the project.

Source: Peopletools 8.50

XML Publisher named as BI publisher in 8.52
 Definition types
BIP DataSource Definitions
BIP File Definitions
BIP Report Definitions
BIP Template Definitions.

Source: Peopletools 8.52