How to Find Expected Time of Completion of an Oracle Query

by Apurva T. April 6, 2013
Especially in case of poorly performing SQLs, all eyes are on the SQL and we’re eager to see when the SQL would complete. Upon completion, we can view the statistics and find ways to improve it. Wouldn’t it be better if there was a way to find the expected time of completion of an Oracle […]
Read the full article →

How to Change SQL Plus Settings

by Apurva T. April 3, 2013
I do not like the default size of the SQL *Plus window and prefer to customize it as per my preference. You can also do the same by changing the default parameters of SQL Plus. You can perform the following changing in SQL *Plus: Change cursor size Change command history Change fonts Change layout Change […]
Read the full article →

PeopleTools 8.53 – Understanding Installation Locations

by Apurva T. April 1, 2013
From PeopleTools 8.5 onwards, the installation locations have been split up to make it easier to perform upgrades and provide maintenance. PeopleTools 8.53 has 5 Installation Locations, which are as mentioned below: PS_HOME PS_APP_HOME PS_CFG_HOME PS_CUST_HOME PIA_HOME As you proceed through the PeopleSoft PeopleTools installation process, you are asked to specify several installation locations. This […]
Read the full article →

PeopleTools 8.53 – What is a PeopleSoft File Server, Database Server, Application Server, Batch Server and Web Server

by Apurva T. March 24, 2013
A typical PeopleSoft installation consists of several logical components, which are known as PeopleSoft Client, PeopleSoft File Server, PeopleSoft Database Server, PeopleSoft Application Server, PeopleSoft Batch Server and PeopleSoft Web Server. Lets have a look and what all these stand for and how do they differentiate from each other. What is PeopleSoft Client PeopleSoft Client […]
Read the full article →

PeopleTools 8.53 – How to Uninstall PeopleSoft PIA from IBM Websphere

by Apurva T. March 20, 2013
You might need to uninstal the PeopleSoft Pure Internet Architecture from IBM WebSphere. In PeopleTools 8.53, you cannot uninstall PeopleSoft PIA simply by deleting <PIA_HOME>\webserv\<profile_name>, without uninstalling it from IBM WebSphere Administration Console. If you happen to delete <PIA_HOME>\webserv\<profile_name>, the IBM WebSphere registry becomes corrupt, and subsequent attempts to install PeopleSoft PIA will fail. The […]
Read the full article →

Component Interface Interview Questions

by Kelly March 17, 2013
Here is a list of frequently asked questions on Component Interface. If you’re planning to appear in a PeopleSoft technical interview, component interface is something, which you need to know at any cost. It is essential that you know the basics rather than knowing just the answers. Suggested reading – PeopleSoft Developer’s Guide. Question: Which […]
Read the full article →

Understanding Incoming Requests (Learning PeopleSoft Integration Broker Part 4)

by Apurva T. March 14, 2013
As explained in part 2 of this series, incoming request messages are considered to have two logical parts – credentials and the message body. The integration broker infrastructure does not need to understand the contents of the message body in order to process the message. Only part of the message it is interested in is the […]
Read the full article →

How the Integration Broker Handles Outgoing Requests (Understanding PeopleSoft Integration Broker Part 3)

by Apurva T. March 13, 2013
It is assumed that you’ve already read the Part 1: Understanding Integration Broker – Introduction and  Part 2 of the series on Understanding Integration Broker – How the Integration Broker Handles Incoming Requests. PeopleSoft handles the outgoing messages in the same manner, regardless of the specific outgoing Target Connector being invoked. 1) Application Server generates […]
Read the full article →

How the Integration Broker Handles Incoming Requests (Understanding PeopleSoft Integration Broker Part 2)

by Apurva T. March 12, 2013
Let’s discuss how the integration broker handles incoming requests. It is assumed that you’ve already read the Part 1 of this series – Understanding PeopleSoft Integration Broker.  There is a series of events which happen when a PeopleSoft Integration Broker receives incoming requests. 1) When a request is received by a Listening Connector, the first […]
Read the full article →

