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 (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