vi Command Reference Cheat Sheet

by Apurva T. March 8, 2014

This vi editor command reference cheat sheet presents the majority of vi commands and keys. We hope you find it useful. We also recommend two good books on vi (mentioned below). How to Use Unix-Linux vi Text Editor vi Pocket Reference vi Command Reference Cheat Sheet Invoking vi: vi filename Command mode versus input mode […]

Read the full article →

How To Customize the PeopleSoft Header Logo in PeopleTools 8.53

by Apurva T. March 7, 2014

To enable your establishment’s branding and help users identify each instance – you may want to customize the branding after you do PeopleTools 8.53 upgrade. Easiest way to customize the PeopleSoft header logo in PT 8.53 is to save your company’s logo/image with the same name that is being referred in PIA by the current […]

Read the full article →

Learning Oracle SQL the Easy Way

by Apurva T. March 6, 2014

If you plan to use Oracle – the most powerful database in the world, there is one skill you need to learn anyhow whether you want to become Oracle PL/SQL programmer or Oracle database administrator. The skill is SQL. The greatest fact about learning SQL is that the skill works across databases. Even if tomorrow […]

Read the full article →

How to Install PeopleTools 8.53 on Windows 8

by Apurva T. March 4, 2014

The usual way to install PeopleTools is to execute Disk1\InstData\setup.exe file and it opens a user interface mode. Check this: Install PeopleTools 8.53 on Windows 7 to see what I’m talking about. When you try the same in Windows 8, you will see an error like this: Installer UI Mode Error – Installer User Interface […]

Read the full article →

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 →