PeopleSoft

FindFiles function does not return a sorted array

I had a series of files with the following names: JM001.pdf JM002.pdf JM003.pdf .. JM100.pdf JM101.pdf One silly assumption that I made was that the FindFiles PeopleCode function returned a sorted array of strings. While this seemed to be the case on Windows environments, it was not the case on UNIX systems. Fortunately all I had to do was sort the array in ascending order after the call to FindFiles:

Continue reading

PeopleSoft

Manually coding effective-dating

Here is a template that I usually work from to programmatically implement effective-dating for a field. Usually PeopleTools automatically takes care of effective-dating, however there are certain situations in which this does not occur. Eg. when clicking on a hyperlink or button that then modifies a non-derived record-field on the page.

This particular scenario can be written more succinctly as shown below:

It all depends on your requirements. I usually start from the…

Continue reading

Oracle PeopleSoft

PeopleTools 8.5x – Windows – Missing or invalid version of SQL library PSORA (200,0)

I encountered the following error when trying to launch Peoplesoft applications such as Application Designer and Data Mover on my Windows 7 (64-bit) virtual machine:

My machine had Oracle Server 10.2.0.2 (64-bit) installed. I discovered that while PeopleTools 8.5x has been certified to run on 64-bit Windows platforms, the program itself is 32-bit. Thus, any library it needs to load also needs to be 32-bit. In this case, the Oracle server lib ‘PSORA’ must…

Continue reading

PeopleSoft

Application Designer: Cannot build records

I blindly added the environment variable PS_SERVER_CFG to my environment as I read somewhere that it should be set to a path similar to the following:

Believe it or not, but after I set this option, I discovered that I was no longer able to build records in my project! The following is the error I encountered: “Please select at least one action: Create Tables, Create Indexes, Create Views and/or Alter Tables. (76,41)” And…

Continue reading

PeopleSoft SQL Validator

SQL Validator corrupts Application Designer

I’ve noticed that when I run SQL Validator over a project or single SQL statement while Application Designer is still running, I later experience issues in Application Designer. I usually experience a shared key or shared cache error. In some cases I find that I have to purge the cache (using Configuration Manager) before I’m able to successfully run Application Designer again. I’m pretty sure that the problems all relate to the fact that SQL…

Continue reading

PeopleSoft

PeopleCodeTracing

There’s a simple way to turn peoplecode and SQL tracing on and off using peoplecode, rather than having to set the trace values when you login or via PeopleTools > Utilities > Debug. You can use these commands to trace/debug only the peoplecode you’re interested in. For peoplecode tracing, you set the trace flags using the SetTracePC() function. e.g

… will set the trace flags as per the defaults on the Trace Peoplecode page.…

Continue reading

PeopleSoft

Application Engine debugging issues – ParseXmlFromURL

I was trying to debug an application engine process in Application Designer, and the following line (in bold) would throw an exception and prevent me from debugging any further

The value of &sTmplFile was:

I finally discovered that the ParseXmlFromURL method requires a fully qualified path. For example:

My environment was not prepending the drive component because it did not have the PS_SERVDIR environment variable defined. Once I set this variable, everything…

Continue reading

Oracle PeopleSoft

Application Engine: Releasing Temporary Tables

I was trying to debug an Application Engine and noticed that the debugger had hung. I restarted Application Designer and re-ran the debugger for the Application Engine. Since there was only one instance assigned to each temporary table, I noticed that the previous failed run had not released the temporary tables. I managed to work around this by deleting from the following tables:

The following are the SQL Statements that I used:

If…

Continue reading

PeopleSoft

PeopleSoft Project Backup

The following steps can be used to create a batch program to backup your PS projects: 1. Create a text file that contains a list of projects that need to be backed up. Call the file project_names.txt 2. Create a batch file (see below):

This batch file will create a date subfolder inside C:\projects folder and will copy all the projects listed in project_names.txt to this subfolder. Note: The batch file assumes that the…

Continue reading

Oracle PeopleSoft

Using Find Definition References for Impacts

If you are performing an impact analysis using Find Definition References, and are changing Record-Field PeopleCode, then you first need to determine whether the underlying Record for the Record-Field is a derived record. If the record IS a derived record, then you can use Find Definition References on the Record-Field. However, if the record IS NOT a derived record, then you need to use Find Definition References on the Record as all of the fields of the record…

Continue reading