PeopleSoft SQR Interview Questions

by Kelly July 29, 2013

SQRs are used at almost all the establishments, which use PeopleSoft. Most of them use SQRs for reporting purposes and need you to demonstrate expert level skills in PeopleSoft SQR. You can also refer to an excellent guide on PeopleSoft SQR interview questions. Here is a list of PeopleSoft interview questions on SQRs, which will help […]

Read the full article →

Cloud Acronyms Explained

by Apurva T. July 28, 2013

Cloud computing offers a wide array of services ranging and thus employs a number of acronyms, which are easy to get confused with if your work does not deal with these acronyms on a daily basis. Understanding what you read about cloud computing will require a good memory for acronyms. Bookmark this page or keep […]

Read the full article →

Renaming a Default Local Node

by Apurva T. July 26, 2013

There are several situations in which you might need to rename a node definition. PeopleSoft allows you to rename of delete a node because of such reasons. One of the situations where you might need to rename a default local node could be that you created a new instances by copying the database from production. […]

Read the full article →

The program can’t start because MSVCR100.dll is missing from your computer

by Apurva T. July 23, 2013

“The program can’t start because MSVCR100.dll is missing from your computer” is quite common issue when application was writen using C++ dll and not distributed with those dll’s or installation had some issues. When you try to bring up AppDesigner in 2-tier or 3-tier mode, you might see this error. This error has been common especially […]

Read the full article →

Integration Broker Authentication: Invalid Authentication type (AUTHOPTN) for node PSFT_LM. (158,452)

by Apurva T. July 16, 2013

This issue “Integration Broker Authentication: Invalid Authentication type (AUTHOPTN) for node PSFT_LM. (158,452)” has been documented in Oracle Support as well with ID 1127403.1. The reason for this error is that the two nodes are not able to talk to each other because of different authentication type (hint is in the error – Invalid Authentication […]

Read the full article →

How To Change Logo Inside PeopleSoft Application

by Prashant July 15, 2013

Default Oracle Logo is visible in top left corner in the PeopleSoft PIA, but if you want you can change the logo to something else. E.g Logo of your organization etc. You can change the logo by simply saving your customized image with the same name that is being referred online by the current PeopleSoft […]

Read the full article →

Integration Gateway Message Unmarshalling: Missing value for the following field : ConnectorClassNam

by Apurva T. July 14, 2013

I was doing Integration Broker setup when I got this error: Integration Gateway Message Unmarshalling: Missing value for the following field : ConnectorClassNam This error is received when you try to ping a node: I checked in MyOracleSupport and found a case related to the same – ID 752128.1 The case said that the error […]

Read the full article →

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 →