Scripts “All Things Oracle” article on Oracle Live SQL

I've put the scripts of my All Things Oracle article "About functions, records and result cache" on Oracle Live SQL.  This makes it easier to test the code used in the article.  

I used the employees table from the HR demo schema for my examples which is already available in Live SQL, so you don't have to create anything but the functions used in the scripts.

I've created 4 scripts: 

The Times They Are A-Changin’

Come gather 'round people
Wherever you roam
And admit that the waters
Around you have grown
And accept it that soon
You'll be drenched to the bone
If your time to you
Is worth savin'
Then you better start swimmin'
Or you'll sink like a stone
For the times they are a-changin'.

                     -- From Bob Dylan's "The Times They Are A-Changin'"

Spent some time with (more...)

Be Quick, But Don’t Hurry

Over the month since I've joined Oracle, many people has asked about the work I'm doing here.  And, in all honesty, the work is so varied that I've had a difficult time describing it.

Yesterday, I was traveling from my home in Salt Lake to Oracle Corporate HQ in Redwood Shores.  Having landed in San Francisco, I was in a rush to get my rental car, make the drive to HQ, and get (more...)

sqlplus core dumps with segmentation fault error in OEL 6.6 when you connect to DB

We have used OEL 6.6 image in our latest build.  When we cloned an EBS R12.2 instance that was on OEL 5.7 to this new server that has OEL 6.6, During the clone, was failing. On further checks, we discovered that sqlplus is crashing with segmentation fault error whenever we tried to connect to database:

sqlplus /nolog
conn apps/apps
Segmentation Fault

So, I suggested the DBAs to do strace (more...)

twm: unable to open fontset "-adobe-helvetica-bold-r-normal–*-120-*-*-*-*-*-*"

While launching twm, it gives this error and exits to unix prompt:

twm: unable to open fontset "-adobe-helvetica-bold-r-normal--*-120-*-*-*-*-*-*"

I found a solution on :

It was reported here for fedora: The workaround is to execute it with a specific shell variable:

$ export LANG
twm &

twm launches fine after this.

Oracle SSO Failure – Unable to process request Either the requested URL was not specified in terms of a fully-qualified host name or OHS single sign-on is incorrectly configured

Today, during a cutover when we were moving one of our ERP instance on Cisco UCS VMware VMs to Exalogic and Exadata, I got a call from Bimal.  The extranet iSupplier URL had been configured, but whenever any user logged in, they were seeing the following error instead of the iSupplier OAF Home page:

Oracle SSO Failure - Unable to process request Either the requested URL was not specified in terms of a fully-qualified host (more...)

JavaScript and PeopleCode Array Parameters

I have been experimenting with scripting PeopleCode using JavaScript. This is possible because Java includes Mozilla's Rhino JavaScript engine. I took one of my experiments to OpenWorld 2015 which shows creating a Microsoft Excel Spreadsheet using POI and JavaScript. Here we are, a couple of weeks later, and I see this in the PeopleSoft OTN Discussion Forum: Java Exception: java.lang.reflect.InvocationTargetException: during call of java.lang.reflect.Method .invoke. Perfect! That is (more...)

Western Canada Regional Users Group 2015

I will be in Calgary next week presenting PeopleTools topics at the Western Canada Regional Users Group meeting. My sessions are at 1 PM and 2:15 PM. See you there!

The SaaS Race

So I've been back at Oracle for about a month now.  I'd say the biggest change so far is my perspective on trends in SaaS and Cloud.  Prior to gaining that perspective from the inside, I really did not have a full appreciation for just how early in the game we are.  Not just Oracle, but everybody.

During my undergrad days, when remote learning was done with smoke signals (no Internet yet), (more...)

OpenWorld 2015 Presentations Available

OpenWorld 2015 presentations are now available in the content catalog. My PeopleTools Tips and Techniques session presentation is available here.


I've noticed a trend lately.  In working with various organizations in the early stages of evaluating SaaS, I'm hearing vigorous defense of limitations. "We can't go to the cloud because our business is so unique."  "We can't consider cloud because our data is too complex to migrate." "We can't entrust our data to a 3rd party."  While there are plenty of additional reasons, I'm sure you've noticed the two important words forming (more...)

