myPeopleSoft

PeopleSoft Community Network

PeopleSoft Questions and Answer

1. What is PIA and what are its components?
It is n-tier architecture. We have client, web server, application server and Database server. We have jolt and tuxedo. We have WSL, WSH, JSL, JSH, QUEUES and services.
In database server we have system tables, peopletools tables and application tables.

2. Differentiate Field edit and Save edit?In Field edit for each field change, a transition to the application server to the database is taken place. In Save edit for all the fields, only one transition to the application server to the Database is taken place.

3. What are think time functions?
Think-time functions suspend processing either until the user has taken some action (such as clicking a button in a message box), or until an external process has run to completion.

4. In which events error & warning are used most extensively.
Field edit, Save edit, Search save, row delete, row insert.

5. Is there any way by which you can find out whether the user is in Add mode or Update mode?
%mode---returns A---for Add mode. Returns U –for Update mode

6. What is the purpose of the SQLEXEC function? What are its benefits and draw backs?
SQLEXEC is used to execute the sql statements (select, insert,update,delete).
We can get only one row at a time.