Ya Gotta Water The Garden

With his love
And his carin'
He puts his life
Into beauty sharin'
And his children
Are his flowers
There to give us peace
In quiet hours

And I'll do anything I got to do
Cut my hair and shine my shoes
And keep on singin' the blues
If I can stay here in Johnny's garden

                         - From "Johnny's Garden" by Stephen Stills


(more...)

Yamaha’s PSR-E463 – A truly awesome Keyboard to have

Though I am a beginner in this instrument, still I would like to recommend others to go with this keyboard.

Yamaha's PSR-E463 makes a perfect first keyboard for students, a solid educational tool for classrooms, and a fun, lightweight travel instrument and composition tool for professionals. Each of the E463's 61 full-sized, organ-style keys provides good resistance with a quick response that's suited for playing dynamic string pads to quick brass lines and synth leads. (more...)

I’m Brad Carlson and this is how I work

This week we’re featuring another of the mainstays from the PSAdmin.io slack community  – Brad Carlson. He is a regular in the community and another member of the seemingly endless ‘PeopleSoft Minnesota Mafia’. Brad is a frequent guest on their PodCast talking about his IB Monitor tool and discussing the highly efficient application of CPU patches. I’m thrilled that he has added his profile to our ‘How I Work‘ series.

bridge

 

Name: (more...)

PeopleTools Client with Wine

One of the shortcommings to using Ubuntu Linux as my main OS is not being able to run Application Designer. Using Wine, I am now able to run it on my laptop. If you were to translate the Ubuntu specific commands over to Oracle Linux and install an XWindows desktop on the PUM, you could get App Designer running there, too.

Installing Wine

I installed Wine with these commands.

sudo apt-get install --install-recommends wine
sudo  (more...)

101 Ways to Process JSON with PeopleCode

... well... maybe not 101 ways, but there are several!

There is a lot of justified buzz around JSON. Many of us want to (or must) generate and parse JSON with PeopleSoft. Does PeopleSoft support JSON? Yes, actually. The Documents module can generate and parse JSON. Unfortunately, many of us find the Documents module's structure too restrictive. The following is a list of several alternatives available to PeopleSoft developers:

Managing Cost-Based Optimizer Statistics for PeopleSoft

I gave this presentation to UKOUG PeopleSoft Roadshow 2018

PeopleSoft presents some special challenges when it comes to collecting and maintaining the object statistics use the cost-based optimizer.

I have previously written and blogged on this subject.  This presentation focuses exclusively on the Oracle database and draws together the various concepts into a single consistent picture and makes clear recommendations for Oracle 12c that will help you work with the cost-based optimizer, rather than (more...)

Using PeopleCode to Read (and process) Binary Excel Files

At HIUG Interact last week, a member asked one of my favorite questions:

"Does anyone know how to read binary Microsoft Excel files from PeopleSoft?"

Nearly 15 years ago my AP manager asked me the same question, but phrased it a little differently:

"We receive invoices as Excel spreadsheets. Can you convert them into AP vouchers in PeopleSoft?"

Of course my answer was "YES!" How? Well... that was the challenge. I started (more...)

Read the Readme

Read the readme.

When applying PSU or OJVM do instructions as documented in the readme in the specificed sequence. Run post patch instructions as specified in the readme.

E Business Suite will stop authenticating users if post ojvm instructions are missed.

Live Virtual Fluid Training in July

In the Northern hemisphere, with days getting longer, and temperatures rising, many of us seek wet forms of recreation to keep cool. With the heat of summer upon us, I can't think of a better topic to study than the cool topic of PeopleSoft Fluid. That is why we are offering a remote live virtual Fluid training class during the hottest week of July. Additional details and registration links are available on our live virtual (more...)

Sneak Preview of Newsfeed UX

I've recently have a chance to get deeply involved with a new User Experience ("UX") rolling out in Oracle HCM Cloud 18B, due out later this year.  We're rolling out some pretty cool work.  I like it for a few reasons:

  1. A fully responsive user interface - one code line that responds that provides the optimal UI for laptop/desktop, tablet and phone.
  2. More emphasis on Quick Actions, giving users shortcuts directly to transactional pages rather (more...)

OHUG Solutions Central – Come See The Experts

