Wednesday, 16 October 2013

UKOUG Apps 2013 Conference

The UKOUG PeopleSoft community have two days of finance, HR and PeopleTools presentations at The Brewery in London as part of the Apps 2013 event.  As always the networking with other customers and partners proved very useful.  Thanks to everyone who came and shared and participated in this community event.

I shared some of Oxfam's experiences in upgrading to PeopleTools 8.53 and my presentation can be accessed here.  

If anyone else is doing or about to start doing a PeopleSoft 9.2 or PeopleTools 8.53 Only upgrade then please get in touch.  Always happy to exchange ideas and share experiences.

Thursday, 3 October 2013

How to put PeopleSoft credentials into SOAP request

If you have the User/Password Required checked on for a SOAP based Service Operation then you'll need to supply the PeopleSoft user credentials in the SOAP header request.  This is what the wsse section of the SOAP request looks like.  You'll likely want to enable https so that your plain text username and password is encrypted.

PeopleTools 8.54 news from OOW

Some more news from OOW 2013.  This one (like most news on future releases) comes with Oracle's usual Safe Harbour Statement.

Application Designer in PeopleTools 8.54 will have auto-code-complete in the PeopleCode editor.  If you can't wait for this long awaited feature then some text editors (like Ultraedit ) not only have syntax highlighting but a limited version of code completion as well.

Monday, 30 September 2013

REST Web Services - PART 1

PeopleTools REST Web Services Part 1

I recently presented at Oracle OpenWorld on the subject of REST web services in PeopleSoft.  REST based web services were introduced in PeopleTools 8.52 and I'm hoping this series of blog posts will help newcomers to both Web Services and REST.

What is REST?

REpresentational State Transfer (REST) is a style of doing Web services that is becoming increasingly popular among web developers due to it's simplicity over SOAP and other methods.

REST follows 4 basic principles
1) All content has a unique id by which it is referenced (URI)
2) services are invoked using standard WWW operations of GET, POST, PUT, DELETE
3) all REST services are stateless in that they retrieve a representation (copy) of the content requested
4) REST is synchronous only. Designed for point to point communication

You can invoke a REST web service simply by using it's URI.  For example an example REST web service to GET PeopleSoft operator details might look like this.



Understanding the PeopleTools Document object is necessary to building REST based web services in PeopleSoft so let's cover some of the basics.

What is a Document?

Documents represent a hierarchical data structure a lot like a Rowset object.  They have a logical representation and a physical representation in the form of XML, HTML and JSON (from Tools 8.53).

Documents can be grouped together in a Package and like other Integration Broker object definitions can be versioned.

Document Data Types

A document is a tree structure representing data.  As such, every document has ROOT element that is the name of the Document.

There a four basic data types
*Primitive.  An element that has one of the simple data types of integer, string, character, date, time, etc.
*Compound.  An element that contains 1 or more primitives (think Record definition)
*Complex Primitive Compound.  A primitive element that has attributes. (think XML attributes ElementValue )
*Collection.  An element that is a repeating group of Compound and/or Primitives. (think Rowsets)

What Role do Documents play in REST Web Services?

A Document is required to collect the inbound URI parameters from a REST web service call.  This is done by mapping the URI parameters to document element names.  This is called the Document Template.

The next post will show how to create Service, Service Operations and Handlers.
All the code used in this series on REST can be downloaded from here

Wednesday, 25 September 2013

CON7553 PeopleTools REST: Everything you need to know

Thank you to everyone that attended my session on PeopleTools REST web services this afternoon. I hope you found it useful.

If you missed the link to download the App Designer project containing all the examples I talked about then here it is.  I hope you find the code samples in here useful.

Well for all those who are already feeling weary from OpenWorld Conference fatigue .... I hope you got enough REST from my presentation.

Tuesday, 24 September 2013

OOW 2013 Monday

I can't believe it's a year since I was last here in San Francisco for Oracle OpenWorld conference.  Great to be here with other Oracle technologists, PeopleSoft users and the staff from the PeopleSoft Division of Oracle.

Not all work at OpenWorld
This annual event run by Oracle attracts over 50,000 customers, partners and Oracle staff and it's organisation is breathtaking.  It's a great place to network, to learn about existing and new technology and applications.  I always leave inspired with new ideas, solutions and encouraged by the strong community of people that are always so willing to share their knowledge.  I heard today that of all the thousands of sessions being run this week at OpenWorld that the PeopleSoft ones always feature prominently in the Top 10 best attended.  Shows how strong the product and it's associated community is.

Paco Aubrejuan, (Senior VP PeopleSoft Enterprise Development) gave a great roadmap session covering high level overview of what's coming in future releases.  He was even brave enough to throw in a few live demos and just enough information on MAPS (Mobile Applications for PeopleSoft) and the Next Generation User Interface (NUI) to leave me intrigued enough to head straight  for the demo grounds to find out more.  

My favourite quote of the day was from Paco in his PeopleSoft Roadmap session "The pressure [on companies] to do things cheaper is hockey sticking".

