CompShack Blogs

PeopleSoft XML Publisher - Report Development

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

Debugging Functionality in Peoplesoft

Open Configuration Manager -> Profile ->Create.
• Select Connection Type as Application Server.
• Enter Application Server Name
• Machine Name or IP Address should be your machine IP address on which application server domain resides.
• Port Number should be WSL port number.

Turn on Debugger Service. Bring the following changes in your PSAPPSRV.CFG file
Location: \\PS_HOME\appserv\DomainName\
Psappsrv.cfg:
..[People Code Debugger]
;————————————————————————-
PSDBGSRV Listener Port=15000
...
[PSAPPSRV]

Steps for Creating an XML Export File with PeopleSoft

Creating an XML Export File with PeopleSoft
Part of MICA’s web redesign project is going to involve doing data integration between our CMS ( Ingeniux), and our HRMS ( PeopleSoft). Recently I have been playing with XML Publisher, and the flat files that it produces seem so perfect for distribution to our CMS. I was a little disapointed that the XML documents that it creates to further create more documents was not exposed for use as an integration point between systems.
So I began looking for other alternatives.

To create POPUP menu.

Please fin attachment for same.

PeopleSoft XML Publisher Report Development

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

FTP Files in PeopleSoft

PeopleSoft Integration Broker – FTP Files
This article explains how you can download files from FTP servers using Integration Broker. It is usually helpful because it becomes it's quite easy and you don’t have to hard code user id and passwords in SQR, Application Engine or PeopleCode.
We are going to use Integration Broker technology to FTP files. PeopleTools comes with FTPTARGET connector that can be used to GET and PUT the files. You can follow the steps below to play around with the files.

Download file from FTP server:

Setup Web Services in PeopleSoft

PeopleSoft Web Services – Consume Web Service

Web services is a collection of programming techniques including SOAP, WSDL and XML. They are platform indepent. Web services in PeopleSoft gives you the ability to expose PeopleSoft functions and methods to the outside world over HTTP. It also allows PeopleSoft to use Web services made available by different systems. These are easily accessible via standard HTTP and HTTPS protocols.

PeopleSoft ChangeAssistant and Upgrades

If you are looking to learn about PeopleSoft Change Assistant and Upgrades, you can check the below site. It is a nice tutorial on how to do basic setup and use PeopleSoft Change Assistant

PeopleSoft Change Assistant and Upgrades

Search Record

Usually we set the search record for a component in Component property dialog box.

But the search record in component property can be overridden by specifying the search record in Menu Item properties for the same component!