PeopleSoft Interview Questions Archives - Programming Tutorials | Interview Questions

Peoplesoft Admin Interview Questions And Answers 2018

Top Peoplesoft Admin Interview Questions And Answers 2018. Here Coding compiler sharing a list of 30 interview questions on Peoplesoft Admin. These Peoplesoft admin questions were asked in various interviews conducted by top MNC companies and prepared by expert Peoplesoft professionals. All the best for your future and happy learning.

Peoplesoft Admin Interview Questions

What is PSADMIN in Peoplesoft?
What elements are there in PSADMIN?
What does PSADMIN do?
What are the Analytic Servers?
Can you give example scenario for Analytic Server?
PeopleSoft supports which Web Servers?
Why do we use WebLogic server in PeopleSoft?
What is Single server definition in Weblogic Server?
What is Multi server definition in Weblogic Server?
What is Distributed managed server definition in Weblogic Server?
What is WebLogic Server Administration Console?
How can you start WebLogic on Microsoft Windows?
How do you uninstall the Weblogic server?
How do you start WebLogic on UNIX?

Peoplesoft Admin Interview Questions And Answers

Peoplesoft Admin Interview Questions
What is PSADMIN?	PSADMIN for managing application server domains.
PeopleSoft Supports	Oracle WebLogic and IBM WebSphere web servers.
Tuxedo in Peoplesoft	Tuxedo is a transaction based Application Server.
User ID and Passwords	Are stored in PSOPRDEFN Table.
JVM Heap	Is the amount of memory that a particular JRE gives to the JVM that it creates.

Peoplesoft Admin Questions And Answers

1) What is PSADMIN in Peoplesoft?

A) You use PSADMIN for managing application server domains, PeopleSoft Process Scheduler domains, integration server processes, search domains, and so on. PSADMIN also enables you to configure and manage the behavior of servers with respect to a wide range of PeopleTools infrastructure elements.

2) What elements are there in PSADMIN?

A) PSADMIN consists of various PeopleTools infrastructure elements, including,

Tuxedo and Jolt.
PeopleCode debugging.
Caching.
Analytic server framework.
Transactional SQL requests.
Performance enhancement.
PeopleSoft Query.
Integration Broker.
Email.
Real-time event notification.
Performance Monitor.
MultiChannel Framework.

Peoplesoft Admin Interview Questions # 3) What does PSADMIN do?

A) PSADMIN simplifies the process of configuring and administering all of the server processes and features that are available for PeopleSoft servers. For example, you use PSADMIN to configure application server domains, Process Scheduler servers, PIA domains, and search servers.

Peoplesoft Admin Interview Questions # 4) How can you launch PSADMIN?

A) By using PS_HOME\appserv\psadmin.exe from the command line, we can launch the PSADMIN.

Peoplesoft Admin Interview Questions # 5) What are the Analytic Servers?

A) The analytic server framework provided by PeopleSoft is a general server infrastructure designed to meet the needs of PeopleSoft products that process large amounts of data in memory.

It provides a stateful model of client/server connectivity that these products require to be part of the PeopleTools system, by keeping track of configuration settings, transaction information, and other data for a session.

6) Can you give example scenario for Analytic Server?

A) For example, client software could request that an analytic model or optimization model be recalculated in one transaction, then retrieve the results of the calculation on that model at a later time.

A server process handles these requests and maintains the model state and calculated data in memory between the requests. Additional transactions can then modify the model and perform recalculations on it without shuffling all of the data between the client and the server or dumping all the data into a database, thus preserving in-memory performance.

Peoplesoft Admin Interview Questions # 7) PeopleSoft supports which Web Servers?

A) PeopleSoft supports Oracle WebLogic and IBM WebSphere web servers, which provide the same basic functionality to support PeopleSoft applications, including a console interface, secure sockets layer (SSL), and reverse proxy servers (RPS).

Each web server has its own way of accomplishing its functionality, and each adds its own extra features that you might find useful to your PeopleSoft system. This PeopleBook provides supplemental information about configuring and administering the web servers where it has particular relevance to PeopleSoft.

8) Why do we use WebLogic server in PeopleSoft?

A) We use the Oracle WebLogic Server as a web server in the PeopleSoft Internet Architecture to deploy PeopleSoft applications. The PeopleSoft Internet Architecture installation on the WebLogic Server provides these primary server configuration options.

9) What is Single server definition in Weblogic Server?

A) This domain configuration contains one server named PIA, and the entire PeopleSoft application is deployed to it. This configuration is intended for a single user or very small scale, non-production environments.

10) What is Multi server definition in Weblogic Server?

A) This domain configuration contains seven unique server definitions and a WebLogic cluster, and the PeopleSoft application is split across multiple server instances on a single machine. This configuration is intended for the production environment.

Advanced Peoplesoft Admin Interview Questions

11) What is Distributed managed server definition in Weblogic Server?

A) This option is an extension of the “Multi server” selection and installs the necessary files to boot managed servers spread across multiple machines. This option requires a “Multi server” installation to be performed to some other location that contains the configuration for this managed server.

12) What is WebLogic Server Administration Console?

A) The WebLogic Server Administration Console is the main utility that is used to administer and monitor the WebLogic server processes.

The Administration Console provides an interface to monitor and configure aspects of a PeopleSoft application from a web server perspective.

Access the Administration Console by pointing your browser to:

http://<server>:<port>/console

For example,

http://server08.us.oracle.com:80/console

Where the port is the port on which your PeopleSoft Internet Architecture domain is listening.

If it is a multi server installation the Administration Console from the Admin Server is always running on port 9999. For accessing the Administration Console in a multi server installation, the URL is:

http://<server>:9999/console

Before the Administration Console opens, you will be prompted for the WebLogic administration ID and password that you specified during the PeopleSoft Internet Architecture installation.

13) How can you start WebLogic on Microsoft Windows?

A) On Microsoft Windows, you can start WebLogic using: command prompt and Windows service.

Using the Command Prompt:

Running WebLogic as a foreground process is beneficial if you need to monitor WebLogic in real time. To run WebLogic as a foreground process, enter one of the following commands at the command prompt in PIA_HOME\webserv\domain\bin.

Single server – startPIA.cmd Or, you can use the PSADMIN PIA domain menu options.
Multi server – domain admin server – startWebLogicAdmin.cmd
Multi server – managed server – startManagedWebLogic.cmd server

For example, startManagedWebLogic.cmd PIA

Using the Windows Service

Benefits of running WebLogic as a Windows service include:

WebLogic can automatically start when the Windows server boots.

You can start and stop the service from a remote Windows machine.

To install the service, open the command prompt, and enter the appropriate command from your PIA_HOME\webserv\domain\bin directory:

Single server – installNTservicePIA.cmd

Multi server – InstallNTservice.cmd weblogic_server_instance_name

For example: installNTservice.cmd PIA

To start WebLogic as a Windows service, you can:

Start the service named WebLogicdomain-servername (for example, peoplesoft-PIA) by using the Services utility in the Windows Control Panel.

Start the service from a command prompt by entering the following command: NET START peoplesoft-PIA

Peoplesoft Admin Interview Questions # 14) How do you uninstall the Weblogic server?

A) To uninstall the service, enter the following command:

uninstallNTservicePIA.cmd

Peoplesoft Admin Interview Questions # 15) How do you start WebLogic on UNIX?

A) To start PeopleSoft on UNIX execute the appropriate script in the WebLogic domain directory that the PeopleSoft install created, as in PIA_HOME/webserv/peoplesoft/bin.

Single server – startPIA.sh
Multi server – domain admin server – startWebLogicAdmin.sh
Multi server – managed server – startManagedWebLogic.sh server

For example, startManagedWebLogic.sh PIA

16) How do you stop WebLogic Using the Command Line?

A) To stop WebLogic using the command line, enter the appropriate command.

