PeopleSoft XML Publisher Report Development

Your rating: None Average: 4.6 (20 votes)

PeopleSoft XML Publisher

This article explains how to create XML Publisher also called BI Publisher reports in PeopleSoft. XML Publisher is the only Reporting platform in the Fusion Application. Before we talk about how to create an XML Publisher report in PeopleSoft, I would like to give a brief overview.

Overview:

XML Publisher consists of the following components:
• Data Source
• Template
• XML Publisher Engine
• Report

Data source can be defined using in the following forms:
1. PS Query
2. Rowset
3. XML File
4. XMLDoc Object
Report template can be created using MS Word. A plug-in for MS Word can be downloaded from Oracle’s website or PeopleSoft application.
XML Publisher Engine takes data source and template and creates a report.

Steps to create XML Publisher Report:

Step 1 – Data Source:

Go to Reporting Tools  XML Publisher  Setup  Data Source. Add a new Data Source. Select either PS Query or Rowset.
If you selected PS Query, first create a Query that you wish to use in your report. Youc can click on ‘Generate’ button to create Sample XML file to be used in report template. Save XML file on your PC.
If you wish to use Rowset then write an Application Engine program that writes Rowset in the form of XML data and XSD schema. Use functions GetXMLData and GetXSDSchema to generate XML file and XSD file for rowset.

Step 2 – Report Template

Let’s create an RTF template using XML file that you created in step 1.
Open MS Word after you have installed the plug-in. You will notice that there are five new buttons. Click on the first button i.e. Data and Load XML file that you created in step 1. Now your sample data is loaded in the template. You can format your report and test it using the loaded data. Save the template.

Step 3 – Report Definition

You are ready to create report definition.
Go to Reporting Tools  XML Publisher  Setup  Report Definition and add a value. Specify the report name, data source type and data source name. There are five tabs in Report Definition.
1. Definition – Specify description and category of report.
2. Template – Upload the template file created in Step 2.
3. Output – Specify the output report format and set a default format.
4. Security – Specify the Role or User who should have access to the report.
5. Bursting – Specify the criteria if you need to burst the report. Leave it blank if bursting is not needed.
Save the report definition.

Step 4 – Process Definition

Write a small Application Engine program that runs the above report definition. Now create a new process definition that runs this Application Engine process.
Your first XML Publisher report is ready. Remember the output of XML Publisher report does not go to Process Monitor. In order to see the report, you need to go to Report Manager.

Go to http://www..gravitonconsulting.com/ for more help.

Try it out and email me if you have any questions info@.gravitonconsulting.com.

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.
Guest's picture
Guest (not verified)
Re: PeopleSoft XML Publisher Report Development

Hi, is it possible to send the XML report to users(or some email accounts) through email. I found the code below in the ORACLE XML PUBLISHER COMPONENTS GUIDE, it talks about bursting engine, but I have no idea where to put the code at? Should it be the in the template.rtf, or sample data file? Can you help? or is there any way that I could do this... Thanks in advance.

<?xml version="1.0" encoding="UTF-8"?>
<xapi:requestset xmlns:xapi="h t t p:/ /x mlns . oracle. com/oxp/xapi">
<xapi:request select="/DATA/DEPTS/DEPT/EMPLOYEES/EMPLOYEE"> <! - Burst
on employee element - >
<xapi:delivery>
<xapi:email server="my.smtp.server" port="25"
from=" email@removed " reply-to ="">
<xapi:message id="123" to="${EMAIL}"
<! - Set the id for the delivery method - ><! - Use the employees
EMAIL element to email the document to
the employee - >cc="${ADMIN_EMAIL}"
<! - Use the ADMIN_EMAIL parameter to CC the document
to the administrator - > attachment="true" subject="Employee
Details for ${ENAME}">
Mr. ${ENAME}, Please review the attached document</xapi:message><! -
Embed the employees name into the email message - >
</xapi:email>
</xapi:delivery>
<xapi:document output-type="pdf" delivery="123"><!Specify the
delivery method id to be used - >
<xapi:template type="rtf"
location="\usr\empDet.rtf"></xapi:template>
</xapi:document>
</xapi:request>
</xapi:requestset>

newAV's picture
User offline. Last seen 9 years 21 weeks ago. Offline
Joined: 02/04/2009
Posts: 3
Re: PeopleSoft XML Publisher Report Development

Really nice and easy to understand doc by "goerppro".
Thanks so much.

saracarrol's picture
User offline. Last seen 9 years 14 weeks ago. Offline
Joined: 09/06/2009
Posts: 2
Re: PeopleSoft XML Publisher Report Development

Thank you very much for the step by step instruction. It seems to me very helpful as well as easy way to create BI publisher. I’ve bookmarked this page. I will share my experience later. Thanks again.

reverse mortgage's picture
reverse mortgage (not verified)
Reply to comment | CompShack.com

You are so interesting! I do not think I've truly read through something like that before. So wonderful to find somebody with unique thoughts on this subject matter. Really.. thank you for starting this up. This website is one thing that is needed on the web, someone with a little originality!