Recent Posts

Concatenating Rows in SQL Server

Concatenating Rows in SQL Server

Have you ever felt the need to concatenate multiple entries against a particular field into a single row? We can do this sort of row concatenation right within SQL Server rather than bringing the output into Excel and then doing it. Here’s how!

Managing PeopleSoft with Application Management Suite

Managing PeopleSoft with Application Management Suite

PeopleSoft Enterprise Packages is used to manage your Business, is there any Software to manage PeopleSoft? The Answer is YES! Oracle has come up with a Managerial suite for PeopleSoft… Read more »

PeopleSoft Excel to CI

PeopleSoft Excel to CI

PeopleSoft Excel to CI is an Excel based utility delivered by PeopleSoft to import data from an Excel spreadsheet into PeopleSoft records. Since it uses a Component Interface (CI), all validations are done on the data being uploaded.

What is an Unpost Sequence?

What is an Unpost Sequence?

This field is present in many Voucher related tables, requisition tables, VAT, Project costing, receiving and journal related tables. One must be careful when making queries with these tables that… Read more »

Peoplesoft Workflow Tutorial

Peoplesoft Workflow Tutorial

For the pdf training content Click here : PeopleSoft Workflow PPT Many of the tasks that we perform in our day-to-day life cycle form a larger process or tasks. For… Read more »

PeopleSoft Grid PeopleCode

PeopleSoft Grid PeopleCode

In this article we explore how to populate a PeopleSoft dynamically using PeopleCode. Sample PeopleCode has also been provided.

ERP Scene of 90s

ERP Scene of 90s

The ERP space 20 years back was nothing similar to the ones that we have now. Head over to this article that captures the move from the Green screen days to the present day SaaS and Cloud.

PeopleSoft HRMS 9.1 Workforce Administration – Easy Way

PeopleSoft HRMS 9.1 Workforce Administration – Easy Way

How easily you can plan for your PeopleSoft HRMS implementation.

PeopleSoft Related Language Records

PeopleSoft Related Language Records

Related Language Records are special records that store language sensitive information in all required languages other than the base language of the system. This post explains how this is done.

Tracing PeopleSoft Application Engine

Tracing PeopleSoft Application Engine

Application Engines are PeopleSoft’s way to tie SQL and PeopleCode into a powerful processing engine which can run synchronously as well as in batch mode. App Engines are well structured and easy to debug. In this post will see how TRACE an App Engine program.