List/Grid

Archive: Page 4

Process in Posting state

Process Remains in Posting State?

Your process has a Distribution Status that says “Posting”, what would you do now? This post has some simple SQL statements that can do the trick.

PeopleSoft Audit Records

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 User Experience

PeopleTools 8.53 Release Value Proposition

It seems like Oracle is marching ahead with PeopleSoft! The Release Value Proposition for PeopleTools 8.53 is out and here are some of the features that you can expect!

Multiple SQLs in SQL Action

Using Multiple SQL Statements in an SQL Action

While writing App Engines, we normally write one SQL statement per SQL Action. But in certain situations, we may need to change this style. This post explains how to put in multiple SQL statements into a single SQL Action.

Excel to CI Error - Invalid XML Returned

Excel to CI Error – Invalid XML Returned

Is your Excel to CI utility throwing as error stating “Invalid XML Returned. The response text is not valid XML. Login Data cleared” ? Here is a simple solution to fix this issue.

File Layout Field Properties: Amout as Char

Comma as Decimal Separator in File Layout?

Your interface that uses File Layout and App Engine to load CSV files into PeopleSoft starts receiving Numbers that use comma as decimal separators. The interface will normally fail – here’s a simple technique to address this situation.

PeopleSoft Procure to Pay Tables

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.

PeopleCode Filename Split

Function – Separate Filename from File Path

Sometimes, you will need to separate out the filename from the filepath + filename string. This post provides a function that helps you do this easily.

Red Herring

Rimini Street in Red Herring Top 100

Rimini Street is in news agains, this time for finding a place for themselves in the coveted Red Herring Top 100 Companies list. Read on for more.

Expense Sheet Header

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!