Almost all of the technical PeopleSoft sessions at OpenWorld were using PeopleTools 8.52 which in not GA yet. I was pleasantly surprised that Oracle showed commitment to PeopleSoft platform and desire to develop not only the PeopleTools but also enhance the product offering by providing more integrations and run-times of the other products that Oracle owns, for example Oracle SES Search will replace Verity in the next version PeopleTools and will also provide enhanced search capability throughout the application. Here is a sneak peek of the new stuff:

  • Pivot Grids – interactive analytics based on the query
  • Related Content/Actions – additional action in the context of current transaction without leaving the current page
  • Application Search / Component Search (SES) – navigate to transactions, items in the catalog and whatever else you have indexed
  • Pagelet Improvements – Enhanced ability to drill, edit fields in the pagelets
  • Modal Windows – removed limitations intorduced in 8.51, more widely used in Applications 9.2
  • InterWindows communications are intorduced
  • Application Designer–  (finally) drilling into Application Classes/Packages, Find Definition references for Application Classes

It seems that there are more good news across the Oracle products – in order to gain competetive advantage we should be seen more and more products being better integrated and even some of them being offered for free within a product you already own. Fusion Apps for example utilize Hyperion Analytics for grids. Of course those “free” components will have just a run-time license.

For full overview of the new features coming out in 8.52  you can download the PeopleTools Highlights session presentation from the OpenWorld Site

 

As I was working on the Peoplesoft upgrade project I have noticed that some of the developers were still using App. Designer Compare reports as a sole means to comparing the code and components during customization reapplication process. It seems the new ways of doing compares are not being used as extensively as I hoped.

I figured I would write a quick post to remind my developers and others out there some of the features that have been implemented since version 8.49. For those experts readers who have been using these and other technics for awhile I would appreciate if you share your own technics.

 Running Compares

So without further due, below you can see a sample PeopleSoft’s visual merge compare for Project Peoplecode. In order to save you from long and boring explanations – I will leave it to PeopleBooks – Using Merge Interface. However I would like to add just a few comments – sometimes I find myself pasting compare code into good old Notepad++ and running a compare in there. I guess I do like the power of the full fledged editor and syntax highlighting does not hurt as well.

PeopleCode Compare/Merge

As much fun as App Designer reports are I always like to look at the reports in the HTML view  – better , faster and cleaner experience. And all it take is specifying Generate HTML report in the Compare Options in App Designer:

Generate Browser Reports

Secondary Pages

If you are creating a complex page that contains some sort of look-up pages – always a good idea to split the interface and not create page that would overwhelm the user.  In earlier versions of tools going to secondary pages required user to transfer to a separate page, however since Tools 8.50 – secondary and modal pages can open in a modal JavaScript Popup that still allows you to stay on the same page:

modal secondary form

 

 

 

 

In order to enable this behavior for existing and new pages you just need to enable one little checkbox and voila:

Enable Modal Secondary Page

 

Change Control

When working in a team and making multiple changes to the environment you don’t want to be stepping on each others toes. Although still quite limited and inferior to Tools like Quest Stat – PeopleTools built in change control does provide you the ability to lock objects while you change them and leave comments as to what was done (always a good idea). This also helps with documentation – once you are done with the changes you can run a quick SQL and get a report of all the changes that were done for more please go to here.

I hope you enjoy this and let me know if you have any suggestions.

 

 

 

Straight from Oracle – here is a new guide for troubleshooting and tracing different processes. It also include updates for XML Publisher and Crystal reports.

http://www.scribd.com/doc/25496613/

Enjoy!

 

It seems Oracle starts to promote code sharing through it venture with CollabNet. I have not seen much content related to PeopleSoft other than one-ff document about audit records. Let’s hope this will pick up in the future.

https://www.samplecode.oracle.com/

 

This question came up during the recent application security audit – how does PeopleSoft track user sign in attempts and locations.

Aside from the obvious PSOPRDEFN table there is PSACCESSLOG – this table has OPRID, LOGIPADDRESS, LOGINDTTM, LOGOUTDTTM columns that give you information about user sign on activity. LOGIPADDRESS will contain the RemoteAddr property  of  %Request object, which is also useful in case you validate user ip address at the sign on. The only problem this could pose is in case your users are behind a single or multiple gateways that perform NAT. Then the value of this field would contain those NATed ip addresses and not the actual user ip addresses.

© 2011 WorkingScripts Suffusion theme by Sayontan Sinha

Switch to our mobile site