PeopleSoft 9.2 Upgrade: What is UPGCOUNT

by Prashant March 3, 2014

UPGCOUNT is a delivered Application engine program which is used to generate a report showing the row count of PeopleSoft tables. UPGCOUNT is run as part of PeopleSoft application upgrade and can be run on demand too. During application upgrade, it is automatically invoked by change assistant and UPGCOUNT.LIS report file is generated with the […]

Read the full article →

Productivity Mastery & Time Management

by Kelly March 2, 2014

We all have dreams and goals that we’ve forgotten about.Getting through the chaos of the day leaves us with little energy to work towards our dreams and goals. Frustrated? Nothing gets done and more work piles up? Exhausted? Need to make time for yourself? Do you feel trapped by your hectic schedule? Are things still […]

Read the full article →

Ubuntu Reference Cheat Sheet

by Apurva T. March 1, 2014

As a PeopleSoft admin, you will need to work with Ubuntu, but you do not need to an expert of Ubuntu. All you need to be good at are a few things only. If you want to be great at Ubuntu – you should get the book Ubuntu Unleashed 2013 Edition. Ubuntu Reference If you want […]

Read the full article →

How to Install Oracle 32 bit Client on Windows 64 bit and avoid the error INS-30131

by Apurva T. February 28, 2014

You may receive the following error when trying to install the Oracle Client 32-bit and 64-bit on the same Microsoft Windows x64 (64-bit) machine: Installation of Oracle12c Release 1 Client 32-bit Failed: “[INS-30131] Initial Setup Required For The Execution Of Installer Validations Failed. You may receive this error when trying to install the  Oracle Client 32-bit […]

Read the full article →

Oracle Virtual Box: How to take backup of PeopleSoft Virtual Images

by Prashant February 26, 2014

Depending on their type, PeopleSoft Virtual Images can be used for application maintenance, demo, training and upgrade activities. Over a period of time, you may end up making changes to delivered PeopleSoft virtual images. To avoid losing any changes that you made, you can take backup of your PeopleSoft virtual image and Oracle Virtual Box […]

Read the full article →

What are PeopleSoft Fixes, Patches, Bundles, Maintenance Packs ?

by Apurva T. February 25, 2014

Here is a refresher of some of the commonly used terms, which you use in your daily life as a PeopleSoft consultant. Fixes – Smallest unit of maintenance. A fix generally resolves a single specific issue. For example, Oracle may give you a fix for a production down issue. Patches – Patches are very similar […]

Read the full article →

PeopleSoft 9.2 Upgrade: Upgrade Planning Files and UPGOPT project

by Prashant February 24, 2014

When we start PeopleSoft Upgrade, target environment (Copy of Production) needs to be setup first so that upgrade steps, scripts can run successfully during upgrade pass. This process involves copying projects, files and other scripts into the target environment. Step ‘Applying Upgrade Planning Files’ involves copying UPGOPT project from new release PS_APP_HOME to the target […]

Read the full article →

PeopleSoft Update Manager: PI_HOME inaccessible

by Prashant February 13, 2014

When configuring PeopleSoft Update Manager using Change Assistant, you are required to map pi_home directory on your local system . If you don’t map the pi_home, Change Assistant configuration won’t finish and you can’t generate and apply patches using PUM tool. Below are few things that may help you in fixing this issue. 1. Make sure you are […]

Read the full article →

PeopleSoft Virtual Image Crashed

by Prashant February 10, 2014

Since the time PeopleSoft Virtual Images have been available for download and deployment, I have been a great fan of these. PeopleSoft Virtual images truly makes it easier for anyone to deploy and start using PeopleSoft in matter of couple of hours. PeopleSoft Images work fine in most of the cases but I had faced few issues which […]

Read the full article →

PeopleSoft Update Manager: User not authorized to access to PeopleSoft

by Prashant February 7, 2014

Recently I was working on configuration of PeopleSoft Update Manager to apply ‘Required at Upgrade’ fixes on my Upgrade Source Image and had deployed both the PeopleSoft HCM Image 9.2.005 and HCM Upgrade Source. But during the Change Assistant configuration, I got this error “User not authorized to access to PeopleSoft”. As I was using […]

Read the full article →

Understanding Oracle vs PeopleSoft Databases

by Apurva T. January 17, 2014

An Oracle database is a set of SQL objects defined by one system catalog in the SYSTEM tablespace and one SID (System IDentifier), using one instance of the Oracle server executables and associated files. Within Oracle shops, the Oracle database is commonly referred to as the Oracle SID. A PeopleSoft database is a set of […]

Read the full article →

Steps for a PeopleSoft Installation

by Apurva T. January 7, 2014

PeopleSoft installations need to be done in a certain order to minimize the issues, which arise with installation. Following are the sequence of steps you need to go through for PeopleSoft installation. These steps are generic and give you an idea of the overall process irrespective of the software, hardware and PeopleSoft/PeopleTools version you decide […]

Read the full article →

What are different types of PeopleSoft Virtual Images?

by Prashant December 23, 2013

As most of you would already know that Oracle is now delivering PeopleSoft Virtual Images that can be used for variety of purposes like Demo, training purposes, applying patches, during upgrade etc. One thing to note here is that there are 3 different types of images currently available and you should review these image types, then decide and deploy […]

Read the full article →

E-ORA SYS.DBMS_STATS has errors ORA-06508: PL/SQL: could not find program unit being called: SYS.DBMS_STATS

by Apurva T. December 5, 2013

While doing PeopleTools upgrade via Change Assistant, you may encounter this error: E-ORA SYS.DBMS_STATS has errors ORA-06508: PL/SQL: could not find program unit being called: SYS.DBMS_STATS The error message is indicative enough to suggest that there are invalid dba_objects. To make sure, run the below command: SQL> select owner, object_name, object_type, status from dba_objects where […]

Read the full article →

PeopleSoft Interview Questions

by Kelly November 28, 2013

Below are the recent interview questions for a position in Corning Inc, NY. The position was for PeopleSoft Administrator. The answers provided by the candidate are also mentioned. You can have a look at the questions and answers and compare it with what you would have answered. 1) How do you configure app server and […]

Read the full article →

List of PeopleSoft Integration Broker Tables

by Apurva T. November 23, 2013

  Here is the list of PeopleSoft Integration Broker tables according to their categories. Please note that this list will not match completely your PeopleTools version because Oracle tends to add or remove tables with different PeopleTools release. However, the important Integration Broker tables will continue to find favor and will remain in the list. […]

Read the full article →

Cannot activate more than one master domain (158,2836)

by Apurva T. November 20, 2013

In PeopleTools release 8.51 and higher, by default, only one domain can be active in the Integration Broker system as no more than one active PUBSUB domain is recommended. Those already in on PeopleTools 8.51 or higher would have seen it and those who’re moving to the latest version of PeopleTools are likely to see […]

Read the full article →

The Ultimate Python Programming Tutorial

by Kelly November 19, 2013

Since 2008, Python has consistently ranked in the top eight most popular programming languages as measured by the TIOBE Programming Community Index. Strong Python programming skills can better your chances at landing a job at Google, Yahoo, NASA and many other top companies of the world. If you want to learn Python and learn it […]

Read the full article →