SQL To List Project Items in PeopleSoft

by Prashant July 12, 2013
Every PeopleSoft Developer may have worked on App Designer projects which have so many PeopleSoft objects and code changes that it’s very hard to keep track of these and document them. Instead of opening every project and listing down the objects one by one, you can simply run a SQL query to list all the […]
Read the full article →

Hide PeopleSoft Menus from Portal Navigation

by Prashant July 11, 2013
Here is quick tip on how to hide menus from the PeopleSoft Portal Navigation. You can hide the PeopleSoft menus that you don’t use in your application. Go to PeopleTools > Portal > Structure & Content Find the Menu you want to hide and then click ‘Edit’. In the Folder Administration screen make sure to […]
Read the full article →

Cannot establish HTTP connection (158, 2842)

by Apurva T. July 10, 2013
I’ve been struggling with this error “Cannot establish HTTP connection (158, 2842).” I’ve seen almost all the possible blog articles and all the Oracle cases on the topic and continue to struggle with the issue. So, if you see this issue – you’re likely to find this article quite handy. Due to this issue, you’re […]
Read the full article →

Integration Gateway: No response received from Gateway (158,10829)

by Apurva T. July 9, 2013
This error is applicable for PeopleTools 8.4x and 8.5x and is one of the most common Integration Broker issue. When trying to ping the node, or send to it a message results in the following error: No response received from Gateway. The Gateway did not send back a IBResponse or Integration Gateway: No response received […]
Read the full article →

Taming the Work Week

by Kelly July 2, 2013
Do you stay late in office and get home by the dinner time? Do you want to be productive so that your work week does not stretch beyond 50 hours every week (if you’re an employed professional, you are likely putting in more than 50 hours every week)? How do you tame your work week […]
Read the full article →

Installing Crystal on PeopleTools 8.53

by Apurva T. June 27, 2013
SAP bought Crystal Reports way back in 2011 and since, there is no love lost between SAP and Oracle, there is always an influx of changes in the licensing between Oracle and SAP. As of July 1, 2011, Oracle will no longer distribute or provide a license to Business Objects Enterprise or Crystal Reports for […]
Read the full article →

ORA-01555: snapshot too old

by Apurva T. June 24, 2013
We were doing stress testing in PeopleSoft ELM and ran the Mass Enrollment AppEngine. After running for about 90 minutes, it failed with the error ORA-01555: snapshot too old: rollback segment number 19 with name “_SYSSMU19_1270741541$” too small The ORA-01555 error is caused by Oracle read consistency mechanism and is usually associated with long running […]
Read the full article →

Common Database Errors

by Apurva T. June 13, 2013
Common Database Errors Following is a list of known SQL errors, and potential solutions to the problems that they represent. Known Database Error Codes Database Error Code SQL State Message Solution DB2 -803 23505 SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are […]
Read the full article →

Why Upgrade to PeopleSoft 9.2 – Infographic

by Apurva T. June 9, 2013
What is an Infographic? Infographics or Information graphics are graphic visual representations of information, data or knowledge intended to present complex information quickly and clearly. They can improve cognition by utilizing graphics to enhance the human visual system’s ability to see patterns and trends. The process of creating infographics can be referred to as data […]
Read the full article →

How to Perform Load Testing in PeopleSoft

by Apurva T. May 31, 2013
Load testing has several names – load testing, stress testing, regression testing, performance testing, scalability testing and so on. Essentially what these names refer to a testing where you can simulate the real-time environment and perform testing before you go-live with your system. When it comes to PeopleSoft, such scenarios are common when you plan […]
Read the full article →

Function Based Indexes in PeopleSoft

by Apurva T. May 28, 2013
Those who have not comes across performance issues in PeopleSoft, especially PeopleSoft on Oracle might not be aware of this thing called performance issues due to function based indexes. PeopleSoft has given a lot of headache to Oracle database engineers as well as customers when it comes to function based indexes. By definition, a function-based […]
Read the full article →

Which is the Best Browser to run PeopleSoft on?

by Apurva T. May 24, 2013
It has been quite a few years that I completely switched over to Firefox and Chrome. I don’t not even remember how the IE performs. Though I’ve read that IE has improved a lot over the years, I was happy sticking to Firefox and Chrome. I was working with a user on performance issues when […]
Read the full article →

Understanding PeopleSoft Trace File for Performance Tuning

by Apurva T. May 22, 2013
Making sense of a PeopleSoft trace file is absolutely essential for resolution of performance issue(s). You may face an issue where users are complaining of slow performance and OEM is not capturing the SQL – you have two options: Find the SQL using PeopleSoft trace or enable a database trace. You should first try to […]
Read the full article →

How To Check if PeopleTools Patch Is Correctly Applied

by Prashant May 21, 2013
Lets say you just finished applying PepleTools 8.53.03 patch and now when you’re trying to run the application, you’re getting errors. You may be getting errors while booting Application Server, while configuring Web Server, even while accessing PeopleTools Application Designer or some other random error. All these components were working fine before you installed PeopleTools […]
Read the full article →

PeopleTools 8.53: Installing PeopleTools 8.53.03 Patch

by Prashant May 20, 2013
Many visitors have requested to provide steps for applying PeopleTools patch. I hope you have been following our other posts on installing HCM 9.2 on Windows 7 and installing PeopleSoft 9.2 Image on Oracle Virtual Box. PeopleSoft 9.2 Image comes pre-configured with PeopleTools 8.53.02 whereas the PeopleTools 8.53 CDs that are available on edelivery.oracle.com don’t […]
Read the full article →

PeopleSoft Trace Analyzer – TraceMagic

by Apurva T. May 20, 2013
PeopleSoft trace files contain tons of information and depending on the kind of information you need from a trace file – it can turn out to be a daunting task. Wouldn’t it be nice if there was a tool to analyze the PeopleSoft trace files? If you are ready to make sense of *.tracesql files […]
Read the full article →

SQL Monitoring in OEM 12c

by Apurva T. May 19, 2013
SQL Monitoring was instrumented and available for command line use in the first release of the Oracle Database 11g. The graphical user interface to monitor active running SQL made its debut in Grid Control and Database Control Basically, the data from the GV$ views, is aggregated and presented in a user-friendly interactive fashion […]
Read the full article →

8 Most In-Demand Tech Skills for 2013-2014

by Apurva T. May 17, 2013
Technology has been moving at such a breakneck pace that if you’ve not started learning the newer technologies, you might be preparing yourself to face the worst – loose your job! Not long ago, some of these skills were considered hot and are no longer a guarantee for success. The time is now – learn […]
Read the full article →