PeopleSoft Interview Questions and Answers

PeopleSoft is a very powerful application with a lot of information available from Oracle, delivered with the application known as PeopleBooks. Sometimes PeopleBooks is not available when you try to learn PeopleSoft, or it is difficult to understand. We have listed of PeopleSoft Interview Questions that have been designed for PeopleSoft professionals who are preparing interviews on PeopleSoft.

Best PeopleSoft Interview Questions and Answers

In an ideal world all PeopleSoft implementations have been upgraded to the newest release of Oracle’s PeopleSoft Enterprise release; however, this book addresses development fundamentals for those of you still at earlier versions. The release that is used in the illustrations and examples is version 8.9. we have compiled below are the major best PeopleSoft Interview Questions which interviewer may ask during interview.

Will Tuxedo continue to be used in a PeopleSoft/WebSphere or PeopleSoft/WebLogic environment?

Yes. WebSphere or WebLogic are used as the HTTP 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.

Can PeopleTools 8.4 and a PeopleTools 8.1x database run on the same machine?

Yes, databases can co-exist on the same physical machine. In most cases, thedatabases themselves can exist within the same RDBMS, however, it isimportant to verify that the database version required by PeopleTools 8.4 is thesame as for the current PeopleTools 8.1x implementation.

Can PeopleTools 8.4 and a PeopleTools 8.lxapplication server run on the same machine?

Yes, both PeopleTools 8.4 and PeopleTools 8.1x application servers can run ona single machine. It is important to ensure that there are no port clashes between the installations. 

How does the PeopleSoft Enterprise Portal workwith 8.1x and 8.4 applications?

There are several scenarios that may exist when customers use the PeopleSoftEnterprise Portal with a mixture of 8.1x and 8.4 applications. Specificinformation on the use of the PeopleSoft Enterprise Portal in a blendedenvironment will be available in a forthcoming white paper, which will beavailable on Customer Connection.In general, the recommendation is to use the PeopleSoft Enterprise Portal 8.4with 8.1x and 8.4 applications, rather than an older version. 

For the servlet layer on the web server, what version of the Java Servlet API are the PIA Java Servlets coded to with PeopleTools 8.4?

The PIA Java servlets in PeopleTools 8.4 are coded to JavaSoft’s Java Servlet API 2.0 and are fully compatible with Servlet API 2.2. It should be noted that the PeopleSoft Internet Architecture is supported only on the BEA WebLogic and WebSphere servlet engines.

IBM How should Web Application Servers be used with PeopleTools 8.1x and PeopleTools 8.4?

The PeopleSoft Internet Architecture uses a web application server and anHTTP server. PeopleTools 8.12 and above include both BEA WebLogic andApache with Jserv. With PeopleTools 8.4, both BEA WebLogic and IBMWebSphere are bundled. Apache with Jsery is no longer a supported webapplication server combination. Customers can choose which web applicationserver to run during installation time.In a mixed PeopleTools 8.1x and 8.4 environment, each PeopleTools installationshould have their own chain of web application server and application server,PeopleSoft Proprietary and Confidential Page Sand these can be on the same machine. 

Why did PeopleSoft bundle IBM WebSphere Advanced Single Server Edition rather than Advanced Edition?

The Advanced Single Server Edition (AEs) of WebSphere provides the same core J2EE and Web Services programming model as the Advanced Edition (AE) with simplified administration. In the AE version WebSphere uses DB2 or other standard database to keep the configuration and runtime information to support very large farm of WebSphere servers. However, it is one more database to install, administer and maintain. The AEs version does not use the database and uses file based configuration in a way that is similar to BEA WebLogic.

Will the PeopleSoft Internet Architecture, now that it embeds BEA WebLogic and IBM WebSphere, work with my other corporate web servers and tools?

One of the core values of the PeopleTools development group is investment protection. The time, money and resources that you may have already invested in licensing another web server, training developers and administrators, building and deploying other web applications will not be compromised by this decision. How is this accomplished.

Is BEA WebLogic the same thing as the web server that was previously on the Tuxedo CD?

No. The web server that was delivered on the Tuxedo CD has absolutely nothing to do with WebLogic. WebLogic is a web application server that is designed for large-scale production websites. The HTTP server on the Tuxedo CD was only there to provide a mechanism for launching the graphical Tuxedo administration console if the Tuxedo administrator didn’t already have a web server in place. It was never intended for large-scale, production website use — only for a system administrator or two. 

