Peoplesoft Hrms Technical Interview Questions

Explain what is PeopleSoft?

PeopleSoft is an organization that provides e-business application software over the internet.  It provides software for Human resource management, Supply chain management, CRM or Customer Relationship Management, Enterprise Performance Management and so on.

What is regulatory region? Usage?

A regulatory region is a region which has laws and regulations that are used by functionality in PeopleSoft HRMS. A lot of transactions are driven by regulatory requirements. These requirements include areas like ethnicity, disability, and health and safety. When driven by Regulatory Region, the regulatory codes, People Code edits, and set processing in the system can vary by country and for each transaction.

What are the different kinds of organizational relationships in HRMS? Explain each with relevant examples.?

Different organization relationships a person can have are: Employee, Contingent worker or Person of Interest as per the person model. Employee is a permanent staff member of the firm who is paid by company payroll and has a hire row in job with all associated information like company, department, location and paygroup etc. Example is a permanent position for a chief executive or sales manager in the firm.

Contingent worker is a contractor in the organization mostly on an assignment. Personal information and job information is stored for a contractor in the system but person is not on the company payroll. Example can be a person from a third party company which is acting as a vendor for the firm to conduct a project for the firm needs. This person is a part of the project and working in the firm till the end of the project.

Person of interest has many flavors. There are various types of POI – Pension payee, external trainee, external instructor or board member. They are members who are connected to the firm due to some business purpose. There are two types of POIs- who have a row in job data and others who do not have. POIs who do not have job information have a separate mechanism in PS to maintain their data security.

When you access an HCM component, say, Job Data, certain values like business unit, company etc are defaulted. What governs this concept?

Values like business unit, company, country get defaulted by virtue of the user’s primary permission list. These default values are associated with SetIDs on the Business Unit Options Default page.

Using the tableset controls and business unit default options, the system determines the default values to enter in select fields on the component. So, when a user accesses a component that uses business unit defaults and selects a business unit, the system determines the setID which drives the defaults for the business unit on the Tableset Control –Record group page.

Explain what is Related Content in PeopleSoft?

In PeopleSoft, related content services are the framework within which administrators can contextually link application pages with collaborative content in any PeopleSoft application.

Mention what all technical things can PeopleSoft billing can do?strong>

With this application of PeopleSoft many things can be done like

Create bills

Receive billing data from other PeopleSoft applications

Receive billing data from other applications

Create recurring bills, installment bills, inter & intraunit bills and so on

Review and validate bills

Adjust invoices

Calculate sales, use, and value-added taxes

Defer revenue accounting and so on

Explain how the voucher build process flow works in PeopleSoft?

The voucher build process consists of two sub-processes voucher edit and pre-edit.  The pre-edit sub-processes create skeleton voucher record sets from the partial information that you provided online using the components like Quick Invoice Entry (VCHR_QUICK_PNL) or the Summary Invoice Entry (VCHR_SUMM_PNL), or that it obtains from other sources.  After the pre-edit sub-process creates voucher record sets successfully, it calls the voucher edit sub-process to complete the record sets.

In peoplesoft in what many ways you can run an application engine program?

You can run an application in five ways

Application designer

Process Scheduler

AE people tools

Calling people code

Command line prompt(dos)


Explain how you can export SQL results to Excel using SQLPLUS?

To export SQL results to Excel using SQLPLUS, you have to follow the following steps

-Step 1: Login into data-base using SQL PLUS

-Step 2: Set mark-up using command “ SET MARKUP HTML ON”

-Step 3: Spool the output to a file “SPOOL C:\TEMP\MYOUTPUT.XLS”

-Step 4: Execute your SQL QUERY

-Step 5: Set the Spool off

-Step 6: To view the output open the output XLS file

Explain what is PeopleSoft integration broker?

Peoplesoft integration broker provides SOA (service oriented architecture) technology, and enables the transferring of asynchronous and synchronous service operations.  You can use the PeopleSoft integration broker to

To execute synchronous and asynchronous messaging among internal as well as third party systems
Delivers PeopleSoft business logic as web services to PeopleSoft and third party systems
Invoke and consume web services from third party and PeopleSoft systems

Mention what are the two important components of PeopleSoft integration broker?

The two important components of PeopleSoft integration includes

Integration gateway: It is a platform that regulates the receipt and delivery of service operations passed among systems via PeopleSoft Integration Broker

Integration engine: It is an application server process that routes service operation to and from PeopleSoft application transforms service operation structure and translates data as per the specification

Explain what is the role of PeopleSoft component Interfaces?

PeopleSoft component interfaces give a way to use the PeopleSoft database without using a graphical user interface.  A component interface wraps PeopleSoft component, which is a logical grouping of PeopleSoft pages representing a complete business transaction.

Explain File Interfaces in PeopleSoft?

PeopleSoft interfaces provide the ability to exchange files with third-party system or legacy system that do not support messaging.  Files are exchanged using file layouts.

File Layouts supports following file types

Comma delimited files

Fixed format sequential files

XML files

Explain what does PeopleSoft query is used for?

PeopleSoft query can be used

-To display data in a grid

-To schedule a query

