Report Sync Issues in SES

by Apurva T. February 2, 2015

When you uninstall and reinstall a SES instance or you refresh a PeopleSoft instance, you can end up getting several trivial issues. Most of these issues revolve around the fact that the PeopleSoft database and the SES database have gone out of sync. The obvious way to resolve these error is to do “Report Sync […]

Read the full article →

Java Out of memory Error when Crawling SES Index

by Apurva T. January 22, 2015

When you schedule a search definition, it might run forever, especially in case of a large index like HC_HR_JOB_DATA or HC_BEN_HEALTH_BENEFIT or  HC_HPY_CREATE_ADDL_PAY. If you go to the crawler log located in 1ds*.MMDDHHMM.log in <SES>/oradata/ses/log – you might notice an “out of memory” error like the one mentioned below: Crawl Fails and Logs Error “java.lang.OutOfMemoryError: […]

Read the full article →

EQA-13000: Operation “delete” Cannot Be Performed on an Object Type “schedule” in State “EXECUTING”. ( 262,1018)

by Apurva T. January 21, 2015

When you face this issue with indexes in SES when you try to undeploy them or do report sync issues – you will receive an error and there are multiple versions of this error, namely: EQA-13000: Operation “delete” Cannot Be Performed on an Object Type “schedule” in State “EXECUTING”. ( 262,1018) EQA-13000: Operation “delete” cannot […]

Read the full article →


by Prashant January 20, 2015

TMUSREVT.EXE is known as Tuxedo Event Broker and is a new process added in PeopleTools 8.54. It’s used for Push Notification feature in PT 8.54. To receive push notifications on a PeopleSoft system, you have to enable push notifications for the server domains where the events are being published. Events are published from application server […]

Read the full article →

What is a Drilling URL?

by Apurva T. January 19, 2015

A Drilling URL is a term associated with PeopleSoft Search Framework. A Drilling URL is a URL found in the search results when using PeopleSoft Search Framework. When clicked, it displays the appropriate PeopleSoft application page, with appropriate data populated in the page. Let us have a look using an example: When you perform a […]

Read the full article →

Access Denied Error while applying PRP patches to PeopleSoft Image

by Prashant January 13, 2015

PRP stands for PeopleSoft Release Patchset. With PUM(PeopleSoft Update Manager) process Oracle releases PeopleSoft Images every couple of months that includes latest patches available for PeopleSoft 9.2 application. In between release of two images, if Oracle identifies few critical patches that need to be applied then those patches are delivered as PRP patches. PRP patches can […]

Read the full article →

Cheatsheet – PeopleSoft HCM 9.2 Common Navigation Paths

by Prashant January 12, 2015

Navigation in PeopleSoft can sometimes be challenging, especially when you start working in a new application. Sometimes with a new release Oracle PeopleSoft makes some subtle changes like changing “Setup HRMS” to “Setup HCM.” For your quick reference, our team has created a cheatsheet or quick reference guide on common navigation paths in PeopleSoft HCM […]

Read the full article →

Datetime field format error

by Apurva T. January 3, 2015

This is a quick short post for resolution of the datestamp error while running a PS Query. Datestamp errors are quite common when running a PS Query. When you run a PS Query and are prompted to enter the datetime value – many a times you will end up entering a wrong format and you […]

Read the full article →

TaskKill Command in Windows

by Apurva T. January 2, 2015

Taskkill ends one or more tasks or processes. You will need taskkill command to troubleshoot issues related to your appserver, webserver domains or database if using Windows Servers as the OS platforms to host your appservers, webservers or database. An example of a real-life issue could be that the appserver domain may give error during the […]

Read the full article →

Tasklist Command in Windows

by Apurva T. January 1, 2015

Tasklist command in Windows displays a list of applications and services with their Process ID (PID) for all tasks running on either a local or a remote computer. You will need tasklist command to troubleshoot issues related to your appserver, webserver domains or database if using Windows Servers as the OS platforms to host your appservers, […]

Read the full article →

Unable to Find a Routing Corresponding to the Incoming Request Message (158,505)

by Apurva T. December 19, 2014

PeopleSoft Integration Broker has several settings, which you need to remember. Many a times when an issue remains unresolved for long, I end up thinking – this is such a trivial issue and still I’m unable to resolve it. What did I do the last time? I wrote a post on one such issue some […]

Read the full article →

How To Change Colors in Oracle Virtual Box Terminal

by Prashant December 17, 2014

If I tell you that I was really unhappy with the coloring scheme of Oracle Virtual Box terminal then I am sure, I won’t be the only one. PeopleSoft Images are delivered with Oracle Linux OS which needs to be deployed on Oracle Virtual Box. If you happen to login as root on the VM […]

Read the full article →

How To Download PeopleTools 8.54 from Certifications Tab on Oracle Support

by Prashant December 11, 2014

Most of you would already know that PeopleTools 8.54 can be downloaded from Oracle’s edelivery site i.e. But do you know that you can also download PeopleTools 8.54 setup files from certifications tab on Oracle support. Go to Certifications tab and then search for certifications for PeopleTools 8.54 as shown below. From the certification […]

Read the full article →

Uninstalling Change Assistant 8.54 using CA setup for 8.53

by Prashant November 24, 2014

You might know that on one machine, you can have only one version of PeopleSoft Change Assistant installed at a time. If you try to install another version of CA, it would first uninstall the existing version and then allow you to install newer CA version. If you use Change Assistant setup for PeopleTools 8.53.x […]

Read the full article →

Export SQL Results To Excel Using SQLPLUS

by Prashant November 4, 2014

Here is quick tip on how to easily export SQL results into an excel file. Step 1: Login into database using SQL PLUS Step 2: Set markup using below command SET MARKUP HTML ON Step 3: Spool the output to a file. SPOOL C:\TEMP\MYOUTPUT.XLS Step 4: Run your SQL Query SQL QUERY Step 5: Set […]

Read the full article →

PubConProccessor TransformSend Failed on service operation publication

by Apurva T. November 4, 2014

A common error especially in PeopleTools 8.53 onwards is “PubConProccessor TransformSend Failed on service operation publication.” The issue happens for service operations, which involve transformation programs like PERSON_BASIC_SYNC, WORKFORCE_SYNC etc. The problem is commonly caused by either a a corrupted routing definition or sometimes by a PeopleTools bug when the routing definition contains 30 char […]

Read the full article →

PeopleSoft Master Notes for Common Issues

by Prashant September 19, 2014

PeopleSoft is such a huge application with so many interconnected pieces that PeopleSoft consultants always find themselves fixing issues related to one or the other tool in PeopleSoft. Most of us usually head over to Oracle support and then start searching for the issues. Sometimes it may take lot of time to find the exact […]

Read the full article →

How to Uninstall Oracle SES for PeopleSoft

by Apurva T. September 11, 2014

There are a lot of valid reasons when you may need to uninstall SES. Some of the common examples include situations when there are issues with the first time install of Oracle SES and also there may be cases when applying patches or doing upgrades would have deemed SES unusable. In many of such and […]

Read the full article →