Are disconnected mobile applications supported in PeopleTools 8.1x?

No. The PeopleSoft Mobile Agent architecture, which is used to support disconnected mobile applications, is only available in PeopleTools 8.4. The PeopleSoft Mobile Agent is dependent upon certain core technologies that were specifically developed for PeopleTools 8.4. 

Is WebSphere certified on PeopleTools 8.1x?

No. IBM WebSphere is certified on PeopleTools 8.4 only. Customer wishing to use IBM WebSphere with PeopleTools 8.1x may take advantage of an IBM WebSphere for early adopters program, created and managed by IBM. Further information about this program can be found in the whitepaper The IBM WebSphere 8.1x Early Adopter Program. Are there additional license requirements for IBM WebSphere. 

Are there advantages or disadvantages to using BEA WebLogic over IBM WebSphere or vice versa?

No. Both products are certified with PIA as of version 8.4 and work equally well. By offering both BEA WebLogic and IBM WebSphere, we give our customers more choices and flexibility to run PeopleSoft in their preferred environment.

Is web server load balancing supported with PeopleTools 8.4?

Customers can set up clusters of BEA WebLogic or IBM WebSphere servers to do web server load balancing. In such scenarios, if an instance is down, requests are automatically routed to another instance. For more information on high availability and clustering with WebLogic, WebSphere and other web servers.

Both BEA WebLogic and IBM WebSphere have the ability to plug into many different web servers. Does PeopleSoft support the web servers that they plug into?

BEA and IBM provide plug-ins for many of the leading web servers. This allows the customer to use their own HTTP web server and WebLogic’s or WebSphere’s Java servlet engine. PeopleSoft uses this plug-in capability to support IIS. We have no reason to believe that there will be any issues with other web servers that WebLogic or WebSphere are able to work with through their plug-in architecture, but PeopleSoft GSC will not support these other web servers with PeopleTools 8.4

Does Application Messaging work between 8.lxand 8.4 applications?

plication Messaging is used by PeopleSoft applications to communicate withone another. This is true not just for 8.1x and 8.4 applications, but also between an 8.1x and an 8.4 application. For example, the HRMS 8.3 applications, which are based on PeopleTools 8.15, can communicate with Financials 8.4applications, which are based on PeopleTools 8.4, using Application Messaging. If specific issues materialize relating to the Application Messages published by certain applications, these new messages will be made available to customers.

Customers can set up clusters of BEA WebLogic or IBM WebSphere servers to do web server load balancing. In such scenarios, if an instance is down, requests are automatically routed to another instance. For more information on high availability and clustering with WebLogic, WebSphere and other web servers.

Both BEA WebLogic and IBM WebSphere have the ability to plug into many different web servers. Does PeopleSoft support the web servers that they plug into?

BEA and IBM provide plug-ins for many of the leading web servers. This allows the customer to use their own HTTP web server and WebLogic’s or WebSphere’s Java servlet engine. PeopleSoft uses this plug-in capability to support IIS. We have no reason to believe that there will be any issues with other web servers that WebLogic or WebSphere are able to work with through their plug-in architecture, but PeopleSoft GSC will not support these other web servers with PeopleTools 8.4

Does Application Messaging work between 8.lxand 8.4 applications?

plication Messaging is used by PeopleSoft applications to communicate withone another. This is true not just for 8.1x and 8.4 applications, but also between an 8.1x and an 8.4 application. For example, the HRMS 8.3 applications, which are based on PeopleTools 8.15, can communicate with

Financials 8.4applications, which are based on PeopleTools 8.4, using Application Messaging. If specific issues materialize relating to the Application Messages published by certain applications, these new messages will be made available to customers. 

Why is PeopleSoft no longer supporting Apache Jserv?

Apache JSery was a servlet engine that was supported in PeopleTools 8.1x. This support has been removed from PeopleTools 8.4 for several reasons: v JSery is no longer an active product and is in maintenance mode and there are no longer any new official releases. v Our customers have exhibited a desire to use commercial products for mission-critical enterprise web application servers rather than open source solutions. Therefore, moving to support Tomcat is not seen as a reasonable solution. v Apache can still be used as an HTTP server with BEA WebLogic.

What HTTP servers and Java servlet engine combinations are supported with PeopleTools 8.4?

