Monday, January 30, 2012

PeopleSoft Applications Portal 9.1 Feature Pack 1

Again Oracle shows its commitment to continue investing in PeopleSoft. This time by changing the release model of PeopleSoft Applications Portal, formally known as PeopleSoft Enterprise Portal, by adding Feature Packs. With these Feature Packs customers do not need to upgrade or re-implement PeopleSoft Applictions to be able to use the new features, as Feature Packs come as patches that can be applied to the current PeopleSoft application using the change assistent.

Wednesday, January 18, 2012

Create interactive dashboards with InterWindow Communication (IWC)

In a previous post I mentioned a new feature of PeopleTools 8.52: Dashboard. With this feature you can create custom dashboards with pagletes that provide information about a certain business area. Oracle didn't stop here and also added Interwindow Communication (IWC).

Interwindow communication is a frame-to-frame messaging mechanism that enables browser window objects—such as pages or pagelets—to be aware of and react to field-level data changes that occur in other window objects that share the same browser window. Interwindow communication enables you to publish field-level changes as they occur so that any subscribing page or pagelet becomes instantly aware of the change and then, can act on it in real-time. Administrators, subject matter experts or application developers configure page fields to respond to either changes in value or a mouse click. When the triggering event occurs, the application posts a string-formatted message. Because of partial pagelet refresh functionality, subscribing pagelets can then respond within the context of the data contained in the message. Interwindow communication supports component-based pagelets and noncomponent-based pagelets (iScript-based or other Pagelet Wizard pagelets).

Saturday, January 14, 2012

Create apealing Dashboards with PeopleTools 8.52

Oracle has added another great feature to PeopleTools 8.52:


A dashboard is an overview consisting of pagelets containing information about a certain subject. Until now you were able to add pagelets to your home screen or workcenters. Because you only have one PeopleSoft home page, you are limited in the number of pagelets you can add to get a clear view of what is happening in your business or which actions you need to take. Workcenters did add some additional productivity, but you are limited to add pagelets only to one frame of the browser.

Wednesday, January 11, 2012

Extending PSQuery productivity with Drilling Url

PSQuery is an online PeopleTools functionality heavily used by business analysts and key users to gain information from the PeopleSoft application without the need of development or database SQL knowledge. The biggest con of PSQuery is that you end up with one static list of data, which is usually exported to Excel for further enhancement and analysis.

From PeopleTools 8.50, you now have the ability to create more in-depth analyses and productivity using drilling URLs.

When you build a query using Query Manager, you can define drilling URLs that are associated with this query using the expression option. These settings are saved into the database, along with prompt, criteria, and so on, as part of the metadata for this query. When you execute this query through Query Manager or Query Viewer, the query results page shows results as links, which you can click to be redirected to a different page in a new browser. You can create URLs for:

  • Other PSQuery, for more in-depth information about a subject, actual drilldown functionality

  • PIA Component, direct link to components where the keys for the search page of the component are extracted from the selected columns in the query

  • External URL, non PeopleSoft URLs, for example Vendor sites

  • Attachment URL, direct link to an attachment that is stored in the database or file system

  • Free Format URL, any type of URL you want to construct, can be used for example to deep link to other non-PeopleSoft applications
So how does one create a drilling URL?