Most frequently Asked Peoplesoft Interview Questions and Answers for freshers and experienced pdf free download
1. What are Menu types available?
1. Standard
2. Pop-Up
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
4. What is the most important Record in PS HRMS?
JOB record
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 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.
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.
1O. 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.
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.
15. What are the views available in App. Designer project workspace?
Development and Upgrade Views
16. What are the statuses available in PeopleSoft Domain Status Menu?
1) Server Status
2) Client Status
3) Queue Status
17. 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 hierarchal data. It consists of a collection of rows.
18. What is the default Crystal Report that PeopleSoft Query tool creates?
ACTQRY.RPT
19. What Record Changes does not affect Database?
These record changes do not affect the DB
Derived work record
Sub record
Dynamic view
20. What views available in Application Designer project workspace?
1. Development View
2. Upgrade View
More Peoplesoft Interview Questions & Answers: Click Here
More Peoplesoft Multiple Choice Questions: Click Here
1. What are Menu types available?
1. Standard
2. Pop-Up
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
4. What is the most important Record in PS HRMS?
JOB record
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 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.
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.
1O. 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.
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.
15. What are the views available in App. Designer project workspace?
Development and Upgrade Views
16. What are the statuses available in PeopleSoft Domain Status Menu?
1) Server Status
2) Client Status
3) Queue Status
17. 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 hierarchal data. It consists of a collection of rows.
18. What is the default Crystal Report that PeopleSoft Query tool creates?
ACTQRY.RPT
19. What Record Changes does not affect Database?
These record changes do not affect the DB
Derived work record
Sub record
Dynamic view
20. What views available in Application Designer project workspace?
1. Development View
2. Upgrade View
More Peoplesoft Interview Questions & Answers: Click Here
More Peoplesoft Multiple Choice Questions: Click Here
No comments:
Post a Comment