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 readingAs 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 readingAs 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 readingPSPRCSRV:( 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 readingPeople 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 readingConfiguring PeopleSoft Process Scheduler Select 1. to Create a Process Scheduler Server Enter the name of the Database Confirm the Configuration Enter the user id Enter a password for the User Id Enter the Server name Enter 4. to Load the Configuration Enter 1. Start the Process Scheduler Server Watch YouTube Video
Continue readingPeopleSoft 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 […]
Continue readingOracle 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 readingPeopleSoft 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 […]
Continue reading1) 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 readingTUXEDO 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 readingContinued 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 […]
Continue reading1. 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 readingWhat 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 readingFollowing 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 readingHow 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 readingNote: 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 reading1. 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 […]
Continue reading