Peoplesoft Tools Interview Questions And Answers

Download Peoplesoft Tools Interview Questions and Answers PDF

Sharpen your Peoplesoft Tools interview expertise with our handpicked 44 questions. Our questions cover a wide range of topics in Peoplesoft Tools to ensure you're well-prepared. Whether you're new to the field or have years of experience, these questions are designed to help you succeed. Download the free PDF now to get all 44 questions and ensure you're well-prepared for your Peoplesoft Tools interview. This resource is perfect for in-depth preparation and boosting your confidence.

44 Peoplesoft Tools Questions and Answers:

Peoplesoft Tools Job Interview Questions Table of Contents:

Peoplesoft Tools Job Interview Questions and Answers
Peoplesoft Tools Job Interview Questions and Answers

1 :: PeopleSoft tools interview questions part 1:

How many sub pages, secondary pages can you create in one level?
What is the use of set control field in record field properties?
Situation:
a.) You want to migrate database from one database to another. How would you do that?
b.) You want to create a prompt table dynamically for a specified field. How would you do that?
Situation:
a.) You want to connect report through process scheduler. How would you do that?
b.) You want to use web application server with PeopleTools 8.1x and PeopleTools 8.4. How would you do that?
Which HTTP Servers and Java Servlet Engine combinations are supported with PeopleTools 8.4?
Read More

2 :: PeopleSoft tools interview questions part 2:

Does PeopleTools 8.4 support web server load balancing?
Does PeopleSoft support the web servers that BEA Weblogic and IBM Websphere can plug into? How?
Where do you write the PeopleCode?
Read More

3 :: Tell me the use of temporary records and state record in application engine?

Temporary table:
To allow other users to access the same table that has been using by the AE program. These are mainly used in batch processing. These can store specific data to update without aff.
Read More

4 :: Can you please explain the difference between temporary table and SQL view in peoplesoft?

Temporary Table:
Temporary tables are used for running PeopleSoft Application Engine batch processes. Temporary tables can store specific data to update without risking the main application table.
SQL View:
It is not a physical SQL table in the database, but rather fields from one or more SQL tables that are reorganized into a different sequence. This provides an alternate view of information that is stored in tables.
Read More

5 :: Explain mandatory property of App.engine?

1: Main is the required section in Application Engine.
2: There can be multiple steps in single application engine, but atleast one step should be part of AE.
3: Similarly you can have multiple actions in AE but you should have minimum one action part of step.
4: Save as AE
Read More

6 :: How to bring advanced search page before normal search page?

There is a setting available in Component properties to make either the Normal Search Page or the Advanced search page to appear first.
Read More

7 :: Tell me the use of set control field in record field properties?

Set Control id is used when you want to share tables in Peopletool applications.
This key identifies the sets of information in the table that are shared by multiple companies or business units under your corporate umbrella. You then specify a set control field, which identifies which fields map between the original key and the TableSets. You can specify any field that logically identifies the TableSet. In this case, you might assign Company as the set control.
Read More

8 :: Which HTTP servers and Java servelet engine combinations are supported with People Tools?

IBM WebSphere and Oracle Weblogic.
Read More

9 :: Tell me what will be the output of an application engine to use component variables instead of state record?

Well, Component variables can be used to carry data from one section to another. The scope of component variable remains throughout the program . They can be used in place of state record provided you do not want a restart facility and dynamic section calls.
Read More

10 :: Tell me the benefits of set control field in record field properties?

Benefits of set control field:
If we specify one field as a set control field then we will retrieve data based on this when we are using prompt table. Based on this field only we can have valid prompt list at the time of prompt button clicking.
Read More

11 :: Explain the numbers of sub pages and secondary pages that can be created in one level?

Sub page:
Mainly use for sub records. We can place sub records in to sub page.
Secondary page:
It is used to enter additional data, rarely entered data & unimportant fields.
There can be any number of sub-pages but only one secondary page in a level. We can insert through push button or domodal function using peoplecode.
Read More

12 :: How the output of a sql query be stored in a variable using peoplecode?

You can use SQLExec to do the same.
SQLExec("SELECT EMPLID FROM JOB",&Emplid);
The value of EMPLID gets stored in the variable &Emplid.
Read More

13 :: How to creating prompt table dynamically for the specified field?

by using edittable.
Read More

14 :: What environments supported by People Tools tool set?

Peopletools: windows, Unix (Red Hat, SLES)
Database: Oracle, SqlServer, DB2
PIA: IE 5.0 or greater
Read More

15 :: Tell me how many sub pages, secondary pages can be created in one level?

Any no. of subpages can created and any no of secondary pages can created.
There is no restrictions.
Read More
It is not possible normaly. But u can write a people code by which u can insert the field data into the records.
Read More

17 :: How to migrate roles from one database to another database?

A: Login to database through App Designer as a source database.
B: Click on upgrade tab and open the project which contains roles which you want to migrate.
C: Double click on Roles folder under the opened project.
D: Select Action as "Copy".
E: Go to Tools > Copy Project > To Database.....
F: Give database name (Target Database) to which you want to migrate roles.
G: Click on "OK"
H: Select "Roles" from different objects and copy that roles.
I: After completion of Copying, double click on Roles folder under the opened project and verify that "Done" checkbox should be checked.
Read More

18 :: What is Application Engine Meta Data?

Tables holding Application Engine Meta Data for the AE, Section, Steps and SQL.
Read More

19 :: What is Change Control?

Tables holding PeopleTools project change history and current locks on Tools objects.
Read More

20 :: What is Component Interface Meta Data?

Tables holding Component Interface Meta Data.
Read More

21 :: What is Component Meta Data?

Tables holding Component Meta Data.
Read More

22 :: What is Field Meta Data?

Tables holding PeopleTools Field information.
Read More

23 :: What are the Field Values for Tools Tables?

Find field values for the following:
RECORD.FIELDNAME
PSPROJECTITEM.OBJECTTYPE
PSPROJECTITEM.UPGRADEACTION
PSPROJECTITEM.SOURCESTATUS
PSRECDEFN.RECTYPE
PSDBFIELD.FIELDTYPE
PSPNLFIELD.FIELDTYPE
PSSQLDEFN.SQLTYPE
Read More

24 :: What is File Layout Definitions?

Tables holding File Layout Segment and Field definitions.
Read More

25 :: What is HTML & Image Meta Data?

Tables holding HTML and Image Meta Data.
Read More