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.
PeopleSoft Journal Import Error – User-defined type not defined
The Journal Import Spreadsheet is a handy tool that helps you import large number of Journals easily. This post can help you with an uncommon error, User-defined type not defined, that you may encounter while using this utility.
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.
Record Level Audit vs Field Level Audit
When you realize that you need to employ auditing in a certain situation, you have got to decide between Record level audit and field level audit. This post aims to help you choose the right one.
Field level Auditing
Field level auditing captures changes in one or more fields which are then stored in PSAUDIT record. This tutorial will show you how to set up auditing on a Field.
7 Steps to Setup A Record Level Audit in PeopleSoft
As PeopleSoft maintains critical enterprise data, having an audit trail on the data is of paramount importance. This post will help you setup Record Level Auditing in 7 simple steps.
PeopleSoft Procure to Pay Tables
PeopleSoft Procure to Pay links Purchasing and Payables modules to provide control and visibility over the entire life-cycle of a transaction. The main application tables used in the Procure to Pay cycle are listed here.
Concatenating Rows in SQL Server
Have you ever felt the need to concatenate multiple rows 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!
PeopleSoft 9.2 Planned for late 2012
Oracle reassures PeopleSoft customers on future investments by declaring the release of the new PeopleSoft 9.2 version, which would be generally available late this year. The company also assured that investments in Fusion would not shunt the growth of PeopleSoft.
Managing PeopleSoft with Application Management Suite
Oracle’s Application Management Suite helps you manage PeopleSoft at your enterprise. This post outlines what’s possible with this management suite.
