Archive: Page 5
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.
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.
SQLExec in PeopleCode – Syntax and Examples
SQLExec() can come in handy when you want to execute an SQL. Learn how to use SQLExec in PeopleCode with practical examples, syntax, parameters, and best practices.
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.
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.
Comma as Thousand Separator in File Layout?
When using a File Layout, there could be instances when you need to strip out certain unnecessary chracters from a field before loading data into PeopleSoft. This post explains how to do this in a simple way.
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 unpost seq… Read more