Release 12.2.5 AR Enhacement : Apply Receipts Automatically based on Match Score and Knapsack Method

This is one of R12.2.5 Enhancement in EBS AR. The Automatic Cash Application improves accuracy and on-time application of cash receipts with the introduction of two new methods for automatically applying cash receipts. The first method generates match scores using the Levenshtein distance algorithm and automatically applies the receipt based on a score threshold. The […]

Oracle Data Relationship Management Analytics

The following Patch Set Updates have been released Recently for Oracle Data Relationship Management Patch 23236297 - PATCH SET UPDATE: ORACLE DATA RELATIONSHIP MANAGEMENT - Patch 23750023 - PATCH SET UPDATE: DATA RELATIONSHIP MANAGEMENT ANALYTICS - Oracle Data Relationship Management Analytics is a capstone dashboard and reporting application that draws upon the […]

Dynamic Java in PeopleCode

The PeopleCode language has a lot of features and functions. But sometimes, it seems there are tasks we need to accomplish that are just out of reach of the PeopleCode language. It is at these times that I reach for Java. I have written a lot about Java, so I'm sure many of you already know how to mix Java with PeopleCode. While certainly a rational solution, one of the pain points of a Java (more...)

Setting Environment Variables in Application Server/Process Scheduler Tuxedo Domains

The topic of how to manage environment variables was mentioned recently on the PeopleSoft Administrator Podcast
Recently I have built a pair of PeopleSoft environments for a proof-of-concept and have faced into exactly this problem.  I have two PS_APP_HOMEs (application homes) share the same PS_HOME (PeopleTools home).  The environment variables need to be correct before I open psadmin to administer the application server and process (more...)

Contribute Summer Of Technology

It doesn't seems to(it's raining alot in Belgium at the moment), but summer is coming!
And summer brings... technology!

And that's why Contribute Group presents: Summer Of Technology

Summer Of Technology is a series of free workshops in July and August.
Twenty(!) workshops about innovative development, design and management tools.

And of course, several workshops about Oracle technologies:

Creating a New Single-Node Oracle E-Business Suite Installation on Oracle Cloud

Before you read : Please note the documentation and procedures for Lifting and Shifting On-Premise to Oracle Cloud is constantly evolving. Instruction here are high level and recommend to review the latest documentation.

Link : Provisioning a New Single-Node Oracle E-Business Suite Installation in the Oracle Compute Cloud Service

This procedure could be the quickest way of getting an e-business suite 12.2.5 instance in IaaS public cloud.

To the compute account pull either (more...)

Oracle AppsUnlimited – Migrate from On-Premise to Oracle Cloud ( Lift and Shift )

Before you read : Please note the documentation and procedures for Lifting and Shifting On-Premise to Oracle Cloud is constantly evolving. Instruction here are high level and recommend to review the latest documentation.

Link : Migrating an Existing Oracle E-Business Suite Installation to the Oracle Compute Cloud Service

Migrate from On-Premise to Oracle Cloud ( Lift and Shift )

On-Premise Environment 12.1.3 or 12.2 can be moved to cloud , please review (more...)

Changing the page title in Fluid at run-time

One of our customers asked us to implement nested landing pages, in which some tiles would open a second landing page and eventually a third one and so on. Let me illustrate the use case with some screenshots (I apologise as they are in Spanish, but it should be useful anyway). This would be how the main landing page would look like:

By clicking the "Formación y Desarrollo" tile, a new landing page will be (more...)

HIUG Interact 2016 Agenda

