Pinging and Posting from PeopleCode

I had a need to Ping a server to see if the server could get to it.  I also tried to post to it.  This code could be helpful for others, so I want to share it.  A post should normally go through the Integration Broker, but I first developed it at a time when I had a product that was supposed to go on servers with diverse versions of Integration Broker.

The Ping code (more...)

Forms Tables

I’ve been doing some work with the Enterprise Component Forms in HCM, and it is helpful to know the tables in the backend.  Here are the tables that I have found so far…

Note: One issue I have with the forms is that I haven’t found a way to edit someone else’s form.  If a functional consultant mock’s up a form, I can’t get access to the form to take over development and finish (more...)

Searching with USEEDIT

Because many of the record properties are hidden in the Bit Map field USEEDIT, it is hard to search for properties.  If you are on Oracle, here’s some SQL that might help…

This SQL lists all of the fields with their properties broken out of that field:

       Bitand(USEEDIT, 1)         KEY,
       Bitand(USEEDIT, 2)         DUP_KEY,
       Bitand(USEEDIT, 4)         SYS_MAINT,
       Bitand(USEEDIT, 8)         AUDIT_ADD,
       Bitand(USEEDIT, 16)        ALT_SEARCH_KEY,
       Bitand(USEEDIT, 32)        LIST_BOX_ITEM,
       Bitand(USEEDIT, 64)        ASCENDING_KEY,
       Bitand(USEEDIT, 128)       AUDIT_CHANGE,
       Bitand(USEEDIT, 256)       REQUIRED,
       Bitand(USEEDIT, 512)       XLAT,
       Bitand(USEEDIT, 1024)      AUDIT_DEL,
       Bitand(USEEDIT, 2048)      SEARCH_KEY,
       Bitand(USEEDIT, 4096)      EDIT_REASONABLE_DATE,
       Bitand(USEEDIT, 8192)      EDIT_YES_NO,
       Bitand(USEEDIT, 16384)     EDIT_PROMPT_TABLE,
       Bitand(USEEDIT, 32768)     AUTO_UPDATE,
       Bitand(USEEDIT, 65536)     BIT65536,
       Bitand(USEEDIT, 131072)    BIT131072,
       Bitand(USEEDIT, 262144)    FROM_SEARCH,
       Bitand(USEEDIT, 524288)    TO_SEARCH,
       Bitand(USEEDIT, 1048576)   EDIT_BINARY,
       Bitand(USEEDIT, 2097152)   DISABLE_ADV_SEARCH,
       Bitand(USEEDIT, 4194304)   REGULAR_FIELD,
       Bitand(USEEDIT, 8388608)   DEFAULT_SEARCH_FIELD,
       Bitand(USEEDIT, 16777216)  BIT16777216,
       Bitand(USEEDIT, 33554432)  SEARCH_EDIT_KEYS,

Search for a Field with Translates

I was looking for an “Internal/External” field.  I wanted a field already built that had two translate values: “E” and “I”.  This SQL did the trick:


I found the INTERNAL_EXTERNAL field, which works just perfect for me.


Anyone need remote help?

Does anyone know of any good contracts that would support mostly remote work?

I started this blog years ago with the idea that it would be a good place to search for work should I ever need it. I think the time has come to just ask to see if projects are available through this avenue. If you know of anything, I would love to speak with you. Would you mind commenting below or sending (more...)

Annual Report from WordPress

Recently, 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 – 2014 Year in Blogging

Here’s a couple of excerpts:

Crunchy numbers

Madison Square Garden can seat 20,000 people for a concert. This blog was viewed about 67,000 times in 2014. If it were a concert at Madison Square Garden, it would take about 3 (more...)

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

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:tempaa_setup_import_FADEV.log;
set input C:tempaa_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  (more...)

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.  Here’s the link:   PeopleSoft Update Image HCM 9.2.008



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…

To start, I downloaded the machine.  It came in 4 zip (more...)