Setup Peoplesoft Test Framework

Peoplesoft Data Mover commands

Peoplesoft Application Server Boot Issue

Audit in peoplesoft

PeopleSoft audit on a table is done to track the changes done to fields and records. It's a delivered object so we can have to just configure it through application designer and we can see the report.

There are two types of auditing delivered already in PeopleSoft:

1) Field Level
2) Record Level

1) Field Level: Field level auditing tracks changes to one or more fields on a PeopleSoft record and stores the results in the delivered PSAUDIT and PSAUDITEXT table.

2) Record Level: Record level auditing tracks changes to done on peopleSoft record and stores the results in the delivered PSAUDIT table. It is better to for record level audit if your fields are more than four.

Configure Process Scheduler in Peoplesoft

How to take Oracle Database Cold backup

XML Publisher in Peoplesoft

Introduction to peoplesoft XML publisher

• XMl publisher is a peopletools and it is not dependent on windows whereas crystal reports is dependent on windows.
• XML publisher we can run online and batch server both.
• As we know batch server we can run through process scheduler and online processing through application server.

XML publisher phases:

• setup XML  publisher
• create and register data source
• create and upload template
• create XML publisher report
• Run and view XML publisher report.

Sub template:

• start and end template indicators must exist to distinguish those various component.
• within a single sub template file, multiple sub template component can available.

XML Classes:

• PSXP_XMLGEN
• PSXP_RPTDEFNMANAGER
• PSXP_ENGINE
• PSXP_REPORTMGR