Don't try to describe the ocean if you've never seen it
Don't ever forget that you just may wind up being wrong

                                     -  From Mañana by Jimmy Buffet

Having been in the enterprise software business for longer than I really care to admit, I've witnessed an awful lot of smoke blown up an awful lot of skirts. (more...)

I’m Charlie Sinks and this is how I work

This week we’re featuring another of the mainstays from the PSAdmin.io slack community  – Charlie Sinks. He is a regular in the community and a frequent guest on their PodCast giving UMRUG recaps and discussing automation. He also presented at the inaugural PSAdmin.conf on Implementing Rundeck with PeopleSoft (the recording is available here and is well worth an hour of your time). I’m thrilled that he has added his profile to our (more...)

Enabling Excel Functions in BI Publisher Report Excel Output

When displaying numerical data in BI Publisher report using the Excel format, leading zeros in the output values is removed automatically by MS Excel. One way of preventing this is to use fo:bidi-override.

BIP_Excel

This, however, leads to the situation where Excel functions such as SUM, AVERAGE etc do not work on the values which are displayed using the fo:bidi-override option. This is because of the special characters which are automatically added before and after the (more...)

About Continuous Service Delivery

I feel like a spinning top for a dreidel
The spinning don't stop when you leave the cradle...

                                                    From "Dreidel" by Don McClean

Continuous Service Delivery aka CSD:  it's all the buzz in the Oracle Cloud Application circles these days.  It's Oracle's answer to the ever-increasing rate of change (more...)

I’m Wayne Fuller and this is how I work

This week we’re featuring another of the ‘leading lights’ from the PSAdmin.io slack community  – Wayne Fuller. He is a regular in the community and a frequent guest on their PodCast discussing running large scale PeopleSoft while at Wells Fargo (amongst other places). He also presented at the inaugural PSAdmin.conf on The Future of PeopleSoft Administration (the recording is available and is well worth 30 minutes of your time). I’m thrilled that he (more...)

Application Engine in Process Scheduler: PSAESRV Server Process -v- Standalone PSAE executable

Whether to use the Application Engine server process (PSAESRV) in the process scheduler tuxedo domain or the standalone PSAE executable is a frequently discussed point amongst PeopleSoft administrator.  Over the years, I have written various things on the subject.  I am going to draw them together in this blog, and restate Oracle’s now clear advice about when to use which option.

In PeopleTools 8.4, the Process Scheduler became a fully fledged Tuxedo (more...)

Fluid in Seattle! Special Fluid Training Event

May 23, 2018
PeopleTools Fluid UI Training
8.54 through 8.56
Led by Jim Marion

SpearMC and jsmpros are co-hosting a PeopleTools Fluid training event in Redmond, Washington immediately following the Spring PeopleSoft Northwest Regional User Group meeting. Through this event I will cover the exact same material I regularly teach online, but in person for a 40% discount off the online price. The event runs from Wednesday May 23 to Friday May 25 (more...)

Getting Ready, Part II

A recent post here, "Getting Ready", was all about getting ready for the Oracle Cloud Applications upgrade from R12 to R13.  Now that the upgrading is underway, I thought it might be a good time to add a bit to the info passed along in that prior post.  I'm thinking a basic bullet list is the best way to get this done, so here we go.

  • Upgrade Readiness  Checklist:  You can find (more...)

Resetting High Water Marks on On-line Temporary Table Instances

PeopleSoft has always used regular database tables for temporary working storage in batch processes.   Up to PeopleTools 7.x working storage tables were shared by all instances of a program.  That led to consistent read contention when multiple processes concurrently used the same table, and much higher high water marks that increased durations of full scans.
From PeopleTools 8, many copies of each temporary working storage table are created.  Application Engines that (more...)

I’m Jason Fletcher and this is how I work

To anyone who frequents the PSAdmin.io slack community (and that’s almost 500 people) the name Jason Fletcher (or fl3tchr) will be one that’s instantly familiar. He is not only seemingly ever-present, but also dishes out rapid-fire PeopleSoft advice, humour, gifs and good-natured sarcasm in more-or-less equal measure. I’m thrilled that he has added his profile to our ‘How I Work‘ series.

Name: Jason Fletcher

Occupation: It breaks, I fix. (AKA administrator for (more...)