In a couple of weeks, I will be presenting the following sessions at the HIUG Interact 2016 conference in San Antonio

  • 16165 : PeopleSoft Fluid User Interface – Deep Dive: Grand Oaks D, Mon, Jun 13, 2016 (03:15 PM - 04:15 PM)
  • 16164 : PeopleTools Tips & Techniques: Grand Oaks D, Tue, Jun 14, 2016 (02:30 PM - 03:30 PM)
  • 16163 : Tech Clinic: Application Designer Grand Oaks D, Wed, Jun 15, 2016 (12:30 PM (more...)

Oracle PL/SQL Developer Certified Professional

Today I passed my exam for Oracle PL/SQL Developer Certified Professional(OCP)... Hurray!

PeopleSoft on Oracle 12c

I was asked by Dan Iverson from about my experiences of PeopleSoft on Oracle 12c.  I have seen a number of PeopleSoft Financials systems on 12c recently.  Generally the experience is very positive, but one common feature is that they had all disabled Adaptive Query Optimization.

What is Adaptive Query Optimization?

Adaptive Query Optimization is a term for a set of new features in Oracle 12c to allow the optimizer to improve the (more...)

PS360: A utility to extract and present PeopleSoft Configuration and Performance Data


Lots of information about the configuration and operation of a PeopleSoft system is stored in the database.  Of course, most of the application itself is stored in the PeopleTools tables, for example, there are also performance metrics, particularly about batch processes.
PS360 is a new tool that I am working on that will use just SQL scripts to extract that data to flat files, and package them up in a zip file so that (more...)

nVision Performance Tuning: Coalescing Tree Leaves

I have blogged recently about the effectiveness of the Tree Performance options in improving the performance of nVision reports.
However, a consequence of the Tree Performance Access Method suppress join; use literal values is that the resulting SQL in nVision will have a criteria for every leaf on each of the selected nodes on that tree.
nVision Tree Performance Options|

There will be an equality condition for each single value leaf. I normally set Selector Options to Ranges of (more...)

Installing Update Images in Amazon Web Services

The last PeopleSoft Update Manager (PUM) images have been delivered in two formats: the traditional VirtualBox image and a newly introduced format: NativeOS.

NativeOS takes advantage of PeopleTools 8.55 Deployment Packages (DPK), which is the cornerstone for the PeopleSoft Cloud Architecture. This new cloud architecture facilitates the deployment of PeopleSoft applications in the cloud, not only covering Oracle Public Cloud but also other providers such as Amazon Web Services (AWS), Google Cloud and Microsoft (more...)

Invoking BI Publisher Web services from BPEL Process to run a report

BI Publisher exposes four public Web services which can be used to perform a variety of activities including running a report.

The screenshot below is of a simple SOA composite which calls the runReport() method on the ReportService Web service to run a report with parameters. While Oracle’s official documentation is sufficient enough to make this a trivial exercise but there are still a couple of points to remember which is why this blog post is here in (more...)

All Good Things Must Come To An End

All good things must come to an end
           - Geoffrey Chaucer,  "Troilus and Criseyde", circa 1385

Time has proven repeatedly that Chaucer was right.  And, for this blog, the time has come to wrap it up and call it done.

When I decided to rejoin Oracle, I was well-aware of the risk that I might have to dial back or close down my professional presence on social media.  Oracle (more...)

Collaborate 2016

I just wanted to post a quick note with my schedule for Collaborate 2016. I will be presenting PeopleSoft Developer Tips and Techniques on April 13th at 9:15 AM in Reef C. My publisher assured me that I will have a box of books waiting for me at the conference and we plan to give them away at various sessions during the conference. Here are a couple of other sessions I recommend attending at Collaborate:

Customer Service Thinking

My definition of good customer service is pretty simple:  deliver what you promise.  Period.  You can over-deliver and still make me happy.  But other than that, it's pretty simple.  Tell me what you promise you'll do.  If I sign up for the service, then delivery that service:  on-time, at the price you promised, and make it as easy for me as you promised.  That's it.

Earlier this week, I encountered back-to-back customer service failures with (more...)

PeopleSoft Administrator Podcast

I recently recorded an interview with Dan Iverson and Kyle Benson for the PeopleSoft Administrator Podcast. It is going to be spread over three episode. There is lots of other good stuff on the website and other episodes that are well worth listening to.

Tools vs Products

I have a garage full of neat tools.  Drill press, miter saw, band saw, table saw, power sander, Dremel, several Milwaukee power drills and portable hand saws, gauges, clamps, vise grips...yeah, the works. But I've learned something over the years; other than other people with a shared interest in nifty tools, nobody cares about the tools I have.  What they care about is the speed, quality and cost involved in making things with those (more...)