How Does PeopleSoft Works

by Prashant January 24, 2013

PeopleSoft Architecture has several components but it becomes important to understand the complete flow of transactions in PeopleSoft. Below post will help your understand how PeopleSoft works and how a request sent by an user is interpreted and results sent back to user. It will not only help technical team but anyone who wants to […]

Read the full article →

Commands To Manage PIA on OAS WebServer

by Prashant January 22, 2013

Oracle Application Server can be used as a Webserver for installing PIA Website. As part of maintenance of Peoplesoft environment on OAS webserver, you would need to fire commands to start, stop, install, uninstall , check status and various other similar commands. Here is a cheat sheet of some of those most commonly used commands […]

Read the full article →

Components of a PeopleSoft System

by Prashant January 20, 2013

PeopleSoft Enterprise Solution is made up of an architecture which involves usage of several types of servers each playing a critical  part in the functioning of PeopleSoft Application. Here is a listing of PeopleSoft Components with a brief description of services it provides. If you want to read more about each of these components, you […]

Read the full article →

PeopleSoft DBA Interview Questions – Part3

by Prashant January 20, 2013

1)      Tell about yourself and responsibilities ? 2)      What are the  basic day to day activities? 3)      What is report notes? 4)      What is jolt? 5)      What is PIA? 6)      What are the basic services? 7)      What is the PeopleSoft security? 8)      In 7.5 to 8.8 what is the security difference? 9)      Difference in All ID? […]

Read the full article →

What are Tuxedo Processes

by Prashant January 19, 2013

TUXEDO stands for Transactions for UniX Extended for Distributed Operations. Tuxedo is one of the most important base on which PeopleSoft Application Server is based. When an application server is booted there are several Tuxedo services that are started along with other Application Server processes. A)  BBL: ( Bulletin Board Liaison) The Bulletin Board Liaison […]

Read the full article →

PeopleSoft Jobs – PeopleSoft Interview Questions Set # 02

by Kelly January 18, 2013

Continued from PeopleSoft Jobs – PeopleSoft Interview Questions Set # 01 Looking for a PeopleSoft job? We’re here to help. We’ve compiled a huge database of PeopleSoft interview questions, which will help you sail through any interview for PeopleSoft jobs. The questions in this and other posts on “PeopleSoft Interview Questions” are good to know […]

Read the full article →

Applying Oracle Patches in PeopleSoft

by Prashant January 17, 2013

1. Overview Patch sets are a mechanism for delivering fully tested and integrated product fixes on a regular basis. Patch sets provide bug fixes only; they do not include new functionality, and do not require certification on the target system. Patch sets include all the libraries that have been rebuilt to implement the bug fixes […]

Read the full article →

PeopleCode Interview Questions – Part1

by Prashant January 16, 2013

What is the difference between SQL Object and SQL Exec? SQL Object can be used with Fetch to return multiple rows, whereas SQLExec can fetch only one row. What is the difference between User defined and System Defined Variables? User-defined variables These variable names are preceded by an & character wherever they appear in a […]

Read the full article →

SQL to Retrieve Navigation of a Process in PeopleSoft

by Apurva T. January 16, 2013

Following SQL is used to find out all Processes Defined in PeopleSoft System. Additionally this query also provides Components attached with Process Definition and Navigation from where this process can be executed. This query is tested on Oracle platform. Select S.prcsname,S.prcstype, S.pnlgrpname,N.navigation From (Select A.prcsname, A.prcstype,B.pnlgrpname From PS_PRCSDEFN A, PS_PRCSDEFNPNL B Where A.prcsname = B.prcsname) […]

Read the full article →

How to Find Unused Permission List in PeopleSoft

by Apurva T. January 15, 2013

How to Find Unused Permission List in PeopleSoft   SELECT * FROM PSCLASSDEFN A WHERE NOT EXISTS ( SELECT ‘X’ FROM PSUSERCLASSVW B WHERE A.CLASSID = B.CLASSID ) AND NOT EXISTS (SELECT ‘X’ FROM PSOPRDEFN B WHERE A.CLASSID = B.OPRCLASS) AND NOT EXISTS (SELECT ‘X’ FROM PSOPRDEFN B WHERE A.CLASSID = B.PRCSPRFLCLS) AND NOT EXISTS […]

Read the full article →

PeopleSoft DBA Interview Questions – Part2

by Prashant January 14, 2013

Note: Some of the information related to setup and installation may no longer be valid due to ever changing Operating Systems and application versions/architecture. If you have any specific doubts, please post it in the comment section. 1)      What are the PSDBA responsibilities? Installation of PeopleSoft, upgrades, administration, applying tools& Application patches,fixes &service packs, refreshes of database ,supports PS […]

Read the full article →

Migration of Peoplesoft 3rd Party Objects

by Prashant January 13, 2013

1. Overview Following are a few major 3rd Party tools that are supported by PeopleSoft Applications. Changes are occasionally made to the delivered code in order to suit the business needs as per the customer’s requirements. COBOL SQR nVision Crystal As part of standard requirements, COBOL and SQR program migration needs to be done at […]

Read the full article →

Peoplesoft Upgrade Overview

by Prashant January 12, 2013

  1.What is an Upgrade? A PeopleTools Upgrade updates the underlying PeopleTools tables ( and files ) only. No changes are made to Application data, only PeopleSoft system data is changed. Normally this is a PSAdmin project which does not require Application specialists. Since application data remains untouched, most user would not even know the […]

Read the full article →

Processes Queued in PeopleSoft Process Scheduler

by Prashant January 11, 2013

In Peoplesoft, many times we face the error like the reports are in queued staus for a long time & even if we run more reports, they also go in the same status. There could be number of reasons for it: Process Scheduler could be down. Check the status in Process Monitor> Server List If […]

Read the full article →

How To Bypass PeopleSoft SignOn Page

by Prashant January 5, 2013

PeopleSoft access is controlled by user id/password but sometimes you would need to publish a PeopleSoft page to public i.e users who don’t have access to PeopleSoft. Lets say you want to show the PeopleSoft career page on your company’s website where applicants can apply for job. As these application won’t be having access to […]

Read the full article →

Running a PeopleSoft COBOL in a Unicode Environment

by Apurva T. January 3, 2013

The character set that is used for PeopleSoft COBOL processing must match the character set for your database. If you created a Unicode database for the PeopleSoft system, you must also run COBOL in Unicode. The Unicode standard provides several methods of encoding Unicode characters into a byte stream. Each encoding has specific properties that […]

Read the full article →

What is JOLT and related processes

by Prashant January 3, 2013

PeopleSoft application server relies on Jolt, a companion product that co-exists with Tuxedo, to handle all web requests. In other words, Jolt is the bridge between PeopleSoft application server and the web server (any supported one) that facilitates web communication. Tuxedo helps schedule PeopleSoft application server processes to perform the actual transactions. When the application […]

Read the full article →

Useful Unix Commands for PeopleSoft Administrators

by Prashant January 2, 2013

As a PeopleSoft admin, you will need to perform Unix administration as well (if your appserver or webserver is hosted on a Unix box). There are only a few Unix commands you will need to know to perform Unix administration tasks as a PeopleSoft admin. Note that Unix is case sensitive and you will need […]

Read the full article →