Understanding PeopleSoft Integration Broker – Introduction (Part 1)

by Apurva T. March 11, 2013
PeopleSoft Integration Broker can be daunting for those who are new to Integration Broker and hence, this post has been written with the intend of helping those who want to learn PeopleSoft Integration Broker. Skills for understanding PeopleSoft Integration Broker are PeopleTools, PeopleCode and Application Engine are a must. Additional experience in XML, SOAP, HTTP, […]
Read the full article →

How to Find PeopleSoft Processes/PSJobs in a Recurrence

by Apurva T. March 10, 2013
Do you want to find out all processes and jobs running under a particular recurrence? Use this SQL below: SELECT process_job_name,  description, recurname FROM   ps_prcsrecur a, (SELECT p.prcsname  AS Process_Job_name, p.descr     AS Description, p.recurname AS recurname FROM   ps_prcsdefn p UNION SELECT jp.prcsjobame AS Process_Job_name, (SELECT j.descr FROM   ps_prcsdefn j WHERE  j.prcsname = jp.prcsname) AS Description, jp.recurname AS recurname FROM   ps_prcsjobdefn j,  ps_prcsjobitem jp WHERE  j.prcsjobname = jp.prcsjobname) b WHERE b.recurname = a.recurname AND a.recurname = :1 ORDER  BY 1Share this ..emailLinkedinFacebook0Google+0
Read the full article →

Syntel PS Admin Interview Questions

by Prashant March 8, 2013
Below is the list of questions which are submitted by one of our readers who gave interview in Syntel for a PeopleSoft Admin role. These questions were actual interview questions that were asked.. Tell me something about your experience Current environment Have you worked on PeopleTools Upgrade How often do you do monthly install in […]
Read the full article →

Query result set too large, (124,87). Result of (SQL Fetch) is over the maximum result size specified for the application server.

by Apurva T. March 5, 2013
One of the common errors encountered while running a PSQuery is: “Query result set too large, (124,87). Result of (SQL Fetch) is over the maximum result size specified for the application server.“ As the error message suggests, this error has been caused due to huge result size, which the application server is unable to render […]
Read the full article →

How to Add Custom Message in PeopleSoft Login Page

by Apurva T. March 4, 2013
PeopleSoft login page is a great place to inform users about any upcoming outages or to welcome new users. You can do these activities via emails as well, but you can not ensure that your emails are read. The only way to ensure that your message is read is to put it on the PeopleSoft […]
Read the full article →

PeopleSoft Portal Sync

by Apurva T. March 1, 2013
When you migrate permission lists and portal registries from one database to another, Portal Security Sync process has to be run in the target environment for these permission lists and portal registries to take effect. If your company has separate roles for PeopleSoft Admin and Security Admin, you also have the option of ignoring to […]
Read the full article →

How to Run nVision Reports in PeopleSoft 9.1

by Apurva T. February 28, 2013
Here is an great documentation on how to run nVision Reports in PeopleSoft 9.1 How to Run nVision Reports in PeopleSoft 9.1 Right Click and Save as to download the document.Share this ..emailLinkedinFacebook0Google+0
Read the full article →

PSQuery Not Running

by Apurva T. February 26, 2013
Came across a situation where the PSQuery does not run even after you click of ‘Run’ or ‘Run to Excel’ or ‘Run to HTML’. This post is to address such situations. On clicking these buttons/links nothing happens and the page(browser) remains AS-IS instead of launching new window to run the PS-Query where it would also […]
Read the full article →

How to Enable COBOL Trace in PeopleSoft

by Apurva T. February 23, 2013
COBOLs are an integral part of PeopleSoft. If your PeopleSoft base has NA Payroll, Global Payroll or Payroll Interface modules installed, you’re likely to come across COBOL issues once a while. Some of these might need to enable COBOL trace for further troubleshooting. You can enable COBOL trace in PeopleSoft in both two tier and […]
Read the full article →