Configuration – Windows – UNIX
Single server – stopPIA.cmd – stopPIA.sh
Multi server (WebLogic Admin server) – stopWebLogic.cmd – stopWebLogic.sh
Multi server (Managed WebLogic server) – stopWebLogic.cmd <ManagedServerName> – StopWebLogic.sh <ManagedServer Name>

Peoplesoft Admin Interview Questions # 17) How can you control WebLogic server life cycle?

A) control a WebLogic server’s life cycle primarily using a collection of scripts provided in that server’s WebLogic domain directory.

Each instance of a WebLogic server runs in an isolated Java Runtime Environment (JRE), regardless of whether you’re testing with a single-server configuration or implementing a multi-server configuration for production. All scripts must be launched from the WebLogic domain directory; and provide usage syntax if run with –help.

Peoplesoft Admin Interview Questions # 18) What is JVM Heap?

A) The JVM heap size is the amount of memory that a particular JRE (Java Runtime Environment) gives to the JVM (Java Virtual Machine) that it creates.

The java.exe command on Windows, java on UNIX and beasvc.exe when running WebLogic as a Windows service is the JRE, and the JVM exists within the JRE’s memory space. The primary sources for monitoring the amount of memory that is in use within a JVM are the Administration Console and the WebLogic logs.

Peoplesoft Admin Interview Questions # 19) How can you change the JVM Heap Size?

A) If you need to adjust any of the Java options, most commonly the JVM heap size, you must manually edit that WebLogic domain’s local setEnv script. The parameters, -Xms and -Xmx, control the JVM memory minimum and maximum heap size respectively.

20) What is PeopleSoft Configuration Manager?

A) PeopleSoft Configuration Manager is a Microsoft Windows application that simplifies development workstation administration by enabling you to adjust PeopleSoft registry settings from a central location.

You can set up one development workstation to reflect the environment at your site, then export the configuration file, which can be shared among other workstations. You can also define separate profiles for connecting to different PeopleSoft databases.

Peoplesoft Admin Interview Questions For Experienced

21) What are the PeopleSoft configuration parameters?

A) PeopleSoft configuration parameters are grouped on the Configuration Manager pages according to the function, feature, or tool that they control, including:

Startup settings.
Display settings.
Crystal report and Business Interlink settings.
Trace settings.
Workflow settings.
Remote call settings.
Developer workstations.
Importing and exporting environment settings.
Defining configuration profiles.

22) What is the use of PeopleSoft Configuration Manager?

A) PeopleSoft Configuration Manager simplifies Windows workstation administration by enabling you to adjust PeopleSoft registry settings from one central location.

It contains a variety of controls that let you set up Windows workstations running development and administrative applications, such as Application Designer and Data Mover.

You can set up one workstation to reflect the environment at your site, and then export the configuration file, which can be shared among all the workstations at your site.

You can also define separate profiles for connecting to different PeopleSoft databases. PeopleSoft configuration parameters are grouped on the Configuration Manager tabs according to the function, feature, or tool that they control.

23) What are the common Elements in PeopleSoft Configuration Manager?

OK – Saves your settings and exits PeopleSoft Configuration Manager.
Cancel – Closes PeopleSoft Configuration Manager without saving any changes that you have made.
Apply – Saves your changes without exiting.

Peoplesoft Admin Interview Questions # 24) How can you launch Configuration Manager?

A) At a command prompt, enter:

PS_HOME\bin\client\winx86\pscfg.exe

Peoplesoft Admin Interview Questions # 25) What is PeopleSoft Server Process Logs?

A) For each PeopleSoft server process, such as PSAPPSRV, the system writes an individual log file to your specified logs directory.

Depending on the logging level, these log files can contain varying amounts of information. Reviewing these log files regularly can help you to identify potential issues or system trends, and they are a valuable source of information when troubleshooting.

To understand the log information, it is helpful to be able to identify the various log fields that the system writes to an individual line in the log file.

26) Can you give an example of PeopleSoft Server Process Logs?

A typical log file contains these log fields:

[Server Process]:[Operating System Process ID] [Service Request Number] [Timestamp] [Log Level] [Message]

PSAPPSRV.5648 – (993) – [2012-12-12T11:54:23.778] – (3) – Authenticate User not needed. New User Id/Password same as current.

Peoplesoft Admin Interview Questions # 27) How can you configure PeopleCode Trace?

A) Select PeopleTools, Utilities, Debug, Trace PeopleCode to access the Trace PeopleCode page.

You use this page to change the PeopleCode tracing options while online. This page does not affect trace options that are set in PeopleSoft Configuration Manager.

Use Trace PeopleCode to create a file displaying information about PeopleCode programs processed from the time that you start the trace.

Peoplesoft Admin Interview Questions # 28) How can you configure SQL Trace?

A) Select PeopleTools, Utilities, Debug, Trace SQL to access the Trace SQL page.

You use this page to change the SQL tracing options while you’re online.

Peoplesoft Admin Interview Questions # 29) What is IDDA Logging?

A) The PeopleSoft Instrumented Development Diagnostic Aid (IDDA) logger, enables you to gather specific information about various areas within the PeopleSoft Internet Architecture and PeopleSoft Interaction Hub.

30) What are PeopleTools Utilities and what it contains?

A) The PeopleTools utilities are a set of various configuration and administration interfaces that serve as a browser-based method of setting numerous system settings.

These utilities, most of which are available through the PeopleTools utility menu, provide the ability to configure, maintain, or launch a wide range of features, including:

The System Information page.
The message catalog.
The spell check dictionary.
Translate values.
Application server caching.
SQR customization.
Table management and sharing.
Backward compatibility.
Remote database connection.
File attachments.
Stored URLs.
Mobile data synchronization (deprecated).
Update tracking.
Platform-specific database features.
Database auditing.
International settings.
Optimization utilities.
PeopleSoft Ping. Source

PeopleSoft HRMS Interview Questions Answers

PeopleSoft HRMS Interview Questions And Answers For Experienced 2018. If you are looking for Peoplesoft HRMS interview questions, then you are at the right place. Here we are sharing a list of real-time Peoplesoft HRMS interview questions and answers. This list will help you to crack your next Peoplesoft HRMS job interview. All the best and happy learning from Coding compiler.

PeopleSoft HRMS Interview Questions

What is PeopleSoft Enterprise HRMS?
What is PeopleSoft Enterprise HRMS Integrations?
What are the different components and component interfaces in PeopleSoft HRMS?
How PeopleSoft HRMS stores data?
What is a control table in Peoplesoft HRMS?
What are transaction tables in Peoplesoft HRMS?
What are Prompt Tables in PeopleSoft HRMS?
What are Business Units in PeopleSoft HRMS?
What are Tablesets and SetIDs in PeopleSoft HRMS?
What are Effective Dates and what are the benefits of it?

PeopleSoft HRMS Interview Questions And Answers

PeopleSoft HRMS Interview Questions 1) What is PeopleSoft Enterprise HRMS?

Answer # PeopleSoft HRMS is an integrated suite of applications and business processes that are based on PeopleSoft’s Pure Internet Architecture (PIA) and enterprise portal technologies.

The sophisticated features and collaborative, self-service functionality available in PeopleSoft HRMS enable you to manage your human resources from recruitment to retirement while aligning your workforce initiatives with strategic business goals and objectives.

PeopleSoft HRMS Interview Questions 2) What is PeopleSoft Enterprise HRMS Integrations?

Answer # PeopleSoft HRMS integrates with other PeopleSoft applications, such as PeopleSoft Enterprise Financials, PeopleSoft Enterprise Workforce Analytics, and PeopleSoft Enterprise Learning Management. PeopleSoft HRMS also integrates with other third-party applications. PeopleSoft HRMS uses various integration technologies to send and receive data.

PeopleSoft HRMS Interview Questions 3) What are the different components and component interfaces in PeopleSoft HRMS?

Answer # Component Component Interface

Departments component (DEPARTMENT_TBL) – DEPARTMENT_TBL

Establishment component (ESTABLISHMENT_DATA) – ESTABLISHMENT_DATA

