Filtering PeopleTools SQL from Performance Monitor Traces


I have been doing some on-line performance tuning on a PeopleSoft Financials system using PeopleSoft Performance Monitor (PPM).  End-users have collect verbose PPM traces. Usually, when I use PPM in a production system, all the components are fully cached by the normal activity of the user (except when the application server caches have recently been cleared).  However, when working in a user test environment it is common to find that the components are (more...)

Oracle Open World 2014 Presentations Download

Oracle has made the presentations used at Open World 2014 available for download this time too. Here are all the ones that are related to PeopleSoft.

PeopleSoft’s paths to the Cloud – Part II

In my previous blog post, I've covered some ways in which cloud computing features could be used with PeopleSoft, particularly around Infrastructure as a Service (IaaS) and non-Production environments. Now, I'm going to discuss how cloud technologies bring value to PeopleSoft Production environments.

Gain Flexibility



Some of the advantages of hosting PeopleSoft Production environments using an IaaS provider were also mentioned in the my past article as they are also valid (more...)

Peoplesoft HCM92 image #9

It has been released earlier this week, time to move to VMWare ESXi.
My workaround I described here is still working. To make it short, updating the ovf file as below:
1. ovf:capacity=(ovf:capacity*2)-64512 (I used diskMode=thin in the VM disks’ definition for the import)
2. <OperatingSystemSection ovf:id="101">
3. <Description>oracleLinux64Guest</Description>
       <vbox:OSType ovf:required="false">oracleLinux64Guest</vbox:OSType>
4. <vssd:VirtualSystemType>vmx-08</vssd:VirtualSystemType>

And the VM starts properly.

Enjoy,

Nicolas.

PeopleSoft’s paths to the Cloud – Part I


Nowadays, all paths seem to lead to cloud computing. In the business applications world, Oracle is pushing hard to position the Oracle Cloud Applications in an increasingly competitive market. The reasons that favor Software as a Service (SaaS) applications over their on premise counterparties are significant, even though there are still a good number of circumstances under which the latter should normally be the preferred option.

