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.

Limitations

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

Wade

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

Oracle Compound trigger sections

Oracle Compound triggers can be handy when you need to share common data in various timing points, e.g. solving a mutating table problem.  You can find an example on the Oracle base website.

For those that are using compound triggers, before 12c the order of the sections were restricted:

PeopleSoft Streams from Oracle University

In February of this year, Oracle University launched the PeopleSoft Learning Stream. Oracle's Learning Streams are short, educational vignettes. I was given the privilege of recording 6 streams:

  • Using JavaScript with Pagelet Wizard is a 21 minute video showing you how to use Pagelet Wizard to convert a PeopleSoft query into an interactive D3 chart, a navigation collection into a carousel, a navigation collection into an accordion, and RequireJS for JavaScript dependency management.
  • REST Query (more...)

Why go to Oracle OpenWorld?

We’re a shade under a month away from the biggest event in the calendar for those that work in the Oracle marketplace – the Oracle OpenWorld Conference.

It runs every year in San Francisco and draws a massive 60,000 attendees from 145 countries (plus 2.1 million online attendees). That’s huge.

There are more than 2,500 sessions from ~3,600 speakers, approximately half of which are customers/partners and half are Oracle themselves. As well as the sessions there are (more...)

Oracle Database Developer Choice Awards

I have learned a lot from other people in the Oracle Community over the years and I bet a lot of you have too.
Now it's time to give them some recognition by the means of an award.

Until 15 October you can cast your vote.

These are the categories:

Cedar’s Selective Adoption Event recap

A week or so back Cedar held a free Selective Adoption event for clients and friends. The idea behind the event was to help those on 9.2 already to make the most of what Selective Adoption can offer, and to show those that are yet to make the step to 9.2 what the future could look like.

The event went really well. Jeff Robbins opened the proceedings, giving an overview of the technology and what (more...)

JavaScript on the App Server: Scripting PeopleCode

It has been nearly a decade since I started playing with JavaScript on the PeopleSoft application server. Back then I had to deploy a couple of JAR files to the app server. At that time, maintaining and deploying unmanaged files seemed more headache than benefit. Today Java provides full scripting support through the ScriptEngineManager and embedded Mozilla Rhino JavaScript script engine. Why would I want to script PeopleCode? Here are a few of my favorite (more...)