Job Code Task Table component (JOBCODE_TASK_TABLE) – JOBCODE_TASK_TABLE

Job Code Table component (JOB_CODE_TBL) – CI_JOB_CODE_TBL

Job Tasks component (JOB_TASK_TABLE) – JOB_TASK_TABLE

Location component (LOCATION_TABLE) – LOCATION_TABLE

FLSA Calendar Table (FLSA_CALENDAR) – FLSA_CALENDAR

Pay Run Table (PAY_RUN_TABLE) – PAY_RUN_TABLE

Tax Location Table component (TAX_LOCATION_TBL) – TAX_LOCATION_TBL

PeopleSoft HRMS Interview Questions 4) How PeopleSoft HRMS stores data?

Answer # PeopleSoft HRMS is a table-based system that stores critical general data, such as companies, work locations, and system specifications in a central location. The system enables users to access the same basic information while maintaining data accuracy and integrity.

Tables that are central to PeopleSoft HRMS include control tables, transaction tables, and prompt tables.

Related Article For You: Peoplesoft Interview Questions

PeopleSoft HRMS Interview Questions 5) What is a control table in Peoplesoft HRMS?

Answer # Control Tables – Control tables store information that is used to process and validate the day-to-day business activities (transactions) users perform with PeopleSoft HRMS applications
.
The information stored in control tables is common and shared across an organization, for example, master lists of customers, vendors, applications, items, or charts of accounts. By storing this shared information in a central location, control tables help to reduce data redundancy, maintain data integrity, and ensure that users have access to the same basic information.

The information stored in control tables is generally static and is updated only when fundamental changes occur to business policies, organizational structures, or processing rules.

PeopleSoft HRMS Interview Questions 6) What are transaction tables in Peoplesoft HRMS?

Answer # Transaction Tables – Transaction tables store information about the day-to-day business activities (transactions) users perform with PeopleSoft HRMS applications.

The information stored in transaction tables often changes and is updated more frequently than the information stored in control tables.

PeopleSoft HRMS Interview Questions 7) What are Prompt Tables in PeopleSoft HRMS?

Answer # Prompt Tables – Prompt tables are tables that are associated with fields on PeopleSoft application pages and which display valid data values for those fields when a user selects a prompt or search option.

The data values stored in prompt tables are retrieved from control tables, transaction tables, or other PeopleSoft tables.

PeopleSoft HRMS Interview Questions 8) What are Business Units in PeopleSoft HRMS?

Answer # Business units are logical units that you create to track and report specific business information. Business units have no predetermined restrictions or requirements; they are a flexible structuring device that enable you to implement PeopleSoft HRMS based on how your business is organized.

You must define at least one business unit. The BUSINESS_UNIT field is included on all transaction tables.

PeopleSoft HRMS Interview Questions 9) What are Tablesets and SetIDs in PeopleSoft HRMS?

Answer # Tablesets and setIDs are devices that enable you to share – or restrict – information across business units. For example, with tablesets and setIDs you can centralize redundant information such as country codes while keeping information such as departments and job codes decentralized.

The overall goal of tablesets and setIDs is to minimize data redundancy, maintain data consistency, and reduce system maintenance tasks.

You must define at least one tableset (setID). The SETID key field is included on all control tables.

Related Article: Peoplesoft Technical Interview Questions

PeopleSoft HRMS Interview Questions 10) What are Effective Dates and what are the benefits of it?

Answer # PeopleSoft HRMS uses effective dates to store historical, current, and future information. Effective dates
enable you to:

Maintain a chronological history of your data. By storing effective-dated information in tables, the system enables you to review past transactions and plan for future events.
For example, you can roll back your system to a particular time to perform historical analyses for your company. Or, you can set up tables and data ahead of time without using tickler or pending files.
Maintain the accuracy of your data. By comparing the effective dates in prompt tables to the effective dates on application pages, the system displays only those values that are valid for the current time period.
For example, you create a new department code with an effective date of May 1, 2008. Then, on the Job Data pages, you enter a new data row for an employee with an effective date before May 1, 2008. When you select the prompt for the department field, you won’t see the new department code because it is not in effect.

PeopleSoft HRMS Interview Questions For Experienced

PeopleSoft HRMS Interview Questions 11) What is Person or Position Structure in PeopleSoft HRMS?

Answer # PeopleSoft HRMS enables you to structure or drive your PeopleSoft Enterprise Human Resources system by person or by position. Before you set up information in the control tables, you must decide which method to use. The system processes the information differently depending on your choice.

PeopleSoft HRMS Interview Questions 12) What’s the Difference between Person or Position?

Answer # When you drive PeopleSoft Human Resources by person, you use job codes to classify job data into groups. You use those codes to link person data to job data.

When you drive PeopleSoft Human Resources by position, you still use job codes to create general groups, or job classifications, in your organization, such as EEO (equal employment opportunity) and salary survey data, but you also uniquely identify each position in a job code and link people to those positions.

Job codes primarily have a one-to-many relationship with workers. Many workers share the same job code, even though they might perform the work in different departments, locations, or companies, as shown in the diagram below. You identify the job that a worker performs through the data that you enter in the worker’s job records.

In contrast, positions usually have a one-to-one relationship with workers. However, you can have several positions with the same job code; positions track details of a particular job in a specific department or location.

For example, in job code 1020, Administrative Assistant, you can define different administrative assistant positions with different position numbers—position 15 in accounting, position 16 in the human resources department, position 17 in your marketing department, and position 18 in your production group. Workers are then assigned to these specific positions.

PeopleSoft HRMS Interview Questions 13) Which Method Should You Use Person or Position?

Answer # To determine whether you should drive your system by person or position, consider the following:

If your organization is fluid (that is, if you tend to look at broader groups of workers and create new jobs often), then driving the system by person is probably best for you.
This method is useful if your organization is continually expanding or if new projects require that you create new jobs or job types regularly.
If your organization is fairly static (that is, if jobs and job descriptions are mostly fixed, and people move in and out of the same positions), then driving the system by position is probably best for you.
For example, government agencies and hospitals, which plan positions based on budgets (often well in advance of filling the positions), find this method very useful.

If you find that both methods work well in different areas of your organization, you can drive PeopleSoft Human Resources both ways.

PeopleSoft HRMS Interview Questions 14) What is your understanding of PeopleSoft HRMS System Data Regulation?

Answer # As companies grow larger and more complex, they often need to collect the same type of data across many locations. PeopleSoft business units and setIDs enable you to organize businesses into logical units other than companies and departments and to define how organizational data is shared among these units.

PeopleSoft HRMS system data is regulated through the use of business units, tablesets and setIDs, and tableset sharing. Business units are logical devices that enable you to implement PeopleSoft HRMS based on how your business is organized.

Tablesets, setIDs, and tableset sharing are organizational devices that enable you to share – or restrict – the information stored in your HRMS system across business units:

Business – Unit A logical organizational entity.
SetID – A high-level key on many control tables.
TableSet – Set of rows on a control table, grouped by setID, that is available to specific business units.

PeopleSoft HRMS Interview Questions 15) What are Business Units in PeopleSoft HRMS?

Answer # Business units are logical units that you create to track and report specific business information. Business units have no predetermined restrictions or requirements; they are a flexible structuring device that enable you to implement PeopleSoft HRMS based on how your business is organized.

Business units share processing rules and you can create them at any level of the organization that makes sense and that reflect the needs of your internal human resources departments.

If you use the same processing rules across the organization, it may make sense to have a single business unit; if you use different rules in different companies, countries, or functional areas, you may choose to create multiple business units.

Related Article For You: PeopleSoft Functional Interview Questions

PeopleSoft HRMS Interview Questions 16) What are Tablesets and how do you work with them?

Answer # To work with tablesets, you need to be able to distinguish between tablesets, setIDs, and tableset sharing:

