Peoplesoft Interview Preparation Guide
Download PDF

Peoplesoft Interview Questions and Answers will guide us now that PeopleSoft Inc. was a company that provided human resource management systems (HRMS) and customer relationship management (CRM) and manufacturing, financials, enterprise performance management, and student administration software solutions to large corporations, governments, and organizations. The Oracle Corporation acquired PeopleSoft,Inc. Learn basic and advance concepts of PeopleSoft with our Interview Questions and Answers.

167 Peoplesoft Questions and Answers:

2 :: 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

3 :: What is the purpose of state records?

To store application data for life of the application Engine process

5 :: 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.

6 :: 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.

7 :: 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.

8 :: How do you create the Department security with navigations?

To do this, after you have created your Departments Navigate to TreeManger->Tree Manager and select Appropriate Security Tree (In General in People soft this will be DEPT_SECURITY).Attach your newly created Department in the tree in the required node. Then after run HR_FASTVIEW Application engine by Navigati through-

SetupHRMS->Security->Department Security->Update dept Security.

9 :: 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.

10 :: What is difference between Translate table and Prompt table?

There are few differences between Translate tables and prompt tables1. 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. Where as prompt table can have n number of entries.

11 :: 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.

12 :: 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.

13 :: 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

14 :: Explain what are component buffer and data buffer.

Component Buffer:
Component Buffer contains all the Data of active componentData Buffer:
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.

17 :: What are the differences between RowClass and RowSet in PeopleSoft?

Rowclass is a single row of data that consists of 1 to n records of data. Rowset object is a data structure used to describe hierarchal data. It consists of a collection of rows.

19 :: What Record Changes does not affect Database?

Derived work record


Dynamic view

These record changes do not affect the DB