Our beloved PeopleSoft (yes, I like PeopleSoft, so what? (more...)

Cedar Wins Gold – PeopleSoft Partner of the Year

If you follow any number of those in the Partner community on LinkedIn you’ll have seen many of us asking that you vote for us in the UKOUG’s annual Partner of the Year competition. All of the partners are really grateful for your votes as winning an award selected by end-users carries significant prestige.

I’m delighted that the company which I now work for – Cedar Consulting – were awarded 1st place (Gold) for PeopleSoft Partner of (more...)

PeopleTools 8.54 Feature: Application Engine Trace File Enhancements

In this blog, we have been reviewing the new features of PeopleTools 8.54. Today is the turn of Application Engine, particularly on its troubleshooting. This release of PeopleTools include several enhancements on Application Engine tracing, which are outlined below:


  • The .AET trace file can now include the PeopleCode trace. This removes the need of checking the .AET file for the the non-PeopleCode steps and the .TRC file for the PeopleCode steps. Surely, .TRC files (more...)

Minimising Parse Time in Application Engine with ReUseStatement

This article explains how to determine the overhead of using literal values rather than bind variables in SQL submitted by PeopleSoft Application Engine programs. Using a combination of PeopleSoft Application Engine Batch Timings and Oracle Active Session History (ASH), it is possible to determine where it is most effective to change to alter this behaviour by setting the ReUse attribute.

ReUse Statement Flag

I originally wrote about the Performance Benefits of ReUseStatement in Application Engine (more...)

PeopleTools 8.54 Feature: ExcelToCI Errors and Warnings Worksheet

Some years ago, I wrote this post on ExcelToCI limitations. One of the limitations I've found annoying in the past was the need to move the mouse over each Warning or Error result cell. It was not just annoying, it actually didn't allow the users to easily work on the different error types and analyze useful information such as the most common error messages, how many rows would go through if they solved a particular (more...)

PeopleSoft’s PS_HOME evolution

One of the new features of PeopleTools 8.54 is the portability of the PS_HOME directory. Before going into the analysis of its benefits, let's have a look back to how  PS_HOME has evolved.

One Directory for Everything

PS_HOME is the name of the environment variable holding the PeopleSoft installation directory. Before PeopleTools 8.50, the full PeopleSoft installation was done on a single directory, including PeopleTools binaries, application external files, customized files, logs, etc. (more...)

2 Oracle Magazines You Need To Start Reading Right Now

Are you planning to start career in Oracle? or Are you a professional working in Oracle Technologies? Or May be you’re looking to sharpen your knowledge of Oracle or strengthen your skills on latest technologies, announcements  of Oracle, here’s a list of Oracle Magazines and links to digital editions to add to your reading regimen. [...]

PeopleTools 8.54 Features: Dynamic Alert Sliding Windows

One of my first memories in the PeopleSoft world was from by training bootcamp when I joined PeopleSoft. The instructor was showing us the Process Monitor functionality in PeopleSoft 7.5, where the button used to refresh the list of scheduled processes was represented by fetching dog named Sparky shown to the right of this paragraph.

It actually surprised me that an application button had a name, but that was the PeopleSoft style. Anyway, the (more...)

Integration Options with Oracle Fusion Cloud Service

Do you know Oracle Fusion Financials Cloud Service is built with Oracle’s Application Development Framework (ADF) and provides four primary methods of integration with other applications: ADF Services (commonly referred to as Web Services) ADF Desktop Integration File Based Data Import Reporting Tools ADF Services A web service provides a standardized way of integrating two [...]

Go Mobile with E-Business Suite [Smartphone Apps]

Oracle has recently released 14 mobile applications for Oracle E-Business Suite. In order to support real-time business decisions and collaboration , today's increasingly mobile workforce requires instant access to targeted enterprise data and functions-wherever and whenever they want. These mobile applications, including horizontal apps targeted for all employees as well as role-based line of business [...]

My global view on Oracle OpenWorld 2014

For those who can read Spanish, I just posted in our company blog an entry describing a general overview of Oracle OpenWorld announcements. A couple of weeks ago I made a post on this blog describing the most important outcomes from a PeopleSoft point of view. This new post gives a broader view. 

New Integration Network Utilities in PeopleTools 8.54

The new integration features available in PeopleTools 8.54 include better support for REST services and the new Integration Network WorkCenter. There are plenty of things to test and eventually use that may be of interest of anyone upgrading to this PeopleTools release. However, today I will focus on two simple but quite handy utilities:

Saving Gateway Metadata

There is a new functionality that saves the integrationgateway.properties configuration file in the database for future (more...)

The new %SelectDummyTable MetaSQL

Does anyone know a PeopleSoft developer who didn't ever use a SQL statement like the following one?

select %CurrentDateOut
from PS_INSTALLATION;

Where PS_INSTALLATION could be any single-row table in the PeopleSoft data model.

If you look at the previous statement, the SELECT clause is not retrieving any field from the PS_INSTALLATION table, but just using it to comply with ANSI SQL. The same statement could be written in Microsoft SQL Server like this:

select %CurrentDateOut;

(more...)

PeopleTools 8.54 will be the last release to certify Crystal Reports

It was just a question of time. In July 2011, Oracle announced that newly acquired PeopleSoft applications would not include a Crystal Reports license. Some years before, in October 2007, Business Objects was acquired by SAP. You don't need to read Machiavelli's Il Principe to understand why the license was now not included.

In order to keep customer's investment on custom reports safe, Oracle kept updating Crystal Reports certifications for those customers who purchased PeopleSoft (more...)

Using Global Temporary Tables in Application Engine

One of the new PeopleTools 8.54 features that went probably a bit unnoticed amidst the excitement on the new Fluid interface is the ability of Application Engine programs to take advantage of Global Temporary Tables (GTTs) when using an Oracle Database.

What are GTTs?

The Global Temporary Tables were introduced by Oracle already on the 8i version of its database product. These tables are session specific, meaning that the data inserted in them only (more...)

PS JOB

PS_JOB is probably the most popular and well known table in Peoplesoft HCM… The name explains by itself the content, job data component is in there.
If I would have a table on my own, I’d like to add line(s) with my name in it…
It just means that I’m always looking for a new contract. This is the intent of that blog entry. Sorry to the people who are seeking a technical subject, it’s (more...)