tableset – A set of data rows in a control table that is identified by the same highlevel key.
setID – The highlevel key that identifies a set of data rows. There are two types of
setIDs:
• Physical SetIDs – The setID of a business unit (BUSINESS_UNIT = SETID). The rows of data in a physical setID have a one to one relationship with the business unit.
• Logical SetID – A logical setID that is generic and determined by business rules other than business unit. Logical setIDs enable you to share rows of data across multiple business units.
tableset sharing – Sharing rows of data in a tableset across business units or limiting rows to a single business unit.

PeopleSoft HRMS Interview Questions 17) What is Data Permission Security for HRMS?

Answer # Data permission security refers to controlling access to the rows of data in your system. In PeopleSoft HRMS, you can control access to the following types of data:

People.
Employees.
Contingent workers.
People of interest (POIs) with jobs.
People of interest (POIs) without jobs.
Recruiting job openings.
Departments.

PeopleSoft HRMS Interview Questions 18) What are Security Sets and Security Access Types?

Answer # A security set is a grouping of data that is being secured. The sets differ by the origin of the transaction security data.

For example, people of interest without jobs have a separate security set from people with jobs because the transaction data used to secure them does not come from the JOB record, but from the PER_POI_SCRTY record.

Security access types are ways of securing the data within a security set. Each security set has a number of security access types that you can choose to enable. Among other things, security access types determine:

The security transaction data.
If there is data security for future-dated rows.
If the access type uses a department security tree.

PeopleSoft HRMS Interview Questions 19) How do you implement data permission security?

Answer # To implement data permission security, use the Security Installation Settings component (SCRTY_INSTALL), the Security Sets component (SCRTY_SET_TBL), and the Security Access Type component (SCRTY_TYPE2_TBL).

PeopleSoft HRMS Interview Questions 20) What is Future-Dated Security?

Answer # The Security Installation Settings page enables you to select actions that, when used on the Work Location page (JOB_DATA1), trigger the SavePostChange PeopleCode to create a future-dated row in SJT_PERSON.

Advanced PeopleSoft HRMS Interview Questions

Related Article: PeopleTools Interview Questions

PeopleSoft HRMS Interview Questions 21) How do you SetUp and Assigning Tree-Based Data Permission?

Answer # To set up and use tree-based data permission, use the Tree Manager component (PSTREEMGR), Security Tree Audit Report component (RUNCTL_PER506), Security by Dept Tree component (SCRTY_DATA), and Refresh SJT_CLASS_ALL component (SCRTY_OPR_RC).

PeopleSoft HRMS Interview Questions 22) How do you modify Security Trees?

Answer # You can modify an existing tree by changing either the nodes or the levels. When you modify a security tree, the tree node numbers usually change, so you need to refresh the numbers. You also need to run the Refresh SJT_CLASS_ALL process to update the data access profiles and security join tables.

PeopleSoft HRMS Interview Questions 23) How do you allow Workers to Update Their Own Data?

Answer # PeopleSoft HRMS doesn’t allow users to update their own data except in the self-service internet applications.

However, sometimes you might want them to update some of their own data in other components. To allow users to update their own data, you implement the PeopleCode function Allow EmplIDChg (allow emplID change).

The function looks for a single Boolean parameter. When the parameter is set to true, workers can update their own data; when it is set to false, they cannot.

PeopleSoft HRMS Interview Questions 24) How do you administer Country Codes?

Answer # To administer country codes, use the Country Table (COUNTRY_TABLE), the Country Table – HR (HR_COUNTRY_TABLE), and the State/Province (STATE_DEFN) components.

PeopleSoft HRMS Interview Questions 25) What is Search/Match?

Answer # To use the full functionality of your system, you must maintain the integrity of your database. With users from many departments entering data into your system, you want to minimize the entry of duplicate or multiple records. Search/Match enables you to define criteria to check for duplicate or multiple ID records.

The searchable ID types (called Search Types) are:
• Person (EmplID)
• Applicant (HRS_PERSON_ID within PeopleSoft Enterprise Talent Acquisition Manager)

Real-Time PeopleSoft HRMS Interview Questions

PeopleSoft HRMS Interview Questions 26) How do you setup Search/Match?

Answer # To set up Search/Match use the Search Match Rules (HCR_SM_RULE), Search/Match Parameters (HCR_SM_PARM), Search/Match Result Fields (HCR_SM_RSLT_FLDS), Search/Match Results (HCR_SM_RESULT), and Search/Match (HCR_SM_SEARCH) components.

PeopleSoft HRMS Interview Questions 27) What is the difference between Search Box Search and Search/Match?

Answer # The difference between record search from search dialog pages and using Search/Match is this: You use search box pages to retrieve existing records using limited search criteria to view or update data, and you use Search/Match to use a larger set of search criteria that detect duplicate or multiple records in your database or to identify different records that contain duplicate data that should uniquely identify only one ID.

PeopleSoft HRMS Interview Questions 28) What are Frequency IDs?

Answer # Frequency IDs are used in PeopleSoft Enterprise Human Resources, Global Payroll, and Payroll for North America. Frequency IDs are defined on the Frequency Table component (FREQUENCY_TBL). Each frequency ID has a frequency type and an associated annualization factor that represents the number of times that the period occurs in the course of a year.

PeopleSoft HRMS Interview Questions 29) How do you setup person of interest types?

Ansewr # To set up person of interest types, use the Person of Interest Types (POI_TYPE_TBL) component.

PeopleSoft HRMS Interview Questions 30) What are Establishments?

Answer # You use the Establishment component to define distinct physical places of business (establishments) within your company, to enter address information, and to enter regulatory reporting information. In PeopleSoft Human Resources, you define establishments that are consistent with the regulatory requirements of your business operations.

In PeopleSoft Human Resources, an establishment:

Has an address.
Is associated with a company.
Is used for regulatory purposes.

PeopleSoft Functional Interview Questions Answers

Peoplesoft Functional Interview Questions And Answers For Experienced 2018. Here Coding compiler sharing a very good list of 30 Peoplesoft interview questions with answers. We hope that these interview questions will help you to crack your next Peoplesoft job interview. All the best for your future and happy learning.

Peoplesoft Functional Interview Questions

What are the different payment methods in PeopleSoft?
What is the P2P Cycle in PeopleSoft?
What is the main business process of Accounts Payable?
What are the Voucher Staging tables available in PeopleSoft?
What are the main components for setting the hire template in PeopleSoft?
What are the methods available to update worker’s compensation packages?
What is a regulatory region? What is the use of regulatory region?
What are all the statuses used to define templates?
List out different kinds of organizational relationships in PeopleSoft HRMS as per the person model?
What are all the statuses available on the template hire status page?

Peoplesoft Functional Interview Questions And Answers

Peoplesoft Functional Interview Questions 1) What are the different payment methods in PeopleSoft?

Answer # System Check and EFT are two of the most common Payment Methods used by enterprises. Apart from these, PeopleSoft Payables also supports many other Payment Methods.

They are:

Most Common Payment Methods:

System Check
Electronic Funds Transfer — EFT

Other Payment Methods:

Manual Check
Draft Customer Intiated
Draft Customer EFT
Draft Vendor Intiated
Automated Clearing House — ACH
Direct Debit
Giro-EFT
Giro-Manual
Letter of Credit
Wire Transfer

Peoplesoft Functional Interview Questions 2) What is the P2P Cycle in PeopleSoft?

Answer # This Process includes Procurement to Payment cycle.

Requistion
Purchase Order
Receipt
Voucher
Payment

Peoplesoft Functional Interview Questions 3) You have an interface file coming into PeopleSoft from a third-party system that sends details of already approved vouchers. An App Engine loads the file into the Voucher Staging tables. When the Voucher build process runs, it would be apt to create pre-approved vouchers for this origin. How would you set the system up to mark the Vouchers created from this origin as pre-approved?

Answer # We need to do small set up change at Voucher Origin

Below are the steps:

Open the Voucher Origin Set-Up
(Set Up Financials/Supply chain > Product Related > Procurement Options > Vouchers > Voucher Origin)
Click on Vouchering Options 1 Tab
Voucher Approval Options — Check the radio button : Pre-Approved