All popular http servers (reverse proxies) are supported. Please refer to the platforms database on Customer Connection for specific information on current certified platforms.

Workltem is available in?

WorkList Record

Where are workflow work items found ?

Worklist

In which platform does Crystal and Psnvision works?

Windows (Correct)

You want to update your password and enter a hint for forgotten password. What would you access?

User Profile

Question based on changing prompt table, what happens when changing from NO EDIT TO EDIT option?

user can type only prompt table values and the default values gets populated from the database.

Customization done in Dev DB, Which tool i will use to move it to Prod DB?

Use App Designer -> Copy DB

Your Onsite DBA has called you up and told you that one of the tables PS_ABC_TAO has grown very big in size. Based on the standard naming convention, you have determined that the record is a temporary record since it ends with _TAOYou look into the database and decide that that the data is not required any more. You ask the DBA to delete the data in the table. Next day you get a call from an irritated user who says that a daily process that took only 1 minute to run is taking about 2 hours today. You look into his process and find that it uses PS_ABC_TAO as a temporary table.

What would you suggest the DBA to do ?

Update statistics on the table

(Some scenario) Question relating DBA Purging Temporary Table?

Update Statistics

When a business requirement in Fit/Gap Analysis does not meet by PeopleSoft then?

Some options: 1. Customize PS application (Yes)2. Buy third party software (Yes)3. Call PS Development Center for Enhancement (Yes)

What are the status available in PeopleSoft Domain Status Menu?

Server, Client and Queue Status

Which of the following are part of an AE program ?

Section ,Step and Action

Which of the following fires after the database is updated?

SavePostChange

What event gets fired after DB Update?

SavePostChange

For downloading patches and fixes , you have gone to the customer connection and looking under 8 april, 2000 and see Report IDS like R-CCHEN-VP14JM. What does R stand for ?

Released

In which one of the following views would you see the fields, criteria, and other details associated with the current query?

Query view

PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?

PSRELEASE

I have created a Menu and a Page and given user access to that page, which of the tables gets affected on this (Scenario)?

PeopleTools Tables

You are a PeopleSoft Partner and wish to get information on database performance benchmark ( or something like this)Where would you look for the info ?

PeopleSoft Knowledge base SYSAUDIT finds for Orphaned Records

Which RDBMS uses Tablespace?

Oracle, DB2, Other Options: SQL Server, Informix, Sybase

Changing Prompt Table with NO Edit to Prompt Table with Edit?

Only selection of existing data is possible

Which command is valid in both bootstrap and regular mode when operating the data mover? GRANT USER

PeopleCode events pertaining to Record Field:?

FieldEdit, SaveEdit and RowDelete

Which of the following are Record field events ?

FieldChangeSearchSave and SavePreChange

Which of the following commands can be run in Bootstrap mode?

ENCRYPT PASSWORD

What commands are valid in BS mode?

ENCRYPT_PA S SWORD

What views available in Application Designer project workspace?

Development and Upgrade

Where will you configure for failover of Application Server (Scenario)?

Configuration.properties

Which one of the following is a trasaction control statement?

Commit

What Record Changes does not affect Database?

Change in List box in Record Field properties (correct)

Which one of the following steps is NOT part of performing an upgrade?

Apply all outstanding patches, prior to upgrade

Update and Fixes: R-* files refers to? Application Updates and Fixes

How do you set up table-sharing in PeopleTools applications?

Add the field, SETID, as a key field to each table you want to share, and then define the set control field. PeopleSoft reserves ALL Message Sets (in Utilities, Message Catalog) up to which number?

What is the default Crystal Report that PeopleSoft Query tool creates?

ACTQRY.RPT

(Some scenario) Find which is not part of AE Program, Options would be?

Action,Section,Step,Event

It is the standard in the PeopleSoft development community to use a minimum of four database systems: PeopleSoft Vanilla, Development, Quality, and Production. PeopleSoft Vanilla is retained to assist in determining if hard-to-track bugs were inherent in the delivered code, or are due to a change.

Thus, the compilation of these questions includes some of the major points that can be asked during an PeopleSoft interview. The interviewers generally check the base knowledge of a candidate, which can be gained by practicing these questions prior interview. We have prepared simple PeopleSoft Interview Questions and Answers that helps you in getting your dream career as Peoplesoft expert.