-To download query results to XML and Excel spreadsheet

-To cater as a data source for Crystal Reports

-To decide to whom to forward information

-To cater as a data source for defining online analytical processing cube (OLAP)

-To create a data source for PeopleSoft and Vision reports

Explain what is the use of Publish Utility in PeopleSoft?

The publish utility automates the procedure of copying the contents of the entire table into a legacy system or remote database.

Mention what is PeopleSoft Multi-Channel framework?

PeopleSoft multi-channel framework provides an integrated infrastructure to support multiple interaction channels for call center agents or other PeopleSoft users who must respond to notifications and incoming requests.  PeopleSoft multi-channel framework supports following channels.

Web collaboration (Chat)

Voice (Telephone)


Instant Messaging

Mention what are the different types of service operation does PeopleSoft Integration Broker provides?

PeopleSoft integration broker supports four types of services

-Asynchronous one-way

-Asynchronous response/request

-Asynchronous to synchronous


Mention where you can add a value to the underlying table in PeopleSoft?

In PeopleSoft, you can add a value into the “prompt table with no edit”.

Mention what are the tools are provided by PeopleSoft for testing your integration development?

The tools that are provided by PeopleSoft for testing your integration development

Send master utility

Simple post utility

Automated integration point testing

Transformation test utility

Handler tester

Schema tester

Mention what is the role of Schema Tester?

The Schema Tester utility allows you to validate rowset-based and non-rowset-based messages against message schemas during development to determine if messages link to defined message schemas.

Mention what does feed publishing framework provides?

Feed publishing framework provides

Explain in what ways you can create exceptions in PeopleSoft?

In PeopleSoft, exceptions are handled in two ways

Creating an exception base class that wraps the built-in function call and handles its function parameters consistently, which is more common way

By calling the built-in function CreateException

File formats for File Layout?



fixed length

Prompt table with no edit to no edit?

user can enter values from prompt table
user can enter values from prompt table and default value will be populated

Meta-SQL where is it stored?

Temp Table

SQL Table

Query Table

Dynamic(Guess: Temp Table, check People books App Engine)

What are all stored in System Catalog?

SQL table

SQL View

Process Profile contains?

-Sequence of processes

-Sequence of jobs

-batch processes

File format for SQR?



PeopleSoft clients wants to get info about PSPT where to find it?

Partner Alliance

Partner Connection

PeopleSoft Connect

Portal connect

PSU (check)

Which of the following are object definitions?

Mobile Page

File Layout

App Engine

What are the options for using SQL in people code?


Record class methods (selectbykey, delete, insert, update)

Using sql class, its properties and methods.

What is the difference between component buffer and data buffer?

Component buffer contains all the data of the active component.

What are all the organisational instance components?

Add Employment Instance (Job_Data_Emp)

Add Contingent Worker Instance (Job_Data_CWR)

Add Person of Interest Job (Jon_Data_POI)

What are all the job instances used for POIs?

COBRA qualified beneficiaries

Stock employees not administered in Human Resources

Global Payroll Employees

Pension Payees

Stock board members

What are all the purpose of the Job Earnings Distribution Information Page?

We can distribute the worker’s compensation on the basis of the following:


Job Code

Earnings Code

Business Unit


Position Number

General Ledger Pay type

What are the main attributes of a Component Interface (CI)?

Keys, Properties & Collections, Methods and Name

Can a PeopleTools 8.4x and a PeopleTools 8.1x  database runs 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  is the same as for the current PeopleTools x implementation.

Does Application Messaging work between 8.1x  and 8.4x applications?

Application Messaging is used by PeopleSoft applications to communicate with one another This is true not just for x and  applications, but also between an x and an  application For example, the HRMS  applications, which are based on PeopleTools , can communicate with Financials  applications, which are based on PeopleTools , 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

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

Which Data Type is NOT supported by the PeopleCode programming environment


What are the statuses available in PeopleSoft Domain Status Menu?

Server, Client and Queue Status

What are parts of an AE program?

Section, Step and Action

Which peoplecode event is fired after the database is updated?


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


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


PeopleCode events pertaining to Record Field:

FieldEdit, Save Edit and Row Delete

What views available in Application Designer project workspace?

Development and Upgrade

Which of the record definitions in PeopleSoft is NOT stored on the database and is therefore NOT required to be built?

Derived/Work Record

PS Query definition is stored on which server?

DB Server

How do you login into Boot strap mode?

Using DB Access Id

Where will you configure failover of Application Server ?


What Record Changes does not affect Database?

Change in List box in Record Field properties

Which Web Services is only used as a Proxy Server?



Where does you set the web server cache?

Webserver file

Which task cannot be done through PSADMIN?

Starting Web Server

What is the configuration file that contains the entire collection configuration values for a given application server domain?


Which of the following record is not found in database?

Derived /Work record

Review Date
Reviewed Item
Useful Peoplesoft Hrms Technical Interview Questions
Author Rating

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at, we will update the article in 24 hours.”

0 Responses on Peoplesoft Hrms Technical Interview Questions"

    Leave a Message

    Your email address will not be published. Required fields are marked *


    Please leave a message and we'll get back to you soon.
    Three + 6