Peoplesoft Functional Interview Questions 4) What are main business process of Accounts Payable?

Answer # Payables Business process overview:

Create Vouchers and payments process using manual and automatic processes.
Country-specific tax withholding
Matching the vouchers with the purchase orders and receipts
Post the vouchers
Maintain vouchers throughout their life cycle.
Create drafts, single voucher payment, prepayments, and self-billed invoices.
Optionally, send electronic payments to PeopleSoft Financial Gateway.
Analyze accounts payable information using online inquiries, and by generating reports.
Archive accounts payable data

Peoplesoft Functional Interview Questions 5) What are the Voucher Staging tables available in PeopleSoft?

Answer # To load vouchers into PeopleSoft, we first load them into the Voucher Staging tables and then run the Voucher Build to create Vouchers from the staged data.

PS_VCHR_HDR_STG;
PS_VCHR_LINE_STG;
PS_VCHR_DIST_STG;

PS_VCHR_HDR_QV;
PS_VCHR_LINE_QV;
PS_VCHR_DIST_QV;

These are two staging tables used to load data through voucher build process into main voucher tables

PS_VOUCHER;
PS_VOUCHER_LINE;
PS_DISTRUB_LINE;

Related Article For You: Peoplesoft Interview Questions

Peoplesoft Functional Interview Questions 6) What are the main components for setting the hire template in PeoplfSoft?

Answer # Template Record/Field

Template Section

Template Category Table

Template Creation

Peoplesoft Functional Interview Questions 7) What are the methods available to update worker’s compensation packages?

Answer # Seniority Pay Increases

Grade Advance increases

Automated step increases

Step increases using review bands

Amount increases

Percentage increases

Peoplesoft Functional Interview Questions 8) What is a regulatory region? What is the use of regulatory region?

Answer # 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.

Benefits of using regulatory region

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.

Peoplesoft Functional Interview Questions 9) What are all the statuses used to define templates?

Answer # Test (Default Value)

Active

Inactive

Peoplesoft Functional Interview Questions 10) List out different kinds of organizational relationships in PeopleSoft HRMS as per the person model?

Answer # Different organization relationships a person can have are:

Employee

Contingent worker

Person of Interest

Related Article: Peoplesoft Technical Interview Questions

Real-Time Peoplesoft Functional Interview Questions

Peoplesoft Functional Interview Questions 11) What are all the statuses available on the template hire status page?

Answer # Pending Hires

Cancelled Hires

Processed Hires

Peoplesoft Functional Interview Questions 12) What are the levels available in tree manager?

Answer # Level

Node

Parent

Sibling

Child

Peoplesoft Functional Interview Questions 13) What are Global assignments?

Answer # Global assignments enables the organization to assign employees to a global assignment and to monitor, compensate and track education, qualifications for the employee and dependents as they move to multiple locations in the organization having presence in different geographies.

Peoplesoft Functional Interview Questions 14) What are all the various types of SJT?

Answer # SJT_CLASS

SJT_CLASS_ALL

SJT_PERSON

SJT_DEPARTMENT

Peoplesoft Functional Interview Questions 15) What is the most important Record in PS HRMS?

Answer # JOB record

Peoplesoft Functional Interview Questions 16) What is Home and Host concept?

Answer # Employees are based in a Home location.

The employee data, benefits and payroll information is maintained at the home location.

The new location where the employee moves is the Host location.

Peoplesoft Functional Interview Questions 17) How is international assignments security implemented?

Answer # PeopleSoft delivers three options for International Security:

i) Home can see Host
ii) Host can see Home
iii) Both

International Security can be setup by navigating to:

Setup HRMS -> Security -> Core Row Level Security -> Security Installation Settings

Peoplesoft Functional Interview Questions 18) For the action of Short Term Disability, what is the resulting employee status?

Answer # Leave of Absence

Peoplesoft Functional Interview Questions 19) A company wants you to set the dependent age limit to 19 for all benefits. Which table should you use?

Answer # Benefit Program Table

Peoplesoft Functional Interview Questions 20) When working on a conversion, what does PeopleSoft recommend you use as the initial effective dates on the Job Code Table?

Answer # Accommodate your longest tenured employee.

Related Article: PeopleTools Technical Interview Questions

Peoplesoft Functional Interview Questions For Experienced

Peoplesoft Functional Interview Questions 21) Which table has SetID as a high-level key?

Answer # Location Table

Peoplesoft Functional Interview Questions 22) Which HRMS module does NOT use the Group Build functionality?

Answer # Payroll

Peoplesoft Functional Interview Questions 23) A customer asks you to set up a medical plan on the Benefit Plan Table. Which table must you set up first?

Answer # Provider/Vendor Table

24) our client has seasonal workers and wants to base the annual compensation rate on 125 work days per year. On which table do you define this requirement?

Answer # Frequency Table

25) Where do you enter default values that are specific to a PeopleSoft user?

Answer # Org Defaults by Permission List

26) A customer wants to set up a vacation plan and have the ability to track the vacation balances. Which three tables must be set up before you can track the vacation balances?

Answer # Provider/Vendor Table, Earnings Table and Benefit Program Table.

27) On the Job Earnings Distribution Page, what are three ways you can distribute the employee’s compensation?

Answer # To a different Department, To a different Job Codes and/or Position and To a different General Ledger Type.

28) Which deduction classification is used to set up a savings plan employer before-tax match?

Answer # Nontaxable Before-Tax Benefit

29) What is the purpose of EMPLOYEES table in PS? How is this table populated?

Answer # EMPLOYEES table is a current employee information table. This is primarily used in interfacing with third party systems or in business reporting as well in conjunction with EMPLOYMENT which is now a view.

30) What is job family? How is it different from job codes in PS?

Answer # To identify a particular job in PS HRMS we use job code. Example: You can have a job code representing Administrative assistant. This jobcode will have a defaulted salary grade and standard hours. A collection of multiple such jobs grouped together which use this job code will make a job family.

PeopleSoft PeopleTools Interview Questions Answers

45 PeopleSoft People Tools Interview Questions And Answers For Experienced 2018. Here Coding compiler sharing a very good list of people tools interview questions. We hope that these interview questions will help you to crack your next Peoplesoft job interview. All the best for your future and happy learning.

Peoplesoft People Tools Interview Questions

What is the difference between Key and alternate search Key?
Which effective dated rows can be retrieved in update/display mode, update/display all and correction mode?
What types of audits are supported by people soft? In case of record level audit what is the structure of table?
What are Table Edits?
What conditions are required to establish parent child relationship between two records? What are the advantages with that?
Can you hide a primary page in a component? Reason?
Can you place Sub page into Grid? If yes How?
What is an Expert Entry?
What is Auto Update?
What is Record Group? Which records can be included into a record group?

Peoplesoft People Tools Interview Questions And Answers

People Tools Interview Questions # 1) What is the difference between Key and alternate search Key?

Answer # KEY-It is the primary key of the record. Can be used as search key or need not be.
Alternate search key-it is used for searching purposes.

People Tools Interview Questions # 2) Which effective dated rows can be retrieved in update/display mode, update/display all and correction mode?

Answer # Update/display – can view current and future rows. Can update only future rows.
Update/display all – can view history, current and future rows. Can update only future rows.
Correction – can view and update history, current and future rows.

People Tools Interview Questions # 3) What types of audits are supported by people soft? In case of record level audit what is the structure of table?

Answer # We have field level audit and record level audit. The structure of the table in record
level audit is: AUDIT_OPRID, AUDIT_STAMP, AUDIT_ACTN, AUDIT_RECNAME and can
add fields from record.

People Tools Interview Questions # 4) What are Table Edits?

Answer # We have prompt table edit, yes/no table edit, translate table edit as the table edits.

People Tools Interview Questions # 5) What conditions are required to establish parent child relationship between two records? What are the advantages with that?

