Archive: Page 4

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
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.

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 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.

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.

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.

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 Named Best in KLAS
KLAS, a leading healthcare technology research firm, has named PeopleSoft as best Financials/ERP software in its “2011 Best in KLAS Awards: Software & Services” report. Read on to know more about this distinction.

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.