nVision Performance Tuning: 2. Effects of Performance Options

This blog post is part of a series that discusses how to get optimal performance from PeopleSoft nVision reporting as used in General Ledger.

In this post, I examine the effect of different settings for the tree performance options on how the SQL is generated.  It is common, to see different performance options in use on different trees in the same SQL query.  It is important to be able to look at a piece of (more...)

nVision Performance Tuning: 1. nVision Performance Options

This blog post is part of a series that discusses how to get optimal performance from PeopleSoft nVision reporting as used in General Ledger.

At no point when defining a nVision report does the developer directly specify a SQL statement, all the SQL is generated by nVision from the report definition.  That also means that it is not possible to directly intervene and change the SQL statement, for example, to add an optimizer hint.

However, the way (more...)

Study: ASC 606 Might Slow IPOs in 2018 ??

A new study by Deloitte reveals that initial public offerings (IPOs) may suffer as a result of New Accounting Standard (ASC606) Here are excerpts from an article by Terry Sheridan in accountingWEB.com Here’s a snapshot of the survey’s findings: 60 percent of the respondents said they have not begun implementation of the standard or have […]

Vertex and Oracle Cloud

Oracle ERP Cloud Transaction Tax Automation is consist of Comprehensive Tax Partner Offerings Robust infrastructure for tax partner solutions Tax Content and Tax Reporting services providing fast ROI option for mid-market companies adopting Oracle ERP Cloud Integrated Cloud-to-Cloud tax calculation services for enterprise grade companies Infrastructure has been optimized for ERP Cloud customers using end-to-end […]

Identifying Conditional Navigation Content References

As PeopleSoft customers upgrade to Fluid-enabled applications, it is quite common to start with Fluid disabled, and then implement Fluid behavior post go-live. It is all about change management and an organization's ability to digest change. Even though Oracle has set retirement dates for certain Classic components, with the first wave retiring December 31, 2017, all Classic functionality is still supposed to be present and available. But if you have opened a recent PeopleSoft image (more...)

nVision Performance Tuning: Introduction

This blog post is the first in a series that discusses how to get good performance from nVision as used in General Ledger reporting.

PS/nVision is a PeopleTools technology that extracts data from the database and places it in an Excel spreadsheet (see PS/nVision Overview).  Although PS/nVision can be used with any PeopleSoft product, it is most commonly used in Financials General Ledger.

The SQL queries generated by nVision are, at least conceptually, similar (more...)

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

EBS : Milestone Billing

Milestone is a type of billing that occurs only as certain milestones have been attained. Milestones are events or conditions that trigger the billing. For example, you can bill customers based on the number of days since the activity began, a specific date, a manual milestone you specify, or an activity percentage of completion. You […]

Excellent reference for understanding technical terms related todays IT….

Here is the Ultimate Fin Tech Glossary got a fwd email (source internet).

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