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 […]
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 reading1.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 […]
Continue readingIn 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 […]
Continue readingPeopleSoft 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 […]
Continue readingThe 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 […]
Continue readingPeopleSoft 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 […]
Continue readingAs 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 […]
Continue readingPurpose of this article is to answer FAQs about PeopleSoft and COBOL Compilers and let you know the PeopleSoft Cobol Compiler options you have. Some PeopleSoft applications use routines written in COBOL. Since COBOL is primarily suited to batch processing, you’ll likely use COBOL with applications like PeopleSoft Payroll. There are two components for running […]
Continue readingWhat is PeopleSoft Batch Environment? Its a combination of databases, the batch server, the process files (located on the batch server or elsewhere) any clients that run batch routines and all process scheduler services. Batch environment allows us to run pre programmed routines either on demand or on a scheduler. Along with its work to […]
Continue reading