Prashant
Author Archives: Prashant
Prashant
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 readingPeopleCode 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 readingMigration of Peoplesoft 3rd Party Objects
1. Overview Following are a few major 3rd Party tools that are supported by PeopleSoft Applications. Changes are occasionally made to the delivered code in order to suit the business needs as per the customer’s requirements. COBOL SQR nVision Crystal As part of standard requirements, COBOL and SQR program migration needs to be done at […]
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