Blogs

Ren Server -- Over View

Hi , This is an over view about REN server.Please go through the attached document

SQR Code

Some times requirement comes to genrate the output file (csv or any other) at the default output directory so that it can be accesible from the Process Monitor's 'View Log/Trace' page.
To achive this below code will be helpful-

[code]
begin-procedure Init-Report

do Stdapi-Init

if $prcs_process_instance = ''
!No Prompt
do Ask-As-Of-Date
else
display 'Going to select-parameters'
do Select-Parameters
end-if
do Init_Printer
do Init_Report_Translation ($ReportID, $Language_cd)

if $language_cd = 'JPN'
let $qualifier = 'NAME_AC'
else

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: