Latest PeopleSoft Interview Questions and Answers
IBM How should Web Application Servers be used with PeopleTools 8.Ix and PeopleTools 8.4?
The PeopleSoft internet Architecture uses a web application server and an HTTP server.
PeopleTools 8.12 and above include both BEA Web Logic and Apache with Jserv. With
PeopleTools 8.4, both BEA WebLogic and IBMWebSphere are bundled. Apache with Jserv is no longer a supported web application server combination. Customers can choose which web application server to run during installation time in a mixed PeopleTools 8. lx and 8.4 environments, each PeopleTools installation should have their own chain of web application server and application server,
PeopleSoft Proprietary and Confidential Page 5and these can be on the same machine. For example, a PeopleTools 8. 1xinstallation using Apache and Jserv could reside on the same machine as a PeopleTools 8.4 installation using HIM WebSphere. Care should be taken to ensure that unique port numbers are assigned to each server chain.
Can a PeopleTools 8.4 and a PeopleTools 8.lxapplication server run on the same machine?
Yes, both PeopleTools 8.4 and PeopleTools 8.lx application servers can run on a single machine. It is important to ensure that there are no port clashes between the installations.
Will Tuxedo continue to be used in a PeopleSoft/WebSphere or PeopleSoft/WebLogic environment?
WebSphere or WebLogic are used as the IITTP server and servlet engine. They are not
used as middleware with the PeopleSoft Application Server. Tuxedo is always used with
PIA, regardless of the HTTP server or Java servlet engine.
Which of the following are parts of an AE program?
Section, Step and Action
What are the main attributes of a Component Interface (CI)?
Keys, Properties & Collections, Methods, and Name
Is it possible to change Prompt Table with NO Edit to Prompt Table with Edit?
Only selection of existing data is possible.
What views available in Application Designer project workspace?
1. Development View
2. Upgrade View
What Record Changes does not affect Database?
These record changes do not affect the DB
Derived work record
What is the default Crystal Report that PeopleSoft Query tool creates?
What are the differences between RowClass and RowSet in PeopleSoft?
Rowclass is a single row of data that consists of 1 ton records of data.
Rowset object is a data structure used to describe hierarchical data. It consists of a collection of rows.
What are the statuses available in PeopleSoft Domain Status Menu?
1) Server Status
2) Client Status
3) Queue Status
What are the views available in App. Designer project workspace?
Development and Upgrade Views.
Explain what are component buffer and data buffer.
Component Buffer contains all the Data of active component
Data Buffer contains Data other then the Data in the Component Buffer. Data Buffer
classes are available in people code, Rowset, Row, Record, Field, Array, Sql, File, chart,
Drid and so on.
What are all the steps involved in Upgrade process?
Plan the Upgrade:
1) Prepare Copy of Production Database
2) Install New Release
3) Upgrade People Tools
4) Run and Review Compare Reports
5) Apply Application Changes
6) Complete Production Copy
7) Test the Upgrade
8) Move into Production
If we use SQL and Call section at same time then Database deadlock will occur. Why does this Dead lock Occur?
When a SQL is run, there is a lock on the table by the database until that section is completed. If during that time there runs some other process, which will use the same table locked by our section using call section, this process will fail.
What is Activity Type? What is Cost Center? What is GAP Analysis? Explain with real time scenario.
Activity type is the nature of “action committed or happened” and nature depends on the environment. The all value paid or bear is located in small center is called Cost Center. GAP Analysis is finding out the “Deficiency or gap” between ideal system or standard system and existing or current system.
What is difference between Translate table and Prompt table?
There are few differences between Translate tables and prompt tables
1. Translate tables have a max length of 4 char for each element. However, prompt table elements have no such limitation.
2. There can be only 30 entries in a translate table. Whereas prompt table can have n number of entries.
What is ERP and how it is related to SAP?
ERP is generally referred to a class of business software that addresses a business firm in totality, rather than one or two functions For example, there are accounting software, inventory software, etc. that addresses a specific function of a business. However, ERP class software addresses all the functions of the business and provides an integrated view of the business to the management.SAP is a German company and is the world leader in ERP software across various industries.
How do you create the Department security with navigation?
To do this, after you have created your Departments Navigate to Tree Manger->Tree Manager and select Appropriate Security Tree (In General in People soft this will be DEPT_SECURITY). Attach your newly created Department m the tree in the required node. Then after run HR_FAST VIEW Application engine by Navigation through-SetupHRMS->Security->Department Security->Update dept Security.
What is section?
A section is a set of ordered steps that is executed as part of a program. You can call sections (and other programs) from steps within other sections.
What is the difference between SQL View and Query View?
In Sql view manually write the SQL statement, Query view use the PS QUERY tool.
What is dynamic view?
Dynamic View is similar to SQL View but we cannot build the dynamic view. When we
do not want store the database then us dynamic view.
What is the most important Record in PS HRMS?
What is the purpose of state records?
To store application data for life of the application Engine process
Where do you need to install connectivity software?
We need to install Connectivity Software on Appserver and scheduler server if they are
not on the Database server
What are Menu types available?