List of PeopleSoft SES Tables

by Apurva T. May 8, 2015

There are certain scenarios in which you’d like to have a list of PeopleSoft SES tables handy. Some of these scenarios include: PeopleSoft instance/database refresh – When copying a PeopleSoft instance or database, for example – production to test, you may want to exclude the SES tables so that SES server details and index definitions […]

Read the full article →

PeopleSoft Jobs and Schedule JobSet Definitions

by Apurva T. May 1, 2015

PeopleSoft Process Scheduler enables you to schedule one or more processes as a group. The terminology you use to identify such a group in PeopleSoft is known as a PeopleSoft Job or PSJob or just job in short. A PeopleSoft Process is defined as a single task, program, or routine, such as a COBOL program […]

Read the full article →

Learning PeopleSoft Application Engine

by Kelly April 20, 2015

PeopleSoft Application Engine is a PeopleTool designed to help you develop and process high volume, background data processing in batch or online mode. In PeopleSoft Application Engine, a program is a set of SQL statements, PeopleCode, and program control actions (that enable looping and conditional logic) defined in PeopleSoft Application Designer that performs a business process. […]

Read the full article →

NotFoundException (219,3101) PTFP_FEED.FeedFactory.OnExecute Name:getFeed PCPC:8132 Statement: 122 Called from PTSF_DP_SBO_WRK.PTSF_UNDEPLOY_BTN.FieldChange Statement 24 %1 with ID=”%2″ could not be found.

by Apurva T. April 1, 2015

This error usually comes after a database refresh has happened. Root cause of the error is that the application database and the SES database have gone out of sync. The error show up when you try to undeploy a SES index and when you try to do “Report Sync Issue,” nothing happens. The error reads […]

Read the full article →

Integration Synchronous Handler: No destination node can be determined for the request on node xxx (158,963)

by Apurva T. March 19, 2015

Depending on the action you’re performing, you would see a bunch of messages in between the following two lines of error messages: Integration Synchronous Handler: No destination node can be determined for the request on node xxx (158,963) After applying filters for sender specified routing, node transactions, relationship transactions and the PeopleCode event OnRouteSend, a […]

Read the full article →

How to Cleanup SES Statistics Data

by Apurva T. March 3, 2015

All the SES Query log data, which you see in various tabs of SES console, including General tab, Statistics tab is stored in the SES database. There are situations wherein you might need to clean this data for example, if you want to capture statistics of a query, which has performance issues and you want […]

Read the full article →

What are ChartFields in PeopleSoft?

by Apurva T. February 28, 2015

Before we discuss ChartFields in PeopleSoft, let us discuss two terms before that – Account and Chart of Accounts. What is an Account? An account is a separate record of each type of asset, liability, equity, revenue and expense.It shows the beginning balance, increase and/or decrease and ending balance for a specific time period. For […]

Read the full article →

CFO Tool provides details of new features in PeopleSoft Images

by Prashant February 12, 2015

CFO or Cumulative Feature Overview tool is used to identify product features available to you when upgrading to a new release. As we mentioned earlier that recently Oracle converted this tool from a excel based utility to a web based tool. Any user can go to the web based CFO tool and see the differences […]

Read the full article →

[INS-20802] Oracle Net Configuration Assistant failed.

by Apurva T. February 8, 2015

During the installation of SES, you may come across an error “[INS-20802] Oracle Net Configuration Assistant failed.” This error is due to conflict between a declared environment variable and a configuration value provided during the installation. The variable usually causing this is “ORACLE_HOME” You can get further details of this issue from the log file […]

Read the full article →

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 →

What is TMUSREVT.EXE?

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 →