New PeopleCode Dump Method

One of my old tricks was to create a PeopleCode dump from the system.  Then I could use a text editor tool such as gVim or Ultraedit to search through the code to find examples or certain uses of definitions.

Basically, a PeopleCode dump is easily created by searching for (Edit > Find In) a semicolon.  Because every statement must have a semicolon, it matches every statement of code in the system.  On the Find In dialog, checking the Save to File option will write out each line to a text file.

The problem is that Application Designer seems to load every line into memory.  If you don’t have a client machine with a ton of memory, you end up looking like this:

App Designer Out of Memory Error


Instead, I found this new tool called Decode PeopleCode.  You can download the latest zipped version of the program from here.

Once extracted, I had to configured the URL property in the file.  I set it to something like this:

url=jdbc:oracle:thin:@<server name>:1521/<db name>

I also had a problem with the JDBC driver for some reason.  It didn’t find the odbc5.jar file that was delivered.  I already had a copy of the odbc6.jar, so I just adjusted the classpath to include that.  If you run into the same problem, adjust the or DecodePCODE.bat file to contain the full path to the jar file.

Also, adjust the “outdir” property in the file to point to the directory where you want the output dumped.  Note that it will create a bunch of folders and files in that directory, so you may want to point it to an empty directory.

Then, I ran the program with this command to capture everything:

sh since 1901/01/01

Now, that creates each PeopleCode program in its own file.  The problem is that I want it all in a single file that I can run regular expressions against.  I could use grep, but I am used to a single file.  I cobbled this script together to build that single file:


