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

Peoplesoft Data Mover:

Data Mover is an administrative tool used by DBA’s. It is used for many purpose as mentioned:

• It is used to move data from one database to another.
• With Data mover we can create scripts not objects.
• To install PeopleSoft database we require Data Mover.
• using Data Mover we can take backup of data.
• We can rename record’s and field’s
• We can encrypt the password field that exists in PSOPRDEFN record.
• We can grant access to user’s using grant command.

DATA MOVER

Data Mover can be login in two modes:

1. Normal Mode
2. Bootstrap Mode

1. Normal Mode :- In normal mode we can login with the peoplesoft userid and password. In short the PIA userid and password. e.g. Default PS/PS

2. Bootstrap Mode :- In Bootstrap mode we login with database access id and ssword e.g. sa / sa for SQL server and SYSADM / SYSADM for oracle by default.

Data Mover Commands:

• IMPORT
• EXPORT
• REPLACE_ALL
• REPLACE_DATA
• RENAME
• ENCRYPT_PASSWORD
• GRANT
• SET

Data Mover command one example:

• IMPORT

SET LOG D:\IMPORT.LOG

SET INPUT D:\IMPORT.DAT

IMPORT *

IMPORT PSOPRDEFN

Peoplesoft jdk 7 Install

peoplesoft application server

Create Peoplesoft Oracle database

Peoplesoft Tuxedo Application Server Install