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

Bringing Clarity To The Avalanche – Part II, Sneak Peek

You had to be hiding under a rock (with no cell or internet service) to miss out on the fact that Oracle was trumpeting cloud messages throughout OpenWorld.  Far too much news for one person to track. So I'd like to approach discussing this in a very different way.

Today, I'm simply putting up a link to the best Oracle press release on recent cloud announcements.  The release touts the six new platform services for (more...)

Upgrading PeopleTools with Zero Downtime (3/3)

In the past post, we covered the approach we followed to have both PeopleTools versions running at once. In this post we will cover the issues we faced and how we got around.

Missing Tables

Our approach for identifying tables was not perfect. By examining the traces and logs, we missed some tables that were directly impacted by Application Designer (we did not enable tracing while copying the PeopleTools projects as it would have (more...)

Bringing Clarity To The Avalanche Part 1 – OOW14

Since the prior post here, I've had some people ask why I compared Oracle OpenWorld this year to an avalanche.  Well, to be honest, there are two reasons.  First, it was certainly an avalanche of news. You can check all the Oracle press releases related to the conference here (warning: it's pages and pages of information).  Second, I'm tired of using the analogy of sipping or drinking from a firehose...time to try something new.

(more...)

www.d12tech.com >>> New home for simplified and customized training in Oracle World

Hi All,
If you are looking for any training in Oracle world customized to your specific needs, kindly contact sales@d12tech.com or visit www.d12tech.com


Oracle Install, patch and Maintain
R12 Sysadmin
Customized Training for R12
ODI – Admin
Weblogic
RAC/ASM/DG
OEM 12c
Database 12c
OATS (Oracle Application testing suite)
Database 12c New Features (CDB/PDB)
Oracle Linux
Oracle E-Biz for Implementers
R12 12.2 Online Patching Demo

Upgrading PeopleTools with Zero Downtime (2/3)

Continuing with my previous blog entry, the requirement from our customer was to be able to move users back and forth between the old and new PeopleTools releases until the latter was stabilised.

This naturally required both PeopleTools versions to coexist. Now, as you know, you cannot just install the new PeopleTools release binaries and point them to the new release. Each PeopleTools release can only connect to a database for which the PSSTATUS.TOOLSREL (more...)

Jethro List: Data Mover Woes

Ok.  Maybe this is a rant, but Data Mover can sometimes get under my skin!  Some things you just expect to work, and when they don’t, it is very frustrating.

Here’s my problem.  I created this very, very simple data import:


set log C:tempaa_setup_import_FADEV.log;
set input C:tempaa_setup_export_AATST.dat;

replace_data RQ_GRP_SHR_SET;
delete PS_RQ_GRP_TBL where RQRMNT_USEAGE = 'ADV';
import RQ_GRP_TBL where RQRMNT_USEAGE = 'ADV';

It gave me this error:

Importing RQ_GRP_TBL
Error: Syntax error in where  (more...)

Clarity In The Avalanche

So I've spent the days since Oracle OpenWorld 14 decompressing...puttering in the garden, BBQing for family, running errands.  The idea was to give my mind time to process all the things I saw and heard at OOW this year.  Big year - it was like trying to take a sip from a firehose.  Developing any clarity around the avalanche of news has been tough.

If you average out all of Oracle's new product development, (more...)

Upgrading PeopleTools with Zero Downtime (1/3)

A few months ago, BNB concluded a PeopleTools upgrade with a quite curious approach. Our customer, a leading Spanish financial institution, had PeopleSoft CRM 8.4 installation running under PeopleTools 8.42. Their CRM application was being used to provide support to their 24x7 call centres, and the only reason they had to perform the PeopleTools upgrade was to be able to update their database and WebLogic releases, as the existing ones were already out (more...)

Error unzipping PeopleSoft Images

The new PUM images are a boon for anyone wanting to get a PeopleSoft instance up and running quickly. Once you’ve downloaded the zip archives however, you might find that the delivered zip file doesn’t work by default for everyone.

The line:

unzip HCM-920-UPD-008_OVA_2of11.zip

gives me the following error:

'unzip' is not recognized as an internal or external command

I’m not sure where the unzip utility is supposed to be from, but it’s not delivered (more...)

OOW14 Update: Oracle OpenWorld 2014 comes to an end

Today was the last day of Oracle OpenWorld 2014 at San Francisco. Even though it started a bit later due to yesterday's Appreciation Event which hosted Aerosmith, Spacehog and Macklemore & Ryan Lewis (which I did not attend, but that's a different story), the day was packed with good sessions. I have particularly appreciated the PeopleTools Meet the Experts session, which allowed me to network with Oracle PeopleTools experts and share points of view with (more...)

Gandhi – Father of the Nation The STRONGEST man I believe

First Fluid applications to be delivered for PeopleSoft HCM 9.2 on October 13th


During Oracle OpenWorld 2014 the announcement was made that the first functionalities taking advantage of the new Fluid interface capabilities provided in PeopleTools 8.54 would be made available together with the PeopleSoft HCM 9.2 Update Image 9.

Now, according to My Oracle Support, this image is going to be released on next October 13th. Although you need to have PeopleSoft HCM 9.2 and PeopleTools 8.54 to apply these enhancements to (more...)

Good UX – Don’t Leave Home Without It

There was a time when I asserted that User Experience would be a differentiator for Oracle in selling Fusion Applications.  Lots has changed since then, so I think it’s time to change my own thinking.  What’s changed?


  • Oracle has a cloud platform
  • Fusion Applications is now Cloud Application Services
  • We’re seeing well-designed user experiences throughout Oracle’s offerings: Simplified UI in moving into the Applications Unlimited products, and is also evident throughout Oracle’s cloud (more...)

Plea For Tight Messages – OOW14

It’s so easy to lose track of time at Oracle OpenWorld.  I think I’m writing this on Tuesday, but can’t say for sure…

Lots of information being shared here:  incremental development of Simplified UI, a myriad of new cloud services announced (including a very cool Integration Cloud Service), new features for MySQL, new mobile applications for the E-Business Suite, Eloqua services for Higher Education, a visualization-oriented UI for OBIEE (and saw a very cool (more...)