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.

2000th-Book-Home-Page-Banner

Share
Posted in Great Links. No Comments »

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 Designer for Oracle’s PeopleSoft VM images directly in Ubuntu. Here’s what I did…
(more…)

Share

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  : MAIN(PSPBASCH)                                                                                                                                              

(more…)

Share

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

(more…)

Share

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 the query security view removed. The next challenge was to change the query to use that new record. If I remove the old record and add the new, I would have to redo the whole complicated query just about.

So, I found that I could update two records in the database:

UPDATE PSQRYFIELD
SET RECNAME = '<new record name>'
WHERE QRYNAME = '<query name>'
AND RECNAME = '<old record name>';

UPDATE PSQRYRECORD
SET RECNAME = '<new record name>'
WHERE QRYNAME = '<query name>'
AND RECNAME = '<old record name>';

After that, I found that I needed to open the query online in query manager, make a small change, and save it. After that, it worked fine with no problems.

Warning: use at your own risk. This isn’t the intended way to edit queries.

Share
Posted in PeopleTools, Query. No Comments »

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 &hireDate;

     &hireDate = Date(0);

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

(more…)

Share

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

(more…)

Share
Posted in Blog. No Comments »

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 to have the syntax memorized.  This post is a list of common tasks with the syntax to make it easier to remember…

(more…)

Share

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 a more customized feel on a end-user page and launch a process from a push button.  Or, you might want to launch an additional process from an App Engine program.

In this post, I would like to drop notes to make this easier the next time I need to do it.

(more…)

Share

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 in addition to the compiler, and most likely several run time environments.  Typically, you would have to ship the COBOL programs between servers assuming you only have one server that is licensed to compile.

I can understand paying money for a program that you use, but COBOL doesn’t fit that description in my mind.  Every client that I have worked at won’t touch a COBOL program: every customization must be outside the COBOL programs.  So, why then should I have to pay thousands of dollars for a COBOL compiler?

So, I thought I would play with an open source compiler.  I thought it would do two things:

  1. Maybe in some small way influence toward Open COBOL as an official certified alternative
  2. Help me better learn how the COBOL system works

So, here’s what I learned:

(more…)

Share
Posted in COBOL, Jethro List. 7 Comments »

Switch to our mobile site