Help Please! The UKOUG Partner of the Year awards July 31, 2014

We’d really appreciate your help. But first, a bit of background:

The Partner of the Year awards is an annual awards ceremony held by the UK Oracle User Group. It allows customers to show appreciation for partners that have provided a service to them over the previous 12 months. As you would imagine, being voted a winner (for the categories that you operate in) is a wonderful accolade as it’s the end-users that have spoken.

Cedar Consulting has a long history of success in the competition, reflecting our long standing relationships with our clients. I wasn’t going to ask for votes this year, however I notice that many of our competitors are filling Twitter and LinkedIn with pleas so I feel that I should also ask for your vote.

If you’re an existing Cedar client site we’d love your vote. Also, if you are a recipient of any other Cedar service – and I guess here I’m talking about the free PeopleSoft and Fusion Weekly newsletters that we send out – we’d be very grateful if you gave 3 minutes of your time to vote for us.

What we’d like you to do:

1) Go to: http://pya.ukoug.org/index.php

2) Fill in your company name, first name and surname. Then click Next.

3) Enter your email address in both fields, then click Next.

4) Select any checkboxes if you want ‘follow-up communications’ from the UKOUG, or leave all blank, and click Next.

5) Select Cedar Consulting from the drop-down, and click Next.

6) On the PeopleSoft page, select the Gold radio button on the Cedar Consulting row (note, it’s the 3rd column!), then click Next.

7) Repeat by selecting the Gold radio button on the Cedar Consulting row of the Fusion page, then click Next.

8) Click Submit.

And you’re done. Thank you very much. If you want some gratitude for your 3 minutes of effort drop me an email and I’ll thank you personally!

Generating a custom Org Chart in PeopleSoft July 8, 2014

This week we have a second guest-post from Richard Yip. Richard is a PeopleSoft HCM & Payroll Technical Consultant at Santander Bank here in the UK. He is a long-term PeopleSoft techie and a regular at the UKOUG conferences.  I’m delighted to be able to give him a conduit through which to share some of his good work.

Richard’s previous post can be found here.

Custom Organisation Charts in PeopleSoft

In the PS_EMPLOYEES table, there is a custom field called SUPERVISOR_ID. This is used to connect the employee to the supervisor or line manager. This is similar to the REPORTS_TO field in PS_JOB.

I developed this after toying with the GOOGLE API Organisation Chart. Generating the boxes was straight forward enough, so the trick was to understand how to generate the connecting lines.

I also included some Javascript to make the images appear when the box is clicked and disappear when it is double-clicked. The images are from the PS_EMPL_PHOTO, so a data URI with Base64 encoding is used.

Default Appearance

Expanded to show photos

Richard has kindly shared all the code required to get this working. See Generate a custom Organisation chart from ps_employees for the listings.

New Pastures June 24, 2014

I try to keep the content on here focused on the products and implementation tips however I hope you’ll indulge me with one personal post.

After six and a half enjoyable years I have left Succeed Consultancy. I’m leaving behind a lot of talented colleagues and great friends, however for reasons that I don’t want to bore you with it’s time to move on.

As of yesterday I’ve started work for Cedar Consulting. One of the largest the ‘tier 2’ PeopleSoft consultancies in EMEA.

Cedar have been running – in one form or other – for nearly 20 years and have an impressive list of PeopleSoft implementations, upgrades and support/hosting clients. There are few UK PeopleSoft clients who haven’t engaged Cedar at one point or other. As well as their large team of UK consultants they have a number of offices spread globally and a solution centre in India.

Importantly for me, Cedar also have a strong focus on Fusion and already have both a live Fusion client under their belt and the UKOUG Fusion Partner of the Year gold award.

This career move also means that the branding of the PeopleSoft and Fusion Weeklies will change. I’d to thank Succeed for sponsoring the newsletters up to this point and I’m grateful to Cedar for agreeing to sponsor it going forwards. You should notice a rebrand in this week’s editions.