nVision Performance Tuning: Table of Contents

This post is an index for a series of blog posts that discuss how to get good performance from nVision as used in General Ledger reporting.  As the posts become available links will be updated in this post.
  • Introduction
  • nVision Performance Options
  • Indexing of Ledger, Budget and Summary Ledger Tables
  • Partitioning of Ledger, Budget and Summary Ledger Tables
  • Additional Oracle Instrumentation for nVision
  • Logging Selector Usage
  • Analysis of Tree Usage  with the Selector Log
  • Interval (more...)

Adding the PeopleTools Breadcrumbs Back

In these recent PUMs, one of the things that I miss is the breadcrumbs navigation at the top. It has many advantages over the new navigation. For example:

  • Taking a screenshot documents the navigation to the page
  • Navigation is quicker for nearby pages
  • Reloading the page is quicker by clicking the link in the navigation rather than reloading the whole browser page

I found the breadcrumbs are easy to turn back on. Simply, navigate to (more...)

Great Link: Testing in Production

The other day, I ran into this interesting article:

OpenSource.com: Testing in production: Yes, you can (and should)

This article was written about generic software development. I thought it would be a good exercise to apply it to PeopleSoft development in specific…

Point 1 and 2: You already do it

The PeopleSoft world varies from the author’s world. Everyone in PeopleSoft has multiple clones of their production system. Aside from maybe hardware differences, the (more...)

October Fluid Training

Last month I announced two new training courses: Fluid 1 and Fluid 2. We ran these courses at the end of September. For those of you that weren't able to attend the September session, we scheduled another series for October:

Both sessions run for 2 days from 9 AM Pacific until (more...)

Introducing Oracle’s intelligent Bots

Do you know ,Chatbots are the latest and hottest topic and the newest way to engage your customers , employee or partner through messaging apps. This is one of the most interesting sessions that I attended on the first day of Oracle OpenWorld 2017 and there this post will help to share more insights on […]

Larry’s Keynote – The World’s 1st Autonomous Database

Larry Elison came on stage last night to pumping rock music and laid out the details on Oracle’s latest big product unveilings – Oracle Autonomous Database and Highly Automated Cyber Security. Wearing a black polo shirt, faded blue jeans and a pair of ASICS running shoes he was relaxed and candid, obviously talking in an area that is comfortable for him.

Cyber Security

This session was mostly on the Autonomous Database, however Larry spent some (more...)

Imagine If You Will – The Oracle HCM Cloud Solution Library

Foreword:  When I was young, I tried like heck to develop a Rod Serling imitation.  I was a big fan of The Twilight Zone series, including the various revivals.  Alas, I was unable to get anywhere close and eventually gave it up.  But I admittedly still love the phrase "Imagine if you will".  So it's cool that I get to use it here.  See?  Work can be fun.

Imagine if you will the opportunity to (more...)

Interview with PeopleSoft Administrator Podcast: Oracle Resource Manager

This week's  PeopleSoft Administrator Podcast includes a few minutes of me talking to Dan and Kyle about Oracle Resource Manager.

(22 September 2017) #99 - Oracle Resource Manager

You can listen to the podcast on psadmin.io, or subscribe with your favourite podcast player, or in iTunes.

Some Numbers on SaaS

It's money that matters
You know that it's true
It's money that matters
Whatever you do
               --From "It's Money That Matters" by Randy Newman

So we've just gotten through earnings announcements for several SaaS companies, including my own employer (Oracle).  And as the numbers come out, I see lots of different voices interpreting those numbers inaccurately.  Because SaaS has an entirely different business model from that of (more...)

New Fluid Training Classes, Live and Virtual

On December 31, 2017, just a couple of months from now, Oracle will decommission the first set of Classic pages to be fully replaced by Fluid. Support document 1348959.1 contains a list of Classic pages, sorted by date, that are slated for retirement every year over the next few years. Customers interested in retaining a supported PeopleSoft implementation should familiarize themselves with this document and prepare to implement Fluid. This document contains important Manager (more...)

Diving Into Deep Links

I had another one of those eye-opening customer experiences recently.  I was engaged in a web conference with an Oracle customer discussing some UX extensibility features that come out of the box with HCM Cloud Applications.  During the conference, we got into a brief demonstration that included utilization of some deep links. Went over pretty well, people got excited, we had a rousing exchange on the benefits of deep linking and I was feeling pretty (more...)

