Packt Publishing Special Discount

I just saw that Packt is running a special on their books.  To celebrate their 2,000th title, you get a free eBook with your purchase.  If you’re in need of a book, now’s the time to check it out.

You can learn more on the Packt Website.



Installing PeopleTools Client on Ubuntu Linux Host

Ubuntu has been my choice of OS for some time now. It works great for the most part until I start trying to interact with the Microsoft-centric business world. App Designer is one of those pressure points. Normally, my clients give me a Windows-based remote desktop, but for playing around with things outside a client, I needed a way to run App Designer locally on my laptop.

I finally figured out how to install App (more...)

Ben Admin Snapshot Error

I ran into this error with the Ben Admin Snapshot process. It was the second time I ran into it, so I thought that I had better make sure that I got this in my notes so I would remember it.

Here’s the error…

Costs Not Found For Pgm/Plan/Optn: <benefit program>/<plan type>/<option code>.
Application Program Failed
 In Pgm Section  : MOVE-TO-PDEFN                                                                                                                                               

Application Program Failed
 In Pgm Section  : TABLE-ACCESS(PSPBATBL)                                                                                                                                      
Application Program Failed
 In Pgm Section   (more...)

Great Link: PSChrome Extension

The other day, I ran across this nice Chrome Extension called PSChrome.

I had an old TamperMonkey script that I had used, and I was wondering if an extension might make more sense. When I looked to see if one already exists, I found PSChrome.

PSChrome Extension in the Google Chrome Store

One of the big features is that it displays a list of environments on the sign on page. That allows you to jump (more...)

Changing Records in Queries

This isn’t best practice, but I found a way to switch out a record in a query without redoing the criteria. Here’s the situation: I have a query in which the row-level security is causing problems. It is slowing down the query and also eliminating future-dated rows from the results. So, I created a view of the table which would select all of the rows from the original table. It was basically a copy with (more...)

Null Date in PeopleCode

Just the other day, I needed to set a Date to null or blank, and I couldn’t remember how to do it.  Here’s my notes so that I can remember next time.  Javier’s blog came to the rescue:

Javier’s PeopleSoft blog: Setting Date Variables to Null in PeopleCode

The short version is: use the Date(0) function:

     Local Date &amp;hireDate;

     &hireDate = Date(0);

Here’s some more information to explore a little more in depth…

The Date() function (more...)

Annual Report from WordPress

Last week, I received my annual report from WordPress/Jetpack.  I have always enjoyed these reports, so I thought I would make it public.

For the complete report, view it here: PSST0101 – 2013 Year in Blogging

Here’s a couple of excerpts:

Crunchy numbers

The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 78,000 times in 2013. If it were an exhibit at the Louvre Museum, it would take about 3 days (more...)

Import/Export with Data Mover

A common development task is to move data between two different PeopleSoft environments.  You can use App Designer to move code, table structures, and pages, but data is a different story.  Data Mover is your tool for moving your data.

My biggest challenge is that I don’t use it enough (more...)

Scheduling a Process from PeopleCode

The process scheduler provides a good standard way to launch a process.  You simply add a subpage to your run control page, and the delivered “Run” button does all of the work for you.  But sometimes, you want to run the process other ways.  Sometimes, you might want to create (more...)

Using Open COBOL with PeopleSoft

COBOL in PeopleSoft has long been one of my frustrations.  I have had trouble with change assistant not getting the right version of the files in the correct directories.  The compiler is an extra set of steps for installing and getting the system working.  The license has to be installed (more...)