I’m going to Oracle OpenWorld again this year, and I just finished building my schedule.  Wow.  This year there are so many sessions I want to attend in the same time slots that I won’t be able to see a fraction of what I want to.  Guess I’ll have to skip the session on how to author blue-ray disks using Java in favor of a product roadmap session I need to attend.  You see, I’ve started a new project and I have a whole laundry list of stuff I need to come up to speed on.  I’m sure it’ll be an informative but exhausting week – it always is.

OpenWorld is almost here! In less than 3 weeks, we will all be together again for the biggest Oracle apps and technology reunion of the year... and possibly, the biggest ever, with JavaOne and Oracle Develop co-located with OpenWorld.This year I am teaming up with my good friend Graham Smith to deliver the "best of" PeopleTools Tips for 2010. Expect to see more PeopleTools 8.50 content in our

I put a post up a short while back on the RVP for PeopleTools 8.51, but this week an Advisor Session has been released where Jeff Robbins gives a little more info (although sadly no screen-shots). Much of what is covered is similar to the RVP, with a few extras (or maybe I just didn’t [...]

Workflow Manager default properties can be modified to improve the overall performance and few of them are listed below.    This properties can impact the ETL runtime directly and needs to configured based on :
i) Source Database
ii)  Target Database
iii) Data Volume

Category
Technique

 Session Properties
While loading Staging Tables for FULL LOADS,  Truncate target table option should be checked. Based [...]

PeopleTools 8.51 will be the next release of PeopleTools available.


In advance of all the exciting news to be announced at Oracle Open World this year, Jeff Robbins gave an overview session this week which is being made available as a streaming video.

Check out the video here:

https://oracleaw.webex.com/oracleaw/ldr.php?AT=pb&SP=MC&rID=57986397&rKey=8437b9e766fd40d7



Watch for much more information here on Oracle Open Wor

Many of the Business Intelligence systems that are being built by an organization are to be used by global users; these systems initially address a subset of the users and then gradually are extended for the global users.
 Following are the critical things that are to be considered to ensure a successful global rollout of a [...]

Servers are becoming more powerful as manufacturers are finding new ways to get more cores into a CPU.  Today it’s not uncommon to see hexa and octa-core processors shipping at the same price points the dual- and hexa-cores shipped yesterday.  Where manufacturers once got their performance improvements through raw CPU speed, they are now getting their getting the majority of performance improvement through more cores in their processor chips.

One of the projects that we have hosted on Code.GreySparling is a very cool way to work with PeopleSoft Component Interfaces. If you do any sort of testing or data loading or Component Interface development with PeopleSoft applications, then this is for you.

Dave Kurtz has a nice writeup over at OakTable.net on using App Engine meta-sql to add hints to dynamically generated SQL.

The Kindle edition of my PeopleTools Tips and Techniques book is now available. Download a copy from Amazon's site here.

This post is about the Data Conversion utilities given by Oracle for upgrades to PeopleSoft 9.1.
 
Data Conversion is a key process in a PeopleSoft upgrade where data from old table or columns get converted to new table or columns. Oracle delivers the conversion programs in the form of Application Engine and these are designed to [...]

The following are generally accepted “Best Practices” for Informatica PowerCenter ETL development and if implemented, can significantly improve the overall performance.

Category
Technique
 
Benefits

 
 
 
 

Source Extracts
Loading data from Fixed-width files take less time than delimited, since delimited files require extra parsing.  Incase of Fixed width files, Integration service know the Start and End position of each columns upfront and thus reduces [...]

I came across a good article on installing and using XML Publisher: Creating PeopleSoft Reports Using XML Publisher

Remember the old days (circa 2006) when doing disaster recovery involved shipping tapes to an off-site storage facility and provisioning emergency hardware at a disaster recovery facility?  Well, fast forward to 2010 when virtually unlimited hardware and disk storage are cheap and plentiful.  Making real-time backups to the cloud (with the right software) is not only doable but almost a no-brainer.  But once your backup is in the cloud, the next logical step would be to launch a virtual instance of the server that you backed up.  But that’s like, Star Trek futuristic stuff, right?

Change data capture (CDC) is an approach or a technique to identify changes, only changes, in the source. I have seen applications that are built without CDC and later mandate to implement CDC at a higher cost. Building an ETL application without CDC is a costly miss and usually a backtracking step. In this article [...]