Oracle Forms 12c arrived!

It's here!  The latest version for Oracle Forms is now 12c!
Download can be found here.

A few months ago I wrote a blog post of possible new features.
I'm looking forward to explore the new version the next few days to see what's in it.

OpenWorld Session Teaser

As a teaser to the session that Mark Thomas and myself are presenting on Selective Adoption at OpenWorld next week, here’s a slide showing why Selective Adoption is important for so many clients:

teaser slide

By virtue of such a high proportion of clients upgrading to 9.2 already, Selective Adoption is impacting a huge number of customers.

Come to Mark’s and my session at 9:30am on Thursday to find out the adjustments that you need to (more...)

How To Install Latest Verisign G5 Root Certificates

Dhananjay pinged me today and told me that for their Paypal integration, they had to upgrade to Verisign G5 root certificate.  This was the message from Paypal:

Global security threats are constantly changing, and the security of our merchants continues to be our highest priority. To guard against current and future threats, we are encouraging our merchants to make the following upgrades to their integrations:
  1. Update your integration to support certificates using the SHA-256 algorithm. (more...)

EBS 12.2.7 AD & TXK Delta 7 Features Review

With 12.2.7 AD & TXK Delta 7 - EBS Customers on 12.2 should be seeing improvements and stability. It is time now to review them. Watch this blog for the detailed review.

Some of the key features of Delta 7 are

  • Middle-Tier and Database Technology Code Checkers
  • Online Patching Progress Monitoring Tool
  • Online Patching System Validation 
  • Single Step Cloning
  • Local Inventory Support
  • Improved Middle tier Startup & Shutdown performance
  • Automated scripts to change system passwords
  • Patched tables de-fragmentation

I’m Wade ‘Smart Panda’ Coombs and this is how I work

Next up in our ‘How I Work‘ series is Wade ‘Smart Panda’ Coombs. Wade is one of the most prolific bloggers currently sharing their PeopleSoft knowledge. He writes at his website and has a lot of great content – particularly focusing on SSL certs, Change Assistant, server admin, SES and Weblogic). Wade also has a ‘Smart Thinking’ newsletter (this is the current issue, including a sign-up link).


Name: Wade (more...)

About Bugs

Been a few weeks since I last checked in.  Onboarding with Oracle has been like drinking from a data firehose, so I've been a bit pressed for time...

As I write this, I'm sitting out on my backyard patio right around sundown.  It's been unseasonable warm here in Utah of late, so the flying bugs are out in abundance.  While they're a bit irritating, they're not the type of bugs I have on my mind (more...)

Scaling FLUID pages for iPhone 6

We are currently developing FLUID pages for a customer on PeopleSoft HCM 9.1. As they cannot benefit from the standard functionality delivered through Update Manager until they upgrade to PeopleSoft HCM 9.2, they have decided to provisionally implement FLUID through customisations.

When doing this, we have identified an issue in iPhone 6 by which the FLUID pages were not correctly scaling:

As you see, the text is barely readable. After some research, we (more...)

Exadata Upgrade – Adding X5-2 Half Rack to X3-2 Existing Half Rack

Recently did an Exadata Expansion project on x3 half rack and making it a full rack by adding x5.
this setup is a full exadata rack with two different flavours of engineered system hardware four x3 compute nodes and four x5-2 compute nodes along with seven x3 cellnodes with seven x5 cell nodes.
This topology is supported but there were a lot of work behind.

  • First getting the x3 on the supported release 12c , this involved (more...)

sftp failure due to newline character difference between windows and unix.

Recently I spent almost a full day struggling to make out, why an sftp connection would not work without password, after setting up ssh equivalence.  The keys were correct, the permissions on the directories were correct.  The authorized_keys file looked ok.  I copied the authorized_keys file of another account that was working fine.  When I replaced the authorized_keys after taking backup of original authorized_keys, it started working.  So then I proceeded to check the contents (more...)