Answer # Conditions are:
1) The child record should have all the key fields of parent record and at least one more
key field other than the key fields of parent record.
2) We should mention the parent record in the record properties of child record.
3) We can not go for more than three levels of parent/child relationships.

Advantages are:
1) To have referential integrity.
2) No need to enter information again and again

Related Article For You: Peoplesoft Interview Questions

People Tools Interview Questions

People Tools Interview Questions # 6)

Answer # Can you place Sub page into Grid? If yes How?
Yes we can insert subpage using insert subpage. After insert subpage into main page, drag the subpage into the grid. When we save the page we are successfully able to save the page showing that we can insert a subpage into a grid.

People Tools Interview Questions # 7) Can you hide a primary page in a component? Reason?

Answer # No we can not hide the primary page of a component. If the component had only one page then by making this page also invisible we won’t have any component existing so we are not allowed to hide the primary page.

People Tools Interview Questions # 8) What is an Expert Entry?

Answer # Expert entry enables a user to change from interactive to deferred mode at runtime for appropriate transactions

People Tools Interview Questions # 9) What is Auto Update?

Answer # This record field property is used to update the date field of particular record with the server’s current date and time whenever a user creates or updates a row. Even the user enter the data into that field, the data which the user enters will be updated by the system’s current date and time.

People Tools Interview Questions # 10) What is Record Group? Which records can be included into a record group?

Answer # Record group consists of records with similar functionality. To setup a record in record group we should enter a set control field value in record properties.

Related Article: Peoplesoft Technical Interview Questions

People Tools Interview Questions And Answers

People Tools Interview Questions # 11) How can you improve the security and usability of a Prompt table edit?

Answer # Prompt table view

People Tools Interview Questions # 12) What are the different ways to setup row level security?

Answer # We can setup row-level security using a SQL view that joins the data table with an authorization table. andBy having Query search for data using a query security record definition. The query security record definition adds a security check to the search.

People Tools Interview Questions # 13) How does peoplesoft use views? Which are online functions?

Answer # People soft uses views for search records, summary pages, prompt views, reports. Search records and summary pages are online functions.

People Tools Interview Questions # 14) Why do PeopleSoft often use views as search records?

Answer # Search views are used for three main reasons.

Adding criteria to the search dialogue page
Providing row level security.
Implementing search page processing.

People Tools Interview Questions # 15) How can a component have more than one search record? Give a situation.

Answer # You might want to reuse the same component multiple times with different search records. You can accomplish this by overriding the component search record at runtime when the component is opened from a menu item without creating separate copies of the component.

The component override is temporary and occurs only when the component is opened from the menu item in which the override is set. It does not change the component definition.

16. What is PIA and what are its components?

Answer # It is n-tier architecture. We have client, web server, application server and Database server. We have jolt and tuxedo. We have WSL, WSH, JSL, JSH, QUEUES and services.
In database server we have system tables, peopletools tables and application tables.

People Tools Interview Questions # 17) Differentiate Field edit and Save edit?

Answer # In Field edit for each field change, a transition to the application server to the database is taken place.
In Saveedit for all the fields , only one transition to the application server to the Database is taken place.

People Tools Interview Questions # 18) What are think time functions?

Answer # Think-time functions suspend processing either until the user has taken some action (such as clicking a button in a message box), or until an external process has run to completion.

People Tools Interview Questions # 19) In which events error & warning are used most extensively.

Answer # Field edit, Save edit, Search save, row delete, row insert

People Tools Interview Questions # 20) Is there any way by which you can find out whether the user is in Add mode or Update mode?

Answer # %mode—returns A—for Add mode. Returns U –for Update mode.

People Tools Peoplesoft Interview Questions

People Tools Interview Questions # 21) What is the purpose of the SQLEXEC function? What are its benefits and draw backs?

Answer # SQLEXEC is used to execute the sql statements(select,insert,update,delete). We can get only one row at a time.

People Tools Interview Questions # 22) How is the searchinit event most often used by people soft application?

Answer # Searchinit fires before the search dialogue page is displayed to the end user.For this reason searchinit is often used to enhance roll level security by inserting and graying out certain values to the search dialogue page.

People Tools Interview Questions # 23) What are the options for using SQL in people code?

Answer #
a) sqlexec
b) Record class methods (selectbykey,delete,insert,update)
c) Using sql class, its properties and methods.

People Tools Interview Questions # 24) What is the difference between component buffer and data buffer?

Answer # Component buffer contains all the data of the active component. Data buffer contains the data other than the data in the component buffer (Data of other records)

People Tools Interview Questions # 25) What databuffer classes are available in people code?

Answer # Rowset, Row, Record, Field, Array, File, Sql, chart, grid and so on.

People Tools Interview Questions # 26) When we select a component what events will be fired?

Answer # If default mode for component is search mode: only searchinit will fired.
If default mode for component is new mode :field default, field formula, rowinit, searchinit.

People Tools Interview Questions # 27) What are different variables in people code and their Scope?

Answer # System variables and User defined variables. Scope —Global, Component, Local.

People Tools Interview Questions # 28) What is default processing?

Answer # In default processing, any blank fields in the component are set to their default value. You can specify the default value either in the Record Field Properties, or
in FieldDefault PeopleCode

People Tools Interview Questions # 29) What is difference between field default and Row init?

Answer # Field default specifies only the default value for a field when we are in Add mode. Row init fires only when a row of data coming from database to component buffer

People Tools Interview Questions # 30) What is difference between saveprechange and savepostchange?

Answer # Saveprechange—last event that executes before updating the data from component buffer to the database.

Savepostchange –fires after the updation of data in the database.

45 People Tools Peoplesoft Interview Questions And Answers

PeopleTools Interview Questions # 31) Which function directly interacts with the database?

Answer # SQLEXEC — function directly interacts with the database.

PeopleTools Interview Questions # 32) What is Getlevel0()? What is the use of %subrec and %selectall functions?

Answer # Getlevel0()—used the get the rowset of the level0.
%subrec–is used only in Dynamic View SQL where it expands to the columns of a subrecord:
%selectall–%SelectAll is shorthand for selecting all fields in the specified record, wrapping date/time fields with %DateOut, %TimeOut.

People Tools Interview Questions # 33) What is an array in people code? What is maximum dimension of an array?

Answer # An array is a collection of data storage locations, each of which holds the same type of data.
The maximum depth of a PeopleCode array is 15 dimensions.

PeopleTools Interview Questions # 34) Which function inserts values into an array? What is “pop”?

Answer # Push and unshift are the functions of the array used to add the elements into the array one from the end of the array and one from the beginning.
Pop is a function of array used to select and delete an element from the end of the array.

PeopleTools Interview Questions # 35) What is difference between Getrowset and Createrowset in people code?

Answer # Getrowset –is used to get rowset for a record in the component buffer.
Createrowset—is used to create rowset for a record which in database, and is also called a Standalone rowset

PeopleTools Interview Questions # 36) Can you save the component programmatically?

Answer # Using Dosave and Dosavenow functions.

PeopleTools Interview Questions # 37) What is differed processing and its advantages?

Answer # Postpones some user actions to reduce the number of trips to the database so that increases the performance (in system edits, field edit, and field change).

Advantages:
1) Reduces the network traffic.
2) Increases the performance.

PeopleTools Interview Questions # 38) Write the syntax to access third level record field using object oriented peoplecode?

Answer # &fld=Getlevel0()(1).GetRowset(Record.<level1 record>.GetRow(1),
GetRowset(Record.<level2record>).GetRow(1),
GetRowset(Record.<level3 record>).GetRow(1),
GetRecord(Record.<level3 record>).GetFieild(Field.<field name>))

PeopleTools Interview Questions # 39) What are the built-functions used to control translate values dynamically?

Answer # Adddropdownitem()
Deletedropdownitem()

PeopleTools Interview Questions # 40) How to populate data into grid in online?

Answer # &Rs.Select or Scrollselect().

SECURITY – Before accessing a people soft application what levels of security must be passed through.

