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
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
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
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
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)
Mention what are the different types of service operation does PeopleSoft Integration Broker provides?
PeopleSoft integration broker supports four types of services
-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
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?
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?
Dynamic(Guess: Temp Table, check People books App Engine)
What are all stored in System Catalog?
Process Profile contains?
-Sequence of processes
-Sequence of jobs
File format for SQR?
PeopleSoft clients wants to get info about PSPT where to find it?
Which of the following are object definitions?
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
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:
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?
PS Query definition is stored on which 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 configuration.properties 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