PeopleSoft App Store

Simple and Quick Audit access

Every customer will have a set of records and fields that they audit within PeopleSoft – and these will vary wildly from client to client. What doesn’t change however, is the need to view the rows recorded in the audit records. Unfortunately, PeopleSoft doesn’t deliver anything to let you do this, you have to either use SQL or craft a Query. Many people don’t have SQL skills, and Query often isn’t appropriate as either people don’t have the skills, the access or it’ll take too long. To fill this gap I decided to build the following tool:

This component allows you specify an audit record to examine (both record and record/field level auditing is supported by the tool).

Once the page loads, you are shown two areas where you can filter the audit rows that will be returned. The first area lists common audit fields (i.e. those that will appear on all audit records, plus some fields which allow you to specify a date range). The second area reads the keys from the record that the audit rows relate to and allows you to filter by those also (so these are dynamic, based on the record that you selected).

When you click search you audit record is queried and the rows returned (subject to your query fields).

A quick and easy way to allow non-technical staff to look-up audit data.

Currently live with 1 customer.

Fully tested on PeopleTools 8.50, 8.51 and 8.52. (It should work on 8.4x but has not yet been tested.)

Price: £400 / $640

Interested? Get in touch by filling out our quick Purchase form.

Ease security / menu admin with this simple tool

All implementations will – at some point or other – include a task to ‘tidy up the menus’ and remove some of the unnecessary folders and components. This is an iterative task, and at times quite frustrating. The most annoying occurrence is when a user’s menu options somehow include a folder or content reference that (given the reduced set of permissions that you’ve granted them) they shouldn’t be able to see. After one such occasion I decided to build the following tool:

This component allows you specify a oprid and then either a portal registry folder or content reference. It then looks through all of the different ways in which the folder or cref could be visible to that oprid and outputs a short report on-screen. I’m not exaggerating when I say that this saved hours/days of frustration on my last project.

Simply search for the UserID (or User Name) that you’re investigating. Then fill out the details of your folder / content reference:

If you don’t know your Content Reference name, the Prompt allows you to search by the Menu Label too:

Click search and the page checks for all of the ways that the user can have access to the Menu Item. The results look like this:

Currently live with 1 customer.

Fully tested on PeopleTools 8.50, 8.51 and 8.52. (It should work on 8.4x but has not yet been tested.)

Price: £500 / $800

Interested? Get in touch by filling out our quick Purchase form.

Single-click account unlock / password reset

For sites that don’t have an enterprise-wide single sign-on solution that’s integrated with PeopleSoft the number one cause of calls to the helpdesk will be password resets/account unlock requests (source). It’s not particularly desirable to have your 1st line support staff accessing the delivered User Profile component of PeopleSoft (nor is it fast if all you wish to do is unlock an account or reset a password). It’s a great idea to speed things up and simplify administration with a page dedicated to this business function, giving your 1st line support a single-click method of resetting passwords and/or unlocking accounts.

Simply search for the UserID (or User Name):

And then click unlock to unlock the account and/or reset password to have the system assign a new random password.

The user will be prompted to change it on next logon (assuming that password controls are on).

Currently live with 1 customer.

Fully tested on PeopleTools 8.50, 8.51 and 8.52. (It should work on 8.4x but has not yet been tested.)

Price: £300 / $480

Interested? Get in touch by filling out our quick Purchase form.