Recent Posts
Edit Criteria in Query

Optional Prompting in PS Query

If you don’t fill in a prompt when running a PS Query, the query usually returns no row. If you want the query to still fetch data (ignoring the condition), this post is for you.

XML / BI Publisher Tutorial

You Don’t Have to Write PeopleCode to Create an XML / BI Publisher Report using PS Query!

This post will help you create your first XML Publisher report using Query as a data source. If you are a business user or a functional consultant trying to learn this reporting tool, you have come to the right place.

xmlp-getting-started

Getting Ready to Generate XML / BI Publisher Reports

Looking to learn XML / BI Publisher? This is the first post in the XML / BI Publisher tutorial series and will help get the ground work done before you start using this powerful reporting tool.

oow-presentations

66 PeopleSoft Presentations from OOW 2013 – Ready for Download!

The presentations used at Oracle Open World 2013 has been generously made available for public, this time too, by Oracle. Here are all the ones that are related to PeopleSoft.

peoplesoft-version-control

6 Version Control Tools for PeopleSoft

Oracle doesn’t provide a version control feature for PeopleSoft. So here are some tools available in the market which can do version control and much more for PeopleSoft.

Insert into Longchars

Inserting into Record with Long Character Fields

Most of us here follow the good practice of executing our SQL statements directly against the database before using them within an SQLExec in PeopleCode, a view or an SQL actions in App Engines. Even after following this, we might get hit in some situations. Read on to find more.

locate-sections

Easily Locate Sections in Complex Application Engines

At times, Application Engines can get really big and searching for a Section within a complex App Engine can be a quite daunting. That said, PeopleSoft provides a feature to locate Sections within an App Engine with ease. Read on to figure out.

speedtype-thumb

Setting Up and Using SpeedType in PeopleSoft

Do you frequently enter similar kind of Journals in which the Chartfield combinations mostly remain the same? SpeedType can help you key in such transactions faster. This post explains how you can easily set up and start using this cool feature.

statistical-accounts-thumb

Statistical Accounts in PeopleSoft

There are numerous ways in PeopleSoft to allocate indirect costs to different departments, or operating units or any other Chartfields. This post will show you how to do this using Statistical Accounts.

PeopleBooks 9.2

PeopleBooks 9.2

With the new releases hitting the market, Oracle has yet again shown their commitment to PeopleSoft. PeopleSoft 9.2 would help enterprises lower the total cost of ownership while providing complete functionality that is intuitive and easy to use.