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

Introduction

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

Oracle AppsUnlimited – Building your Own Machine on IaaS with EBS

Oracle Public Cloud gives multiple options to create a base image. There are options available from the market place which I will cover later. Here I will cover building your own machine image on IaaS with your own EBS Installation. If you are a customer running 12.1.3 this should interest you. This procedure can be used to build multiple development single node EBS images of your choice.

I will make the document generic (more...)

Oracle AppsUnlimited – Building your Own Machine on IaaS

To enable Oracle EBS on cloud and to install a fresh EBS Instance of your own choice then you will have to create a image. This image can be build using Oracle Linux (x86, 64-bit) releases 6.4 and 6.6 with kernel 2.6.36 or later.

High Level Steps

  • Source the ISO from E-Delivery
  • Using Oracle Virtual Box create the VM
  • Install Oracle Linux in the VM
  • Add/Enable Sudo to OPC user and (more...)

Oracle AppsUnlimited – Oracle E-Business Suite Meets Oracle Cloud




Oracle Cloud Infrastructure as a Service (IaaS) is now powered to run Oracle E-Business Suite. Does that interest you ? I am exited to be part of the apps unlimited team and let me share what I have explored. 

Apps Unlimited offers two ways  of running EBS , start fresh or migrate. Depending on customer choice and business requirement either of the options can be chosen. Some of benefits of running EBS on Cloud are quick (more...)

Presenting in Collaborate 2016

I am presenting in OAUG Collaborate 2016 about our experiences with running E-Business Suite on Engineered Systems - Exadata, Exalogic, ZFS and PCA.  Session Details:

https://collaborate.zerista.com/event/member/223628

Please attend, if you are coming to OAUG Collaborate.

PeopleSoft on the Oracle Cloud – what does it mean?

There have been a few announcements over the last couple of weeks about the Oracle Public Cloud. But what does it actually mean for the PeopleSoft community?

What is Oracle Public Cloud?PeopleSoft in the Oracle Cloud

The Oracle Public Cloud is Oracle’s competitor to the Infrastructure as a Service (IaaS) providers that have swiftly risen to create a whole industry that didn’t exist 10 years ago. Because they’re the market leader (by far) everyone automatically thinks of Amazon, however (more...)

I’m Sasank Vemana and this is how I work

The next profile in our ‘How I Work‘ series is Sasank Vemana. Sasank burst onto the PeopleSoft blogging scene in 2014 with his Sasank’s PeopleSoft Log site, and has been adding entries at a ferocious pace since. He is probably best known for his series of posts on altering the PeopleSoft branding to make it match a corporate palette, as well as configuration and code changes related to UI/UX.

I met Sasank at (more...)

Using Generic Templates to Send Emails

Weblogic and Oracle HTTP Server install with /tmp

Lately I have had to install Weblogic 12.1 and OHS 12.1 on a Linux server in silent mode.
Somehow, there was very small space left on the default temporary filesystem /tmp.
I was having to find a way to install within the non-default /tmp.

Not so simple to find the option in the command line, that's why this article as a note for myself, maybe it also can help others.

Weblogic 12.1. (more...)

nVision Performance Tuning: General Principles

Over the years I have dealt with performance problems with nVision reporting on General Ledger on various Financials systems in various kinds of businesses.  Different businesses use nVision very differently, and have different challenges, but I have produced an approach that mostly works well at most customers.  I have collected that advice in to a document that I have recently published on my website (http://www.go-faster.co.uk/docs.htm#nVision Tuning.Generic.pdf (more...)

Alliance 2016

HEUG Alliance is next week. I hope you are registered. I know this will be a fun and informative conference (as always). I am scheduled for two sessions at Alliance:

  • PeopleSoft Developer: Tips and Techniques on Monday at 3:30 PM in room 6B/C and
  • PeopleSoft Meet the Experts on Tuesday at 10:15 AM in room 307/308 table 2.

When I'm not in sessions, you will find me in the demo grounds. Stop by and say "Hello!"

Knowing Your Cloud From Your SaaS

I have recently spent far too much time in far too many conversations in which the terms "cloud" and "SaaS" are used interchangeably.  Let's be clear:  the two terms are not interchangeable as they describe very different concepts.

Cloud.  There are many definitions out there.  Marketers and sales people.  Engineers.  Industry analysts. The National Institute of Standard and Technology.  Frankly, most of those definitions are either wrong, or they're technically accurate while thoroughly useless. (more...)