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 ..

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 →

PSQuery Tables

by Apurva T. February 16, 2013

PSQuery tables are all PeopleTools tables. Here is the complete list of PeopleTools meta tables that store all the possible information about PSQueries. These tables are specific to Tools version 8.50 and could vary slightly in earlier and later versions. There are situations when you might need this list of tables, like when you need […]

Read the full article →

Generating Key Store and Trust Store using Keytool

by Prashant February 10, 2013

What is a Keytool? Keytool is a key and certificate management utility. It enables users to administer their own public/private key pairs and associated certificates for use in self-authentication. It also allows users to cache the public keys (in the form of certificates) of their communicating peers. What is a Keystore? Keytool stores the keys […]

Read the full article →

PeopleSoft License Codes

by Apurva T. February 8, 2013

PeopleSoft license codes are needed when you do a fresh install of a PeopleSoft demo or any other install. You also need this license code when you apply PeopleSoft application bundles and patches or when you do PeopleTools upgrade or apply a patch. If your customer already has a license, you can very well get […]

Read the full article →

Steps Involved in PeopleSoft Installation

by Prashant February 6, 2013

INSTALL ORACLE → TUXEDO → PEOPLE TOOL → PS APPLICATION (HRMS / Finance) → WebLogic / WebSphere → CREATE SHELL DATABASE →       ↓ Open PS      ← Configure PIA ← Configure WebServer ← Configure Process Scheduler ← Configure Application Server ← Run DATAMOVER SCRIPT Webserver from browser ↓ Configure Report Node → Install PeopleBook → […]

Read the full article →

What are Important Files on PeopleSoft Web Server

by Prashant February 3, 2013

As you would know that PeopleSoft has several different components which have their own role to play in PeopleSoft Architecture. These components have different file structures and contains important executables and configuration files. We have listed the directory structure of these major PeopleSoft components and compiled a list of important directories and file within them. […]

Read the full article →

What are Important Files on PeopleSoft Application Server

by Prashant February 2, 2013

As you would know that PeopleSoft has several different components which have their own role to play in PeopleSoft Architecture. These components have different file structures and contains important executables and configuration files. We have listed the directory structure of these major PeopleSoft components and compiled a list of important directories and file within them. […]

Read the full article →

What are Important Files in Tuxedo Directory

by Prashant February 1, 2013

As you would know that PeopleSoft has several different components which have their own role to play in PeopleSoft Architecture. These components have different file structures and contains important executables and configuration files. We have listed the directory structure of these major PeopleSoft components and compiled a list of important directories and file within them. […]

Read the full article →

What are Important Files on PeopleSoft Process Scheduler

by Prashant January 30, 2013

As you would know that PeopleSoft has several different components which have their own role to play in PeopleSoft Architecture. These components have different file structures and contains important executables and configuration files. We have listed the directory structure of these major PeopleSoft components and compiled a list of important directories and file within them. […]

Read the full article →

What are the Processes running on Process Scheduler

by Prashant January 29, 2013

PSPRCSRV:( PSPRCSRV.EXE) The server agent is responsible for starting all server processes Ever fifteen seconds it looks into the process request for server processes that are scheduled to run If nothing is scheduled the server agent “sleeps for 15 seconds and checks again If a server process is scheduled the server agent combines the data […]

Read the full article →

Mandatory Processes in PeopleSoft Application Server

by Prashant January 27, 2013

People soft processes are designed to communicate with database. At the direction of WSH/JSH, the PS process queries the database and objects using SQL. The Mandatory PS processes are 1.     PSAPPSRV 2.     PSSAMSRV 3.     PSQRYSRV 4.     PSQCKSRV 5.     Specialized Services PSDBGSRV PSOPTENG PSBRKDSP PSBRRHND PSPUBDSP  (Dispatcher) PSPUBHND (Handler) PSSUBDSP PSSUBHDN What are these PeopleSoft processes […]

Read the full article →

Configuring PeopleSoft Process Scheduler

by Prashant January 25, 2013

Configuring PeopleSoft Process Scheduler Select  1.  to Create a Process Scheduler Server Enter the name of the Database Confirm the Configuration Enter the user id Enter a password for the User Id Enter the Server name Enter  4.  to Load the Configuration Enter 1.  Start the Process Scheduler Server Watch YouTube Video Share this ..

Read the full article →