Introduction
 Couple of weeks ago, I attended an Oracle Webcast titled “Introducing Oracle Identity Management 11g”. That webcast was about introducing the remaining components of Oracle Identity Management Product Suite which is part of the Oracle Fusion Middleware 11g (we can call it as a second set of product release!).

During the first phase release of Oracle [...]

All, Here are 3 interesting posts I’ve come across over the last week. 1) The guys at PeopleSoft Wiki have found a method for having multiple PeopleSoft sessions open in the browser at the same time. http://www.peoplesoftwiki.com/multiple-sessions-with-ie8 2) Also from PeopleSoft Wiki there’s a method of quickly changing the header links to something a little [...]

PeopleSoft Integration Performance and Tuning for PeopleTools 8.50 White Paper

The

White Paper (login required)
provides guidance for performance and tuning of the Integration Broker framework.

Few weeks ago a new Peoplesoft OVM template has been released, Portal Solution 9.1, announced here.
After HCM9.1, this is the second one, time to test it as well.

Important note for those who work on Linux 32bit, the patchset 10.2.0.5 has been recut and few fixes has been added to the original package dated from 30-APR-2010.
Do not forget to download it again to be sure to work on the latest version.
Read the note 1156958.1 for more information, this is only for 32bit version of Linux.

Nicolas.

If you want to secure and close down your database to all the non-authorized people, especially not seeing the data inside the database, what’s better than Database Vault ? Nothing.

I found some additional PeopleTools system tables that I am adding to my reference. The PSPNLCNTRLDATA table stores additional settings for each field on the page.  For example, it holds the new fields PTGRDLAYOUT and GRIDROWS in PeopleTools 8.50 relating to scrollable grids. The PSPNLFIELDEXT table also stores additional settings for the fields on the [...]

This post is to address a question posed in one of the comments on another post.  The answer is a little too in-depth for a comment reply.  Also, I had been wanting to blog more about arrays anyway. Here is the question: Hi i have seen your comment on Arrays. i need your guidence on [...]

Learn how Oracles end-to-end document imaging system extends the value and increases the automation of your Oracle Financials applications by using intelligent capture and imaging technologies to streamline high volume operations like accounts payable. Oracle Imaging and Process Management 11g (Oracle I/PM 11g) offers an integrated system that digitizes paper invoices, intelligently extracts header information and line item details, initiates automated workflows, and enables in-context access to imaged invoices directly from Oracle Applications, including Oracle E-Business Suite Financials and PeopleSoft Enterprise Financial Management. Come hear more about these certfied, standards-based application integrations as well as how document imaging can help your organization achieve quick, measurable ROI, by increasing efficiencies across financial departments, and reducing costs related to paper storage and handling.

This is a how-to post that I intend to refer back to from time to time.  The goal is to create a simple Application Engine program into which we can drop some PeopleCode and see how it works.  Assuming we don’t need any of the online pieces, this is much easier than going through all [...]

There has been some confusion about maintenance and single sign-on between the PeopleSoft Portal and PeopleSoft applications. Here is the general guideline one should follow:

Let me reiterate – Big Data is the ‘New Normal’ in Business Intelligence. Now, What is this Big Data?
Before that let me take a dig at this fashionable phrase called the ‘New Normal’ – Mr Mohammed El-Erian, CIO of Pimco, first introduced the phrase New Normal and it has since been used by many people [...]

The code for my new book PeopleSoft PeopleTools Tips & Techniques is now available. There is a download link on the book's McGraw Hill page. Look for the Downloads section. Enjoy!

Continuing our delivery of Oracle VM Templates for PeopleSoft we have a new addition to the Oracle VM Templates site, the availability of PeopleSoft Enterprise Portal 9.1 and PeopleTools 8.50 virtual machines. PeopleSoft Enterprise Portal is referred to as "Portal Solutions (PS)" here.

In advance of the Oracle VM page being updated on OTN, here are the important details:

This fully functional PeopleSoft OVM environment is deployed as two VMs. These VMs are built from two separate templates :

Sigh... I really didn't want to enable comment moderation. When I post to a blog with comment moderation, I always wonder if my comment will appear. I also like to see my comments appear immediately. What if the moderator is on vacation? Unfortunately, I find myself in a position where I HAVE to enable comment moderation. Some organization has been posting pornographic links as comments on my