processFile() {
   outdirlen=$((${#OUTDIR} + 1))
   lastUpdateFile=$( echo "$filename" | sed 's/\.pcode$/.last_update/' )
   peoplecodePath=$( echo "$peoplecodePath" | sed 's/\//: /' | sed 's/\.pcode$//' | sed 's/\//./g')
   echo -e "\e[0K\r Writing: $peoplecodePath"
   echo "[$peoplecodePath]" >> "$OUTFILE"
   echo '/*   Details:' >> "$OUTFILE"
   echo '   Last Update User: ' $(head -n 1 "$lastUpdateFile") >> "$OUTFILE"
   echo '   Last Update Date/Time: ' $(tail -n 1 "$lastUpdateFile") >> "$OUTFILE"
   echo '*/' >> "$OUTFILE"
   cat "$filename" >> "$OUTFILE"

#  ------------------------------
#    Main
#  ------------------------------

OUTDIR=$( grep "outdir=" | sed 's/^outdir=//' | sed 's/\r//')
DUMPDATE=$(stat -c %y $(ls -rt | tail -n 1) | cut -d ' ' -f1 )
DATABASE=$( grep "^url=" | sed 's/^url=.*\///' | sed 's/\r//')
echo "outdir -- $OUTDIR  dump date -- $DUMPDATE  database -- $DATABASE"

echo "PeopleCode Dump $DATABASE   $DUMPDATE" > "$OUTFILE"
find "$OUTDIR" -type f -name \*.pcode | while read file; do processFile "$file"; done

That seemed to get the trick done for me nicely.

This program has more features than just this. You should explore it. It can check the code into a sourcecode repository to track changes. Kudos to whoever wrote it!



Posted in PeopleCode. No Comments »

Jethro List: Data Mover Woes

Ok.  Maybe this is a rant, but Data Mover can sometimes get under my skin!  Some things you just expect to work, and when they don’t, it is very frustrating.

Here’s my problem.  I created this very, very simple data import:

set log C:\temp\aa_setup_import_FADEV.log;
set input C:\temp\aa_setup_export_AATST.dat;

replace_data RQ_GRP_SHR_SET;
import RQ_GRP_TBL where RQRMNT_USEAGE = 'ADV';

It gave me this error:

Importing RQ_GRP_TBL
Error: Syntax error in where clause for RQ_GRP_TBL 

Then, when I changed it to use parameters, it suddenly works:

set log C:\temp\aa_setup_import_FADEV.log;
set input C:\temp\aa_setup_export_AATST.dat;

replace_data RQ_GRP_SHR_SET;

In my opinion, there is no call for that error.  I thought both syntaxes were supposed to work the same.  Am I missing something?  Or, is this a bug in data mover?


Next, I ran into a worse problem.  I couldn’t make my subquery work on the import, so I had to move it to the export script instead.  I tried this:

set log C:\temp\aa_setup_export_AATST.log;
set output C:\temp\aa_setup_export_AATST.dat;

export RQ_GRP_SHR_SET;
export RQ_GRP_DETL_TBL where

Every time that I tried it, it would crash Data Mover.  Data Mover closed with no error message, warning, or anything.  When I changed it to this, it worked fine:

set log C:\temp\aa_setup_export_AATST.log;
set output C:\temp\aa_setup_export_AATST.dat;

export RQ_GRP_SHR_SET;
export RQ_GRP_DETL_TBL where

Again, why?  I don’t care what your argument is, it is a bug when a program closes with no message.  If I did something wrong, tell me.  Don’t just close.


Oracle Forums: DATAMOVER: Error: Syntax error in where clause for PSOPRDEFN


PeopleSoft HCM PUM Image with PeopleTools 8.54

I just noticed that the HCM PUM image is now available on PeopleSoft support.  You can download it for the HCM updates, but you can also take a peak at what PeopleTools 8.54 looks like.  If you have an Oracle Support account, here’s the link:   PeopleSoft Update Image HCM 9.2.008.


Just for reference, the image is a total of 11 files and 34.7G.

PUM HCM Image Files List



PeopleTools 8.54.01 Exalogic OVM Template

I ran across this announcement on Oracle’s blogs about the new PeopleTools 8.54 OVM Template.  The problem is that I don’t have Oracle VM and don’t really want to delve into messing with it at the moment.  Virtualbox works better for my playing around.  It turns out that it wasn’t too hard to get this running in Virtualbox.

So, here are my notes…



PeopleTools 8.54 Released

I see that PeopleTools 8.54 is released according to the PeopleSoft Technology Blog.  I’m eager to get digging into the new features, but I’m afraid it may be a while before I get to play with it.

Currently, it looks like you won’t be able to play with it unless you can go through a full install.  Upgrades are not supported until after a patch or two is released:

Today, PeopleTools 8.54 is Generally Available for new installations.  Customers that want to upgrade to 8.54 from earlier releases will be able to upgrade in the near future when the 02 patch is available.

Of course, the easiest way to play with it would be to download it pre-installed from Oracle.  Here’s the way their blog says it:

Many of our customers have shown interest in Fluid and have asked us the best way to get productive quickly.  Our answer is to use the working examples they will find in the upcoming PSFT 9.2 application images.

The current images are PeopleTools 8.53.  I looked at the release dates from last year, and it looks like images came around the August time frame.  So, my unofficial guess is that we will get a fully installed version of PeopleTools 8.54 to play with sometime in August.  In the meantime, I may have to live vicariously through other’s experiences like the PeopleSoft Tipster.



Jethro List: Ctrl + A

This post  is part of my Jethro List.  You can read more about the list on the Jethro List page.

Can I make another suggestion?  Some of the text boxes in App Designer don’t work like regular Windows controls.  Namely, they don’t support things like Control-A to select the entire text in the box.  This is slightly frustrating and also makes App Designer feel antiquated.

One of those places is the File Layout Field Properties dialog.  If you go to the “Field Name” text box, you can press Ctrl+A to select the entire field name easier.  That makes it easy to either copy the name or type a new name in it’s place.

File Layout Field Name


If you go to the Field Description box in the lower right hand corner, you will find that Ctrl+A doesn’t work.  You have to either use the mouse or hit Home, Shift + Ctrl + End.

File Layout Field Description


On a rabbit trail, the file layout UI could use some attention.  A feature that I would like for Flat Files is the ability to sort by the Start Position.  If you come behind someone who wasn’t as organized and didn’t put the fields in order, it can be annoying.  Also, file layouts seem to have issues with caching.  I have had many a time that I changed a file layout and saved only to reopen it and find my changes missing.

The Application Engine UI has a similar problem.  The descriptions for the sections, steps, and actions all don’t allow the use of Ctrl + A.

App Engine description fields

In conclusion, I think it would be helpful if Oracle could update the App Designer UI to match the standard features that we have come to expect in Windows applications.  I can live with it this way and can get my job done, but it sure would be nice to have a nicer feel to development.



Explorations in Equation Engine

I took a nice foray into Equation Engine the other day, and I don’t want to forget what I learned.  On a demo instance, I want to go through a quick example of writing an Equation using Residency Data.  We’ll try to grab the Residency status for a particular person (in state or out of state).



Great Link: 10 Books for $10 on Packt

If you are looking for an eBook, check out Packt!  I was just told about a special promotion that they are running.  Until July 5th, all of their books are $10 each.

Packt 10 for 10


Check out the books on the Packt webite.


Posted in Great Links. No Comments »

PeopleTools 8.54: Looks Exciting

I’ve been a bit behind on reading my news.  Back in April, PeopleSoft released their “Release Value Proposition” for PeopleTools 8.54, and it’s got me excited about it.  Then, a week or two ago, PeopleSoft published the pre-release notes.  I don’t have any inside information, but I thought I would list the features that looked exciting to me…

  • Code Completion:  HUGE — this is a feature I have been looking for for years!
  • 64-bit developer client:  Application Designer, etc. is going 64-bit.  So, a developer must run a 64-bit machine to develop, and now no 32-bit database drivers are required.
  • Automated Configuration Manager: looks like tools that will make automating refreshes much easier
  • %SelectDummyTable: allows for a better way than using the DUAL table for Oracle or PS_INSTALLATION for platform independence
  • Mobile Application Platform: new interface for smart phones
  • Fluid Layout: Creating interfaces with CSS positioning rather than fix positioned pages.  It will be a learning curve for developers
  • Application Designer: PNG files supported for images in Application Designer
  • Application Engine changes: it will now split the trace file into multiple files if it gets too big, you can now choose not to commit at the end of the program
  • Branding Framework: tools to allow customizing the look and branding without needing to code; it looks like it is all in the PIA
  • Query: Default values for prompts and support for images in Query results
  • BI Publisher Updatable PDFs: users can update the report and submit the content back into PeopleSoft
  • Global Temporary Tables (for batch App Engines): supporting in-memory tables
  • Materialized Views: for Oracle — App Designer will create views that store their data in the database for quicker retrieval
  • Portable PS_HOME: On Unix the psadmin binary is only located in the bin directory, paths are not saved in configuration files to moving and cloning the directories easier, and the PS_HOME variable is not set by the script (you set that before calling the script and everything is relative to PS_HOME)
  • Push Notification Framework: looks like it allows the PIA/Web Server to initiate messages to the browser
  • PIA-Based Definition security: ability to secure App Designer definitions using the online pages plus additional new features
  • Query Security: new advanced option to allow up to 5 security records for an individual record
  • SQR: new XML output option
  • Component Interface: new errors sheet to consolidate errors

As I went through the documents,  I noticed a couple of features that are already released and that I need to do some learning and catch up.  Do you mind if I just take some notes out loud here?

  • Activity Guides: “Activity Guides are a useful PeopleTools feature that helps guide users through complex or infrequently performed processes.”  What’s new: “With PeopleTools 8.54, Activity Guides will be even easier to create and manage because PeopleTools includes an Activity Guide Management WorkCenter.”
  • Data Migration Workbench: “Data Migration Workbench is a lifecycle management tool first delivered with PeopleTools 8.53 that enabled customers to move and compare configuration data easily and securely between PeopleSoft application instances such as DEV, TEST, and PROD”
  • JSON: The PeopleSoft Documents Technology mentions using JSON, and I hadn’t kept up that JSON was available.
  • Oracle Secure Files: mentions that Report Repository files can be exposed as a “virtual mount point”

64-bit History:  The 64-bit requirements have been of notable interest to me because I spent some time working for a client who had challenges switching away from 32-bit hardware.  One of the documents listed the history of the migration of PeopleSoft from 32-bit to 64-bit.  Here’s a nice summary:

  • PeopleTools 8.48 — Unix Application server converted to 64-bit
  • PeopleTools 8.50 — Linux Application server
  • PeopleTools 8.51 — Web Server
  • PeopleTools 8.53 — Windows Application server
  • PeopleTools 8.54 — Developer Tools




Great Link: International Day Against DRM at Packt

If your looking to buy a book, today is a great day to do it.  Packt is celebrating International Day Against DRM by offering books for $10.  It’s only for today.

International Day Against DRM at Packt

You can check it out at

Posted in Great Links. No Comments »