PeopleSoft Text Editor Visual Studio Code

PeopleCode Syntax Highlighting available for Visual Studio Code

I have moved away from Sublime Text in favour of Visual Studio Code, and have created PeopleSoft Tools for Visual Studio code. I’ve noticed that the Extract Call stack functionality performs considerably faster in VSCode than it does in Sublime Text because of Node’s non-blocking IO. It also permanently saves a stack track file (tidied or untidied) to the same location as the trace file. The extension can be installed within VSCode, or you can find…

Continue reading

Oracle PeopleSoft

PeopleCodeTools – Syntax Highlighting for Sublime Text

I’ve had a few requests from people to document how I use the  PeopleCodeTools syntax highlighter in Sublime Text. Here’s a quick overview. Firstly, the source code is freely available on github, for those that would like to contribute to it. And for those unfamiliar with installing this plugin using Sublime Text, all you need to do is first install Package Control, and then install the ‘PeopleCodeTools’ plugin from Package Control. The plugin should work for PeopleCode…

Continue reading

Oracle PeopleSoft

Extracting the call stack from a PeopleCode trace

I’ve added another tool to the PeopleCodeTools Sublime Text plugin that allows you to extract the call stack from a PeopleCode trace. You can find it on the PeopleCodeTools repository on github along with the syntax highlighters for PeopleCode and PeopleSoft trace files. For those unfamiliar with installing this plugin, please see my previous post: PeopleCodeTools – Syntax Highlighting for Sublime Text This tool only applies to PeopleSoft Trace Files that have at a minimum the following trace…

Continue reading

PeopleSoft

Cross-browser PeopleSoft Bookmarklets

Here are some cross-browser bookmarklets I wrote that should allow you to navigate to a particular component irrespective of what environment you’re in: PeopleCode Trace SQL Trace Roles User Profile Permission Lists Process Monitor To install, simply just drag the links onto your bookmarks/favourites bar. To add your own, use the following as a template, replacing the <Menu>.<Component>.<Market> where appropriate: javascript:var a=window.frames.location.pathname.match(/^\/ps[pc]\/(.+?\/)(.+?\/)(.+?\/)/),b=a[1];-1<b.indexOf(“_”)&&(b=b.substr(0,b.indexOf(“_”))+”/”);void window.open(“/psp/”+b+”_newwin/”+a[2]+a[3]+”c/UTILITIES.TRACE_SQL.GBL“,””,””); I find them especially useful in the following situations: When you have…

Continue reading

PeopleSoft

PeopleCode: Disabling Save Warning

I encountered the issue mentioned on the following page: http://getlevel0.blogspot.com.au/2011/01/debugging-save-warning.html I was trying to disable a save warning that was occurring on a secondary page that I was manually populating. I purposely de-selected all of the Set Component Changed fields on the page and even added hidden fields (eg. key fields) on the page so that I could de-select the Set Component Changed values for all of the fields in the record: Unfortunately I still received…

Continue reading

Oracle PeopleSoft SQL Performance Tuning

PeopleSoft Trace Settings

Update: I have changed this post based on Graham’s recent comments regarding Trace Magic since the trace settings that I recommended were not actually compatible with Trace Magic. Please see the following link for information regarding Trace Magic: https://communities.oracle.com/portal/server.pt?open=514&objID=224&mode=2&threadid=382561 However, when manually reading a trace file (e.g. in Sublime Text, Notepad++, etc.) I would recommend the following trace settings: -TRACE 135 -TOOLSTRACESQL 31 -TOOLSTRACEPC 4044 I still find these settings useful for non-performance related debugging issues.

Continue reading

Oracle PeopleSoft Windows

Identifying the cause of high CPU utilisation for process oracle.exe on a Windows environment

I was running a PeopleSoft Application Engine process that I suspected was hogging the CPU on a Windows environment. I wanted to see whether this process was in fact the cause of the CPU intensive activities on the database. Interestingly, I discovered that on a Windows environment, an Oracle instance is composed of one oracle.exe process with many different threads. Each thread represents either a background process (PMON, SMON, etc.) or a foreground user session.…

Continue reading

PeopleSoft

FTP Class in PeopleSoft

Here’s a class I created to allow FTP from within PeopleSoft. Use it at your own risk:

Continue reading

PeopleSoft

Using Rept to pad zeroes

I was creating a PeopleCode script to populate test persons in my database. I needed the persons to have IDs that would be padded with 0s where necessary. For example:

Solution: 1. Determine how many people you are creating (eg. 100). 2. Find the number of digits of that number (eg. 100 has 3 digits) 3. Subtract that from the number of the person that you’re currently trying to create an id for (eg.…

Continue reading