Latest Questions
Post Top Ad
Your Ad Spot
Monday, June 17, 2019

80 Top PeopleSoft Interview Questions and Answers {Updated}

PeopleSoft Interview Questions and Answers for experienced PDF, Read commonly asked PeopleSoft Job Interview Questions with Answers PDF for Freshers.

Read PeopleSoft Interview Questions and Answers

What commands are valid in BS mode?

Does Application Messaging work between 8.lxand 8.4 applications?
Application Messaging is used by PeopleSoft applications to communicate with one another. This is true not just for 8.1 x and 8.4 applications, but also between an 8,1 x and an 8.4 application. For example, the FIRMS 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.

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 theirs on HTTP web server and Web Logic’s or Web Sphere’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.

Are there advantages or disadvantages to using BFA WebLogic over IBM WebSphere or vice versa?
No. Both products are certified with PTA 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.

Will the PeopleSoft Internet Architecture, now that it embeds BEA Web Logic and IBM WebSphere, work with 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
1) Licensing another web server
2) Training developers and administrators
3) Building and deploying other web applications will not be compromised by this decision.
the program can be found in the whitepaper The IBM WebSphere 8.1 x Early Adopter Program.

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 databases to keep the configuration and runtime information to support a 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 the file-based configuration in a way that is similar to BEA WebLogic. PeopleSoft and IBM WebSphere architects determined that AEs version would satisfy the deployment requirements of PeopleSoft customers and would make it easy for owning and administering PeopleSoft Applications based on WebSphere.

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 APT 2.2. It should be noted that the PeopleSoft Internet Architecture is supported only on the BEA WebLogic and WebSphere servlet engines.

How does the PeopleSoft Enterprise Portal work with 8.lx and 8.4 applications?
There are several scenarios that, may exist when customers use the PeopleSoft Enterprise Portal with a mixture of 8. lx and 8.4 applications. Specific information on the use of the PeopleSoft Enterprise Portal in a blended environment will be available in a forthcoming white paper, which will be available on Customer Connection. In general, the recommendation is to use the PeopleSoft Enterprise Portal 8.4with 8. lx and 8.4 applications, rather than an older version.

Can a PeopleTools 8.4 and a PeopleTools 8.lx database run on the same machine?
Yes, databases can co-exist on the same physical machine. In most cases, the databases themselves can exist within the same RDBMS; however, it is important to verify that the database version required by PeopleTools 8.4 is the same as for the current PeopleTools 8.1 x implementation.

What are the various steps that describe the PeopleCode logic while implementing a Component Interface?
1. Establish a user session
2. Get the Component Interface
3. Populate the Create Keys
4. Create an Instance of the CI
5. Populate the required fields
6. Save the CI

The Trace tab in Configuration Manager only traces the Windows client (two-tier) interactions. True or False

How do you delete a file using sqr?

What are the different ways to run AE, SQR? (Command, process scheduler)
2-tier, 4-tier, process scheduler

What is the difference between SQL statements and meta SQL statements?
SQL statements are Database specific whereas meta-SQL statements are Db independent.

How do you retrieve a value from scroll.scroll select?
Scrollselect (1, targetname, recordfiledname)

What is a record. row PeopleCode?
Record PeopleCode is triggered whenever you deal with the record. EX when you write a piece of code on Record Field change that code is fired whenever the Field is changed in any page. There is nothing called Row PeopleCode.

What are the differences between AE and SQR?
AE is built on PeopleSoft proprietary language called People Code, whereas SQR is a third party tool.

What is the difference between SaveEdit and FieldEdit?
Field Edit Validate particular field only, but Save Edit validates all the fields in that component.

What is the performance tuning of SQR?
1. Use Load-lookup and Arrays
2. Use SQT files.
3. Generate multiple reports.
4. Use correct SQL joins.

How do you decide between appeng/Ci and SQR while conversion?
When you want to validate data upfront before loading them into DB. better plan to use appeng or ci, when you are thinking of huge data to be loaded SQR would be a better option.

Tell me about your experience with CI?
CI can be used to upload data from legacy systems through excel to Cl or create new data within PeopleSoft from another component.

