What are Important Files on PeopleSoft Web Server

As you would know that PeopleSoft has several different components which have their own role to play in PeopleSoft Architecture. These components have different file structures and contains important executables and configuration files. We have listed the directory structure of these major PeopleSoft components and compiled a list of important directories and file within them. […]

Continue reading
1

What are Important Files on PeopleSoft Application Server

As you would know that PeopleSoft has several different components which have their own role to play in PeopleSoft Architecture. These components have different file structures and contains important executables and configuration files. We have listed the directory structure of these major PeopleSoft components and compiled a list of important directories and file within them. […]

Continue reading

What are Important Files in Tuxedo Directory

As you would know that PeopleSoft has several different components which have their own role to play in PeopleSoft Architecture. These components have different file structures and contains important executables and configuration files. We have listed the directory structure of these major PeopleSoft components and compiled a list of important directories and file within them. […]

Continue reading
2

What are Important Files on PeopleSoft Process Scheduler

As you would know that PeopleSoft has several different components which have their own role to play in PeopleSoft Architecture. These components have different file structures and contains important executables and configuration files. We have listed the directory structure of these major PeopleSoft components and compiled a list of important directories and file within them. […]

Continue reading

What are the Processes running on Process Scheduler

PSPRCSRV:( PSPRCSRV.EXE) The server agent is responsible for starting all server processes Ever fifteen seconds it looks into the process request for server processes that are scheduled to run If nothing is scheduled the server agent “sleeps for 15 seconds and checks again If a server process is scheduled the server agent combines the data […]

Continue reading

Mandatory Processes in PeopleSoft Application Server

People soft processes are designed to communicate with database. At the direction of WSH/JSH, the PS process queries the database and objects using SQL. The Mandatory PS processes are 1.     PSAPPSRV 2.     PSSAMSRV 3.     PSQRYSRV 4.     PSQCKSRV 5.     Specialized Services PSDBGSRV PSOPTENG PSBRKDSP PSBRRHND PSPUBDSP  (Dispatcher) PSPUBHND (Handler) PSSUBDSP PSSUBHDN What are these PeopleSoft processes […]

Continue reading

Commands To Manage PIA on OAS WebServer

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 […]

Continue reading

PeopleSoft DBA Interview Questions – Part3

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? […]

Continue reading

What are Tuxedo Processes

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 […]

Continue reading
1

Applying Oracle Patches in PeopleSoft

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 […]

Continue reading

PeopleCode Interview Questions – Part1

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 […]

Continue reading
1

SQL to Retrieve Navigation of a Process in PeopleSoft

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) […]

Continue reading

How to Find Unused Permission List in PeopleSoft

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 […]

Continue reading
3

PeopleSoft DBA Interview Questions – Part2

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 […]

Continue reading