Event Mapping: Fluid Landing Page "Dot" Buttons

The bottom of a Fluid landing page contains dots that identify how many landing pages the user can view as well as the position of the current landing page within the user's landing page collection. This piece of information is quite useful on a swipe-enabled mobile device, but somewhat meaningless on my mac. A few months ago I was helping a PeopleSoft customer with their Fluid implementation. This rather brilliant customer made those dots clickable (more...)

The Key To The Kingdom

I spend quite a bit of my time these days advising Oracle customers on implementing and using HCM Cloud Applications.  Makes sense, as that is the primary role of my group 😉  And I’m often asked about where I get my own information.  While I get some of it through hands-on experimenting and experience, I also have a treasure trove of online information.  And it’s all centralized.  And I’m going to share it…this is "the (more...)

Event Mapping: FieldChange

In my post Event Mapping: Extending "Personal Details" in HCM I noted that PeopleTools 8.56 FieldChange event mapping didn't work with fields from subpages. I opened a bug with MyOracle Support and Oracle sent me a fix to test. The fix works great! Now that I have FieldChange Event Mapping working for that prior scenario, I wanted to share how that Personal Details scenario would change. First, I would remove the JavaScriptEvents line. Specifically, (more...)

Unable to locally verify the issuer’s authority

Chuka pinged me when he got this error in Qualys logs after installation of qualys agent on a server

2017-07-24 15:23:08.497 [qualys-cloud-agent][232147]:[Information]:Finished curl request
2017-07-24 15:23:08.497 [qualys-cloud-agent][232147]:[Error]:Http request failed:Peer certificate cannot be authenticated with given CA certificates: SSL certificate problem: unable to get local issuer certificate
2017-07-24 15:23:08.497 [qualys-cloud-agent][232147]:[Error]:Http request failed: error code: 0
2017-07-24 15:23:08.497 [qualys-cloud-agent][232147]:[Error]:CAPI request failed:
2017-07-24 (more...)

Event Mapping: Extending "Personal Details" in HCM

As you would expect, PeopleSoft's HCM self-service functionality allows employees to self-report many industry-generic, best-practice attributes. But none of us are industry-generic, which means we may have to capture more attributes than Oracle intended. The way I've seen many organizations handle this is to customize the delivered Personal Details pages to collect additional attributes. Although having an upgrade impact, customizing the classic versions of these pages makes a lot of sense. With continuous delivery, however, (more...)

acroread on Linux 6

As per https://access.redhat.com/errata/RHSA-2013:1402 : Adobe Reader (acroread) allows users to view and print documents in Portable Document Format (PDF). Adobe Reader 9 reached the end of its support cycle on June 26, 2013, and will not receive any more security updates. Future versions of Adobe Acrobat Reader will not be available with Red Hat Enterprise Linux.

Some of our ERPs still use acroread for pasta printing.  When we did the upgrade of OS (more...)

OpenCOBOL Try 2

Cobol has been a thorn in my side for a long time. Working for software vendors, it’s not a given that Cobol is installed because they don’t always need to run payroll and don’t have production instances.

It’s been a while since I have played with OpenCOBOL. It’s been so long that they have renamed it to GnuCobol instead.

I’ve gotten closer so far, but I still can’t get past the database connection. Here’s my (more...)

Checking Out Chatbots

I recently spent a day with the Oracle Applications UX team in a Conversational UI for Enterprise SaaS workshop.  Let’s be clear…in the context of this workshop, “Conversational UI” is a spiffy term meaning chatbots for enterprise applications.  Amazing workshop put on by the UX team.  Made even better by including a mix of attendees ranging from neophytes like me up to experienced experts sharing their tips and tricks.

I learned quite a bit about (more...)

PeopleSoft and Adaptive Query Optimization in Oracle 12c

Adaptive Query Optimization is a significant feature in Oracle 12c. Oracle has made lots of information available on the subject.(See https://blogs.oracle.com/optimizer/oracle-database-12c-is-here).
Adaptive Query Optimization is a set of capabilities that enable the optimizer to make run-time adjustments to execution plans and discover additional information that can lead to better statistics…There are two distinct aspects in Adaptive Query Optimization: adaptive plans, which focuses on improving the execution of a query and adaptive (more...)