Technology Adjacent

Getting Started PeopleCode Component Interfaces are a powerful tool for interacting with PeopleSoft systems and many third-party integrations still use PeopleSoft Component Interfaces. Unfortunately this is sometimes through APIs that can be difficult to troubleshoot or that you have little control over, as a PeopleSoft developer. I recently came across a situation where a vendor had a PeopleSoft interface already developed to call a PeopleSoft CI. The CI itself was built in our PeopleSoft environment, per the vendor specifications, but they were receiving Save errors. We wanted to confirm the CI was working properly, and that the service account had the appropriate security, but the feedback through their API was severly limited. The service account only had basic permissions to the Component Interface itself, which I was sure this was sufficient, but really wanted to test the CI as the user that would be running it . I know I can use the Test Component Interface tool in App De...

When running PeopleSoft behind a load balancer the client IP address is sometimes not reported correctly on the PSACCESSLOG table, or when using the built-in PeopleCode functions.  This definitely occurs when using Netscaler, as this is what I have the most experience with and what I have had others ask about, but other load balancer products may cause the same behavior. To get an accurate IP address you must configure the load-balancer to pass this information, which can be done using the HTTP header "X-forwarded-for".  Here is some information on Netscaler.  Refer to your load balancer documentation for details on this setup. https://docs.citrix.com/en-us/netscaler/10-1/ns-tmg-wrapper-10-con/ns-lb-wrapper-con-10/ns-lb-advancedsettings-con/ns-lb-advancedsettings-cip-tsk.html Once the load balancer is configured use PeopleCode to read the header for the actual client IP address.  You can create your own access log tables or write conditional logic based on the...

The PeopleSoft PUM Image VMs seems to work pretty well once installed.  There is very little maintenance that I have had to perform on these environments and I can always start over by rebuilding the VM if I really break something.  Still, there have been some small issues recently that have required digging into the these environments so here are some notes to help. Database Administration The Oracle Database runs within the same VM and can be accessed using TNS with SQLPlus, SQL Developer, or most other Oracle-compatible tools.  However, I recently needed to make some adjustments to the SYSADM privileges.  For this I needed to connect as SYSDBA. 1. Login to the VM as root   (this account was setup when you installed the image) 2. Switch to the oracle  account.  This is the database owner. su - oracle 3. You then need to know the database name to connect to.  The easiest way is to look for the pmon process.  In the example be...

A few years ago I read about using Javascript to create "bookmarklets".  These are browser bookmarks that, unlike normal bookmarks, do not point to a specific URL.  They instead contain Javascript and run that script when selected.  This allows you to do a number of interesting things, but one idea I really liked was using them to create universal bookmarks, or cross-environment bookmarks, for PeopleSoft. Basically, once you are logged into a PeopleSoft environment you can use a bookmarklet to transfer you to a specific page within that environment.  This means I can have a single bookmarklet that takes me to a particular page of whatever environment I am in.  So for example, I have one bookmarklet called "Process Monitor".  If I am in FSCM and click that I am taken to Process Monitor for that environment, but if I am in HCM it takes me to that Process Monitor. How Do They Work? As I mentioned, a bookmarklet is just Javascript that does something . ...