What is the purpose of State Record?
State Records are used in AE to pass values from action and section to the other. It also allows you to restart the App Engine. For this, the State record has to be a SQL table. A state record either can be an SQL table or derived Work record. Process_instance field is mandatory in the State Record.

How will you get a single output by combining two or more queries?

How do you set up table sharing in PeopleTools applications?

Which RDBMS uses Tablespace?
Oracle, db2, Informix

What Record Changes does not affect Database?
List Box item

What are the Record field events?
1. FieldChange
2. FieldDefault
3. FieldEdit
4. FieldFormula
5. PrePopup
6. RowDelete
7. RowInit
8. RowInsert
9. RowSelect
10. SaveEdit
11. SavePostChg
12. SavePreChg
13. SearchInit
14. Search Save
15. Workflow

Which of the following fires after the database is updated?

What are the commands can be run in Bootstrap mode?
The bootstrap mode is actually logging into the App designer in 3-tier mode i.e. Login to the
App server. Data mover scripts are run on 3-tier mode.

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

SYSAUDIT finds for______
Orphaned Objects

What are the People Tools available for Integration Broker?
The tools available are Application designer and Integration Broker Setup on the Portal.
In PeopleSoft, 8,48 messages and Queues can be created from the Setup itself.

What are the Search Keys you use to find Patches and Fixes?
Report id date release

Which of the above record definitions is NOT stored on the database and therefore not required to build?
Derived Work Record definitions not stored in the database and not required for the build. When a business requirement in Fit/Gap Analysis does not meet by PeopleSoft then go for customizations through Consultants

Where is Unicode used?
2) Oracle
3) SQL Server

What are the uses of process profile?
(Scenario based on process profile/process group) Server o/p path override, the process he can access.

On which servers Tuning can be done.
a) Database Server
b) App Server
c) Batch Server
d) Web Server

What does ER Diagrams represent?
a) Graphical Representation of Business process and Relations
b) Flowchart of tables and Fields

What are destructive statements in SQL?
a) Recreate a Table
b) Recreate a View

What is the output when the Query is split?
Component and Query view

What are Menu types available?
1. Component
2. PeopleCode
3. Separator

Activate Event is Valid for following?
Standard & Secondary

How do you login into BS mode?
DB Access Id

Which RDBMS uses Tablespace?
Oracle, DB2, Other Options: SQL Server, Informix, Sybase

Which process is used for running AE programs, which are to be run at a frequency of less than a day?

What event is fired after DB Update?
Save Post Change

What is the status available in the PeopleSoft Domain Status Menu?
Server, Client and Queue Status

What BEA product is used for DB transaction in PS?

Where is workflow work items found?

Where the WorkItem is available?
WorkList Record.

What IITTP servers and.Java servlet engine combinations are supported with PeopleTools 8.4?
All popular HTTP servers (reverse proxies) are supported. Please refer to the platform's database on Customer Connection for specific information on currently certified platforms.

Is web server load balancing supported with PeopleTools 8.4?
Customers can set up clusters of I3EA 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

Are disconnected mobile applications supported in PeopleTools 8.lx?
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.

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 IBM WebSphere 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 the 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 the 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
Sub record
Dynamic view

What is the default Crystal Report that the 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 the App. Designer project workspace?
Development and Upgrade Views.

Explain what are component buffer and data buffer.
Component Buffer:
Component Buffer contains all the Data of active component
Data Buffer:
Data Buffer contains Data other than 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 the 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 the same time then Database deadlock will occur. Why does this Deadlock 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 the Cost Center? What is GAP Analysis? Explain with the 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 a small center is called Cost Center. GAP Analysis is finding out the “Deficiency or gap” between the ideal system or standard system and existing or current system.

What is the difference between the 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 are 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 uses the PS QUERY tool.

What is the dynamic view?
Dynamic View is similar to SQL View but we cannot build the dynamic view. When we
do not want to store the database then us dynamic view.

What is the most important Record in PS HRMS?
JOB record

What is the purpose of state records?
To store application data for the life of the application Engine process

Where do you need to install connectivity software?
We need to install Connectivity Software on App server and scheduler server if they are
not on the Database server

What are Menu types available?
1. Standard
2. Pop-Up

Post Top Ad

Your Ad Spot