Field level security
Row level security
Maintain security
Definition security
Portal security

PeopleTools Interview Questions # 41) What is the use of primary permission list in user profile?

Answer # Primary permission list is used for mass change and definition security purposes

PeopleTools Interview Questions # 42) How to authorize the user to run a process or report?

Answer # To authorize a user to run a process, the process group which contains the process or report should be added to the permission list of that user.

PeopleTools Interview Questions # 43) How to give access to the records that are to be used in a query?

Answer # To give access to the records that are to be used in query, we have create a new query security tree and add the records which we want to give the access and then
assign a access group to the tree. After that we have to add that query tree and query access group to the permission list.

PeopleTools Interview Questions # 44) What are the rules used by the system to determine whether a user is authorized to update an object?

Answer # The user should have the permission to update the object. This is given by the Definition security. The group which holds the object should be added to the permission list of the user in update mode.

PeopleTools Interview Questions # 45) What are the different ways we can set up the portal security to access component in portal?

Answer #

Structure & content
Menu import
Register component

Peoplesoft Technical Interview Questions And Answers

Peoplesoft Technical Interview Questions And Answers. If you are looking for technical interview questions on Peoplesoft, then you are at right place. Here Coding compiler presenting a list of 25 Peoplesoft Technical Interview Questions. We hope that these questions will help you to crack your next Peoplesoft job interview. All the best for your future and happy learning.

PeopleSoft Technical Interview Questions

What is the difference between Application Engine vs SQR?
What is the difference between Exit(1) and Exit(0)?
What is the order of people code events firing?
What is the difference between FieldChange Event and FieldEdit Event?
What is the difference between PostBuild Event and PreBuild Event?
Describe RowInit Event?
Explain SaveEdit Event in PeopleCode?
What is the difference between SavePrechange and SavePostchange Events?
What is the difference between SaveEdit and Fieldedit?
What is the component processor?

PeopleSoft Technical Interview Questions And Answers

PeopleSoft Technical Interview Questions # 1

In PeopleSoft we extensively use both App engines and SQRs. In many cases, we can get an App engine to perform the same tasks that an SQR does. In certain other cases, this is not possible. Can you compare and contrast between Application Engine and SQR.

Answer # Application Engine vs SQR

The differences between Application engine and SQR are

1. Restartability:

AE : Application Engines are Restartable from the point where they had failed.
SQR: But SQRs are not Restartable. We will have to run them from first… i mean rerun.

2. Encapsulation:

AE: Can use Application packages, thus bringing in encapsulation and other object oriented programming concepts.
SQR: Code is not encapsulated, we will not be able to use App Packages but SQCs serve the purpose to an extent.

3. Reporting:

AE: Later versions of people tools enable AE to create reports with help of XMLP
SQR: Easy Report Creation with enhanced printing

4. Debugger:

AE: It has a built-in debugger
SQR: Lacks built-in debugger but we can make use of the “debug”.

5. Viewability:

AE:Can view only one block of code at a time
SQR:Can view the entire program at once

6. Use of Message Catalog

AE:Can use Message Catalogs which can be passed on easily through log messages action.
SQR:Cannot use Message Catalogs, it only has to access the message catalog meta table to fetch messages

7.Invoking the process via PeopleCode

AE:Can be called from People code [CallAppEng, create process request]
SQR:Can be called from People code [ create process request]

8. Parallel Processing:

AE:Parallel processing with help of temp tables for optimization
SQR:Load Lookup is used for optimization

9. Meta Data:

AE:Has Meta SQL like %selectinit , %updatestats
SQR:Lacks Meta SQL support

10.About the Tool:

AE:A PeopleSoft tool [Acquired by oracle]
SQR:A Hyperion tool [Acquired by oracle]

11.Data Dictionary:

AE: Data Dictionary Integration [Data Dictionary Integration is nothing but the synchronization of the definition changes like field name, length with those definitions in the AE program. This is possible because of AE resides within PeopleSoft database]
SQR: Not possible

PeopleSoft Technical Interview Questions # 2

In an App Engine PeopleCode, it’s not uncommon to see code that works on the following logic. You have a condition and if it’s TRUE, you want Exit(1) to execute.

If the condition is FALSE, you would like Exit(0) to execute.
Depending on the way in which you have designed the App Engine, this can completely change its flow.

Can you explain what is the difference between Exit(1) and Exit(0)?

Answer # Any non-zero return code is some kind of error. The way it will be handled depends on “On Return” value for each step of application engine.

So exit(0) – is success

exit(1) and On Return = Abort – is error and exit program immediately
exit(1) and On Return = Break – is exit current step and section
exit(1) and On Return = Skip Step – exits current step, continue with next step

Exit(1) : Terminate the AE immediately and rollback all DB changes made
exit(0) : Terminate the AE immediately but will not rollback the DB changes made.

PeopleSoft Technical Interview Questions # 3

We use a State Record to keep data accessible across Actions. We can have many State Records for an App Engine. Do you know if we can have an App Engine that does not have a State Record?

Answer # Yes. We can have an AE without any state record.

PeopleSoft Technical Interview Questions # 4

In some cases, we would like to take the users directly to the page rather than letting them go through a search page, ie; we would like to bypass the search page in a Component. How would you achieve this?

Answer # We can skip the search record using these 2 ways.
1. Search record should not have any search keys like INSTALLATION table.
2. We can skip search page through peoplecode as well, i.e, Write SetsearchBehavior() function in Search Init event.

PeopleSoft Technical Interview Questions # 5

It’s common to write PeopleCode that fires only when a Component is accessed in a particular mode. We use a System Variable called %Mode that returns a character based on the present mode and then, use it in a conditional statement to achieve this.

PeopleSoft PeopleCode Technical Interview Questions

Can you list the different modes available in PeopleSoft and the corresponding values that %Mode would return?

Answer # In peoplecode there are 6 types of mode:

Numeric Value Constant Value Description
A %Action_Add Add
U %Action_UpdateDisplay Update/Display
L %Action_UpdateDisplayAll Update/Display All
C %Action_Correction Correction
E %Action_DataEntry Data Entry
P %Action_Prompt Prompt

PeopleSoft Technical Interview Questions # 6

You are generating a file from an Application Engine and you need to have the date time stamp appended to the file name. You can do this in numerous ways, can you tell me one of the easiest ways to achieve this?

Answer # This can be done by appending this statement to the filename.

DateTimeToLocalizedString(%Datetime, “ddMMyy-HHmmss”);

PeopleSoft Technical Interview Questions # 7

Order of people code events firing?

Answer #

1. Searchinit
2. Searchsave
3. Rowselect
4. Prebuild
5. Field Default
6. Field Formula
7. RowInit
8. PostBuild
9. Activate
10. FieldEdit
11. FieldChange (PrePopup, ItemSelected)
12. RowInsert
13. RowDelete
14. SaveEdit
15. SavePreChange.
16. WorkFlow
17. SavePostChnage.

PeopleSoft Technical Interview Questions # 8

What is the difference between FieldChange Event and FieldEdit Event ?

Answer #

FieldChange Event – Use FieldChange PeopleCode to recalculate page field values, change the appearance of page controls, or perform other processing that results from a field change other than data validation. To validate the contents of the field, use the FieldEdit event.
The FieldChange event applies to the field and row that just changed.

FieldChange PeopleCode is often paired with RowInit PeopleCode. In these RowInit/FieldChange pairs, the RowInit PeopleCode checks values in the component and initializes the state or value of page controls accordingly. FieldChange PeopleCode then rechecks the values in the component during page execution and resets the state or value of page controls.

FieldEdit Event – Use FieldEdit PeopleCode to validate the contents of a field, supplementing standard system edits. If the data does not pass the validation, the PeopleCode program should display a message using the Error statement, which redisplays the page, displaying an error message and turning the field red.
FieldEdit PeopleCode can be associated with record fields and component record fields.

PeopleSoft Technical Interview Questions # 9