Oracle has a proven track record for year on year investment in developing PeopleSoft software and I left the Roadmap session with the strong impression that this was going to continue ( " least until 2027" quotes Paco) .  Whatever the amount Oracle is investing in the PeopleSoft Apps and Tools the developers are continuing to pack in more and more awesome new and innovative features.  More details to follow soon.
Paco Aubrejuan, SVP PeopleSoft Enterprise Develoipment

Saturday, 21 September 2013

Integration Broker Gateway default Application Server

When an inbound integration does not specify an NODE then the message is processed by the Default Application Server.  This is an optional default found on the Gateway > Gateway Setup Properties.

I've noticed that some delivered Oracle images don't have the correct configuration for the default.

The Tools Release field must include the patch release number.

If this is not present or is incorrect then you'll get a null response when you invoke a service and an error is logged in PSIGW/errorLog.html (note: this is case sensitive).

Response in Google Chrome if PATCH is missing from Tools Release

IntegrationServiceClient: sendRequestToServer(). Invalid ToolsRel

Friday, 23 August 2013

Oracle OpenWorld 2013

I'm thrilled, once again, to be asked to present in the PeopleSoft stream at Oracle OpenWorld again this year.

My session this year will be looking at REST based web services in PeopleTools and will highlight the differences between the SOAP and REST based paradigms and explore the mechanics of building and providing REST based services in your PeopleSoft application.

I hope there'll something useful of everyone whatever your experience of web services or PeopleTools. Either way, it's always tough to pitch content in 50 minutes of session and still keep most people interested.

See you in Moscone West or on the PeopleSoft demo grounds.

Friday, 26 April 2013

UKOUG PeopleSoft Roadshow 2013

Good day in London with a capacity crowd of PeopleSoft customers, partners and Oracle staff for the annual UKOUG EMEA PeopleSoft Roadshow.

Featuring Marc Weintraub (Director, PeopleSoft Applications Strategy) and Jeff Robbins (Senior Director, PeopleTools Strategy) along with customers and partners talking about the value of the latest PeopleSoft and PeopleTools releases.

Here's a few one liners, facts and other interesting things that caught my attention during the day.

  • Oracle has 1,100 PeopleSoft staff in Applications and PeopleTools development team.
  • PeopleSoft applications have 37,000 person years of development effort invested.
  • Thomas Kurian (Oracle EVP Product Development) confirms that the PeopleSoft applications strategy is fully aligned with Oracles application strategy.
    • User experience
    • Capability
    • Lower TCO
    • Coexistance
  • Big messages from Marc Weintraub
    • Oracle offers choice
    • PeopleSoft customers are "fiercely loyal". Huge take up of 9.1 apps
    • PeopleSoft applications and tools are still receiving heavy investment
  • Key PeopleTools 8.53 features highlighted by Jeff Robbins
    • Search vs Menu Driven paradigm (object first then action)
    • Guided navigation (Activity Guides and Train Stop processes)
    • Embedded actionable analytics (Pivot Grids)
    • User productivity (Dashboards, Work Centres)
    • Mobile applications for mobile workforce (using iScripts, HTML5)
    • PeopleSoft Upgdate Manager (using 8 week cycle fully patched and functioning VMs) Very nice!
  • PeopleTools Future?
    • Next Generation UI for mobile and desktop
    • Extending functionality of Pivot Grid and Search
    • Support for Endeca
    • Make TCO of PeopleSoft on Private Cloud lower than SaaS.
    • Time Ten access for nVision

Wednesday, 27 March 2013

UKOUG PeopleSoft Roadshow 2013

This promises to be another really useful day networking with oracle and PeopleSoft customers and partners. 

Featuring Marc Weintraub (Director, PeopleSoft Applications Strategy) and Jeff Robbins (Senior Director, PeopleTools Strategy) sharing hot off the press news on PeopleSoft 9.2 and PeopleTools 8.53.

Register early to avoid disappointment

Hope to see you there.

Wednesday, 27 February 2013

Detecting CAPS Lock on PeopleSoft signon page

Many application warn you that CAPS Lock is on when entering case sensitive passwords.  A very useful feature.

We decided it would be nice to have this on our PIA signon page too.

This is done through some simple Javascript code on the signin.html page.

Inert this function (directly or via a linked .js file) into your WEB-INF\psftdocs\[sitename]\signin.html

function CheckCapsLock(event){
 //identify the ASCII code of which key was pressed
 keyCode = event.keyCode?event.keyCode:event.which;
 //Is this shift key on
 shiftKeyOn = event.shiftKey?event.shiftKey:((keyCode == 16)?true:false);

 //If the key pressed is A - Z and the shift key is NOT pressed then CAPS lock must be on.  
 //or If the key pressed is a - z and the shift key IS pressed then CAPS lock must also be on.  
 if(((keyCode >= 65 && keyCode <= 90) && !shiftKeyOn)||((keyCode >= 97 && keyCode <= 122) && shiftKeyOn))
  document.getElementById('oxf_warning').style.visibility = 'visible';
  document.getElementById('oxf_warning').style.visibility = 'hidden';

Then add a call to CheckCapsLock into the INPUT tag for the password field.

Finally, place a "CAPS Lock is on" warning message somewhere on the signon.html page.

This should work on any PeopleTools release and has been tested on Chrome, FireFox and IE.

Credit to Oxfam Developer Angela McKenna for these code snippets.