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
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]
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.
Please fin attachment for same.
Please find attachment for the same.
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 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:
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.
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
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!
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Recent comments
2 years 16 weeks ago
2 years 21 weeks ago
2 years 21 weeks ago
2 years 22 weeks ago
2 years 23 weeks ago
2 years 23 weeks ago
2 years 25 weeks ago
2 years 27 weeks ago
2 years 30 weeks ago
2 years 36 weeks ago