Prashant

Author Archives: Prashant

PeopleSoft DBA Interview Questions – Part3

1)      Tell about yourself and responsibilities ? 2)      What are the  basic day to day activities? 3)      What is report notes? 4)      What is jolt? 5)      What is PIA? 6)      What are the basic services? 7)      What is the PeopleSoft security? 8)      In 7.5 to 8.8 what is the security difference? 9)      Difference in All ID? […]

Continue reading

What are Tuxedo Processes

TUXEDO stands for Transactions for UniX Extended for Distributed Operations. Tuxedo is one of the most important base on which PeopleSoft Application Server is based. When an application server is booted there are several Tuxedo services that are started along with other Application Server processes. A)  BBL: ( Bulletin Board Liaison) The Bulletin Board Liaison […]

Continue reading
1

Applying Oracle Patches in PeopleSoft

1. Overview Patch sets are a mechanism for delivering fully tested and integrated product fixes on a regular basis. Patch sets provide bug fixes only; they do not include new functionality, and do not require certification on the target system. Patch sets include all the libraries that have been rebuilt to implement the bug fixes […]

Continue reading

PeopleCode Interview Questions – Part1

What is the difference between SQL Object and SQL Exec? SQL Object can be used with Fetch to return multiple rows, whereas SQLExec can fetch only one row. What is the difference between User defined and System Defined Variables? User-defined variables These variable names are preceded by an & character wherever they appear in a […]

Continue reading
3

PeopleSoft DBA Interview Questions – Part2

Note: Some of the information related to setup and installation may no longer be valid due to ever changing Operating Systems and application versions/architecture. If you have any specific doubts, please post it in the comment section. 1)      What are the PSDBA responsibilities? Installation of PeopleSoft, upgrades, administration, applying tools& Application patches,fixes &service packs, refreshes of database ,supports PS […]

Continue reading
3

Peoplesoft Upgrade Overview

  1.What is an Upgrade? A PeopleTools Upgrade updates the underlying PeopleTools tables ( and files ) only. No changes are made to Application data, only PeopleSoft system data is changed. Normally this is a PSAdmin project which does not require Application specialists. Since application data remains untouched, most user would not even know the […]

Continue reading

How To Bypass PeopleSoft SignOn Page

PeopleSoft access is controlled by user id/password but sometimes you would need to publish a PeopleSoft page to public i.e users who don’t have access to PeopleSoft. Lets say you want to show the PeopleSoft career page on your company’s website where applicants can apply for job. As these application won’t be having access to […]

Continue reading
1

What is JOLT and related processes

PeopleSoft application server relies on Jolt, a companion product that co-exists with Tuxedo, to handle all web requests. In other words, Jolt is the bridge between PeopleSoft application server and the web server (any supported one) that facilitates web communication. Tuxedo helps schedule PeopleSoft application server processes to perform the actual transactions. When the application […]

Continue reading

What is PeopleSoft Batch Environment

What is PeopleSoft Batch Environment? Its a combination of databases, the batch server, the process files (located on the batch server or elsewhere) any clients that run batch routines and all process scheduler services. Batch environment allows us to run pre programmed routines either on demand or on a scheduler. Along with its work to […]

Continue reading

How Does PeopleSoft Signon Work

PeopleSoft Signon process may appear confusing sometimes with involvement of several ids (user id, connect id, owner id) during the authentication process but it’s quite logical and very well designed. PeopleSoft signon process is very critical for a PeopleSoft admin to understand. If you do not understand how PeopleSoft signon works – you will never […]

Continue reading
2

PeopleSoft Technical Interview Questions

Are you looking for a PeopleSoft Job?  Check out these PeopleSoft Technical Interview Questions and test your knowledge. 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 […]

Continue reading

Migration of Peoplesoft Objects

1. Overview The PeopleSoft Object migration process is the method of “moving”, or migrating objects and lines of code from the development to the production environment in phases, after thorough functional testing. The PeopleSoft DBA generally performs migrations to the production environment at the request of an application developer or functional analyst.  Developers are permitted […]

Continue reading