goerppro's blog

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

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.