What is the difference between PostBuild Event and PreBuild Event ?

Answer #

PostBuild Event – The PostBuild event is initiated after all the other component build events have been initiated. This event is often used to hide or unhide pages. It’s also used to set component variables.

PostBuild PeopleCode is only associated with components.During the PostBuild event you will have access to the data read from the database into the component buffer structure. That’s why it is called PostBuild.

PreBuild Event – The PreBuild event is initiated before the rest of the component build events. This event is often used to hide or unhide pages. It’s also used to set component variables.

PreBuild fires before any PeopleCode events on all the rows and fields in the component such as FieldDefault and RowInit. During the PreBuild event there will not be any data in the component buffer structure other than search record as its executing prior to the component build process. That’s why it is called PreBuild.

PeopleSoft Technical Interview Questions # 10

Describe RowInit Event ?

Answer # The RowInit event is initiated the first time that the Component Processor encounters a row of data. IUse it to set the initial state of component controls.

This occurs during component build processing and row insert processing. It also occurs after a Select or SelectAll Rowset method, or a ScrollSelect or related function, is executed. RowInit is not field-specific.it triggers PeopleCode on all fields and on all rows in the component buffer.Do not use Error or Warning statements in RowInit PeopleCode: these cause a runtime error.

PeopleCode Technical Interview Questions

PeopleSoft Technical Interview Questions # 11

Explain SaveEdit Event in peoplecode ?

Answer # The SaveEdit event is intiated whenever a user attempts to save the component. You can use SaveEdit PeopleCode to validate the consistency of data in component fields. Whenever a validation involves more than one component field, you should use SaveEdit PeopleCode. If a validation involves only one page field, use FieldEdit PeopleCode. SaveEdit is not field-specific: it triggers associated PeopleCode on every row of data in the component buffers, except rows flagged as deleted.

PeopleSoft Technical Interview Questions # 12

Difference between SavePrechange and SavePostchange Events.

Answer #

SavePreChange Event -The SavePreChange event is initiated after SaveEdit completes without error.SavePreChange PeopleCode provides one final opportunity to manipulate data before the system updates the database.In Save Prechange we can get the data from Component Buffer for that particular Component.

SavePostChange Event – SavePostChg is different from all other Peoplecode events since it is performed after the updates are made on the database.SavePost change Component Buffer is cleared we have to get data from Database and this is used to update values outside the database.

PeopleSoft Technical Interview Questions # 13

Difference between SaveEdit and Fieldedit ?

Answer # Fieldedit event is fired every time for each row when field is edited where as
SaveEdit is fired only once when a user click on save button .

PeopleSoft Technical Interview Questions # 14

What is the component processor?

Answer # Component processor is a runtime engine that controls processing of an application from the time user request the component from the menu till the database is updated and processing of component is completed.

PeopleSoft Technical Interview Questions # 15

Explain about the component buffer and data buffer?

Answer # Component Buffer contains all the Data of active component. The data buffer is used to store data added from sources other than the component, such as from a PeopleSoft Application Engine program, an application message, and so on.

PeopleTools 8 provides an alternative to the scroll level, row, and field components in the form of the data buffer classes Rowset, Row, Record, and Field, which you reference using dot notation with object methods and properties.

Technical Peoplesoft Interview Questions

PeopleSoft Technical Interview Questions # 16

Difference between SQLExec and CreateSql?

Answer # SQLExec can only select a single row of data. If your SQL statement retrieves more than one row of data SQLExec sends only the first row to its output variables. Any subsequent rows are discarded. CreateSQL If you need to SELECT multiple rows of data use the CreateSQL or GetSQL functions and the Fetch SQL class method.

PeopleSoft Technical Interview Questions # 17

Explain about ACTIVE event?

Answer # The Activate event get fired each page gets activated. Active PeopleCode can only be associated with pages. The event is used for security validations such as field enabling and hiding a scroll, enabling user to programmatically control the display of that page controls. This event is used for component build processing in add mode and update mode.

PeopleSoft Technical Interview Questions # 18

What is deferred processing?

Answer # Deferred processing is used speed up the data-entry process. This means that the system does not validate the data for each field as you Tab through a page. You can enter in all the data for your page without unnecessary trips to the server for data validation. Entered data is validated when:

You navigate to another page in the component
Click the Save button
Click the Refresh button (access key: Alt+0)

If there are any errors in your data, you are notified at this time.
Field Edit event will not fire until we press the SAVE button if the deferred processing is ON.

PeopleSoft Technical Interview Questions # 19

Difference between Getrowset and Createrowset?

Answer # GetRowset is used to get rowset for a record in the component buffer.
CreateRowset is used to create rowset for a record which is in database, and is also called as standalone rowset.

PeopleSoft Technical Interview Questions # 20

What is scrollflush() function ?

Answer # Used to remove all rows inside target scroll area and frees it associated buffer. Rows that are flushed are not deleted from the database. This function is often used to clear work scroll before a call to ScrollSelect.
Syntax: ScrollFlush (scrollpath)

Frequently Asked PeopleSoft Technical Interview Questions

PeopleSoft Technical Interview Questions # 21

Explain about the workflow event?

Answer # WorkFlow PeopleCode executes immediately after SavePreChange and before database update that precedes SavePostChange. The main purpose of the workflow event is to segregate PeopleCode related to workflow from the rest of applications PeopleCode. Only PeopleCode related workflow (Such as triggerbusinessevent) should be in workflow programs. Your program should be deal with workflow only after my SavePreChange process completed.

PeopleSoft Technical Interview Questions # 22

Explain Think-time function?

Answer # Think-time functions suspended processing until the user has taken some actions (such by clicking button in message box), or until external function has run to completion (for example a remote process).
Think-time function hold avoids the following events: SavePreChange, Workflow, RowSelect, SavePostChange.

PeopleSoft Technical Interview Questions # 23

In which PC events dosave function is useful?

Answer # FieldEdit, FieldChange, or ItemSelected.

PeopleSoft Technical Interview Questions # 24

Where does you set the web server cache?

Answer # Webserver configuration.properties file

PeopleSoft Technical Interview Questions # 25

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

Answer # PSAPPSRV.CFG

Category: PeopleSoft Interview Questions

Peoplesoft Admin Interview Questions And Answers 2018

Peoplesoft Admin Interview Questions

Peoplesoft Admin Interview Questions And Answers

Peoplesoft Admin Questions And Answers

Advanced Peoplesoft Admin Interview Questions

Peoplesoft Admin Interview Questions For Experienced

RELATED INTERVIEW QUESTIONS AND ANSWERS

PeopleSoft HRMS Interview Questions Answers

PeopleSoft HRMS Interview Questions

PeopleSoft HRMS Interview Questions And Answers

PeopleSoft HRMS Interview Questions For Experienced

Advanced PeopleSoft HRMS Interview Questions

Real-Time PeopleSoft HRMS Interview Questions

RELATED INTERVIEW QUESTIONS

PeopleSoft Functional Interview Questions Answers

Peoplesoft Functional Interview Questions

Peoplesoft Functional Interview Questions And Answers

Real-Time Peoplesoft Functional Interview Questions

Peoplesoft Functional Interview Questions For Experienced

RELATED INTERVIEW QUESTIONS

PeopleSoft PeopleTools Interview Questions Answers

Peoplesoft People Tools Interview Questions

Peoplesoft People Tools Interview Questions And Answers

People Tools Interview Questions

People Tools Interview Questions And Answers

People Tools Peoplesoft Interview Questions

45 People Tools Peoplesoft Interview Questions And Answers

RELATED INTERVIEW QUESTIONS

Peoplesoft Technical Interview Questions And Answers

PeopleSoft Technical Interview Questions

PeopleSoft Technical Interview Questions And Answers

PeopleSoft PeopleCode Technical Interview Questions

PeopleCode Technical Interview Questions

Technical Peoplesoft Interview Questions

Frequently Asked PeopleSoft Technical Interview Questions

RELATED INTERVIEW QUESTIONS