Duncan Davies

Subscribe to Duncan Davies feed Duncan Davies
A PeopleSoft Tips and Tricks Blog
Updated: 1 week 1 day ago

PeopleSoft UI Showcase

Tue, 2019-07-30 06:00

While commuting this morning I listened to Dan & Kyle’s podcast with Matthew Haavisto and they discussed that fact that the Fluid UI has been around for a while (since Tools 8.54, which was more than 5 years ago). It struck me that most clients will have adopted Fluid by now and branding is getting easier so there should be lots of good examples out there.

My mind drifted back to the company I worked for previously where we had a ‘UI Showcase’ of PeopleSoft branding eye-candy to drop into presentations to get people dreaming of the ‘art of the possible’.

The UI Showcase really started when we wanted to share the work we did for Pret a Manger, the high-street retailer. It looks really dated now, but back in 2009 it was pretty exciting.

The burgundy tabs across the top were role-based homepages, the chunky white buttons at the top were tiles that accessed Nav Collections and the semi-transparent alert boxes over the lower section of the image were alerts where the stars changed depending upon different PS query thresholds. Much of this has parallels to the Fluid UI we have today.

On the Podcast, Matthew said that he’d seen some pretty creative uses of Fluid UI but I’m not sure many of those customers who’ve really pushed the boundaries have shared their work publicly. I’d really like to see them, and I bet many others would too. Maybe we could do something similar to a PS UI Showcase again, but on a wider scale?

I thought perhaps I’d start a series of posts, each highlighting a customer who has done something impressive and eye-catching with Fluid might be fun. Then the community would have something to flick through for inspiration when designing your latest refresh. Get in touch (duncan@peoplesofttipster.com) if you’re proud of your Fluid deployment – it can be anything, a cool tile, a great overall design, etc – and we’ll sort out how to feature you.

I’m Kyle Benson and this is how I work

Fri, 2019-07-12 06:00

I’ve not blogged on this site for a while so it takes a special post to break the hiatus. I’m delighted to finally be able to share the “How I Work” entry for Kyle Benson, one half of the all-conquering PSAdmin.io duo. Kyle and Dan are super-busy, splitting their time between PeopleSoft consulting and the PSAdmin.io slack community, their Podcast, their conference and their website.  I’m thrilled that he has added his profile to our ‘How I Work‘ series.

kyle-hike

Name: Kyle Benson

Occupation: Independent PeopleSoft Consultant and Co-owner of psadmin.io
Location: Minneapolis, MN
Current computer: Dell Precision 5510
Current mobile devices: Pixel 2
I work: To keep from getting bored. I have a ton of fun solving tough problems and optimizing things.

What apps/software/tools can’t you live without?

Besides your phone and computer, what gadget can’t you live without?
Saying I “can’t live without” this is overstating it, but I love my home automation gadgets. I have been slowly adding more and more to my home. Lately my pace has slowed down so my family can keep up with my craziness. I’m currently using a SmartThing Gen. 1 HUB and I’m liking the ecosystem.  That reminds me, time to upgrade!

What’s your workspace like?
I split time between client sites and my home office. I like to use a standing desk and keep it rather tidy. I love my ultrawide monitor and have a “studio” step for creating psadmin.io content.

kyle-desk

What do you listen to while you work?
I love to put on mellow, ambient, downtempo style music. I often listen to the same playlist on repeat for months. Something about the relaxing, repetitive sounds helps get me in “flow” faster. The artist Blackmill really started me down this road. The current playlists I’m listening to on Spotify are ‘Atmospheric Calm’ and ‘Soundscapes For Gaming’.

What PeopleSoft-related productivity apps do you use?
I love Phire for development and git for DPK/admin scripts. Having the history and flexibility to migrate is so nice. Using psadmin-plus helps a lot, too!

Do you have a 2-line tip that some others might not know?
Make sure you are using aliases so you aren’t wasting time typing! Here is a short list of aliases I use often, mostly related to changing directories.

  • cddpk
    • Change to the DPK base directory
  • cdcfg
    • When using multiple $PS_CFG_HOMEs on a server, change to the config homes base directory
  • cdweb $domain_name
    • Change to the PORTAL.war directory of a domain
  • pupapp $environment
    • Run puppet apply for an $environment (ie. production)

What SQL/Code do you find yourself writing most often?
Currently I’ve found myself living in the browser development tools. I’ve been exploring some of the new JavaScript that Fluid and Unified Navigation introduces. I do a lot of debugging, playing in console, etc to find out how some of these features work. This is all pretty complex stuff and you can really get lost down the rabbit hole.

What would be the one item you’d add to PeopleSoft if you could?
Current CPU archives in DPK.

What everyday thing are you better at than anyone else?
I love riddles and puzzles. I’ve been really into escape rooms this past year, too.

How do you keep yourself healthy and happy?
Getting outside with the family year round is key. Living in a place like Minnesota, you learn a lack of vitamin D and cabin fever is no joke. Walking, hiking, biking in the summer. Biking and cross country skiing in the winter. Also, the family heads up to the North Shore of Lake Superior every few months. These weekend getaways are always a great recharge.

What’s the best advice you’ve ever received?
Find a job you enjoy doing, and you will never have to work a day in your life.

Fusion and in-app Guides

Fri, 2019-02-01 05:00

I’ve heard a couple of clients recently mentioning that they’d like to have some kind of in-app guide setup to walk their self-service users through common tasks in Fusion, so I thought I’d investigate.

There are quite a few companies that operate in the same area, here are the ones that I found with a short googling session:

ServiceCostAppcuesVariesIridizeAcquired by Oracle, now known as Oracle Guided LearningMyGuide$1-3/user/monthPendoVariesToonimoRequest a QuoteUserlaneRequest a QuoteWalkMeRequest a QuoteWhatfixRequest a Quote

There are also a couple of Open Source alternatives Joyride and Bootstrap Tour. Although they’re free to use, you’re going to need to code to get anything up and running so they’d be significantly higher maintenance.

Over the next few weeks I’ll investigate some of these options and post the results.

I’m Brad Carlson and this is how I work

Wed, 2018-07-04 05:00

This week we’re featuring another of the mainstays from the PSAdmin.io slack community  – Brad Carlson. He is a regular in the community and another member of the seemingly endless ‘PeopleSoft Minnesota Mafia’. Brad is a frequent guest on their PodCast talking about his IB Monitor tool and discussing the highly efficient application of CPU patches. I’m thrilled that he has added his profile to our ‘How I Work‘ series.

bridge

 

Name: Brad Carlson

Occupation: Oracle DBA/PeopleSoft Admin
Location: Lino Lakes, MN
Current computer:
At work:
Microsoft Surface Pro 4: Core i7, 16GB RAM, 256GB SSD with 24” and 17” Dell Monitors

At home:
Macbook Air 13”, Core i5, 8GB RAM, 128GB SSD, and
AMD Ryzen 1600x, 8GB RAM, 256GB/4TB (Media PC)

Current mobile devices: Samsung Galaxy s5. Yes, it’s old, but it still works.
I work: Intently

What apps/software/tools can’t you live without?

  • TOAD and SQLDeveloper for sure.  Each has their strengths.
  • UltraEdit/UltraCompare
  • Visio
  • PowerPoint

Besides your phone and computer, what gadget can’t you live without?
Probably our Keurig.

What’s your workspace like?
It’s nothing fancy, but it works for me. I’ve got a space for my Surface, a 24” Dell monitor as my primary screen, and a 10+ year old 17” Dell monitor to the side which hasn’t been turned on in a very long time. My cube walls are plastered with pictures of my wife and son, along with various artwork my son has produced over the years (DD: plus a picture of Bill Murray, it seems!). It’s a bit cluttered at times, but I try not to let it get too out of hand before I straighten things up.

work

 

What do you listen to while you work?
Almost anything, except Country. I have playlists that range from Bach to Fleetwood Mac to Slayer, sometimes even in that order. You’ll find lots of Metal (Megadeth, Metallica, Slayer, Linkin Park, etc) and Industrial (Ministry, NIN, etc) bands in my music collection, and I find those keep me energized at work.

I’m also a big fan of Rob Scallon’s unique covers, and will stream some of those from YouTube periodically.

What PeopleSoft-related productivity apps do you use?
Honestly, I am not in App Designer much anymore. I still use Change Assistant and Data Mover occasionally.

Most of my admin work would be more on the server side, so psadmin is a frequent tool. When I wear my DBA hat, I spend most of my time in TOAD, SQLDeveloper, and OEM.

Do you have a 2-line tip that some others might not know?

PS SQL:
Do not ignore Set ID
Or Business Unit.

Sorry… I guess a Haiku is 3 lines.

What SQL/Code do you find yourself writing most often?
It might sound crazy, but I love tuning SQL. If we have performance issues with code, I’m usually game for taking a look.

I enjoy writing SQL/scripts to automate common tasks. We’re really into automation here at the University of Minnesota. A personal favorite was building a process to refresh a full PeopleSoft environment by issuing a single command.

I also try to find time to build tools, like the IB Monitor, to help the teams here. I tend to gravitate to Java for those.

What would be the one item you’d add to PeopleSoft if you could?
Even though I don’t use the tools much anymore, I’ve been wondering why PeopleSoft hasn’t moved the Application Designer functions into the online application.

What everyday thing are you better at than anyone else?
Being me. Hands down. It’s not as easy as it might look.

How do you keep yourself healthy and happy?
I still play hockey twice a week (all year) as a goalie.

I also enjoy bowhunting and going to the archery range with my son. In fact, it’s that passion which led to my writing an application for hunters (GameTracker: The Hunting App on Android and iOS). Developing that was a fun learning experience.

Travel with my wife and son also keeps me pretty happy. We typically do a vacation each year, and it usually involves the outdoors/hiking.

At home, we have a koi pond in our back yard. The sound of the waterfall, and the tranquillity of the pond are very relaxing.

What’s the best advice you’ve ever received?
My dad always told me, “Work with your brain, not your back”.

I’m Charlie Sinks and this is how I work

Wed, 2018-05-30 06:00

This week we’re featuring another of the mainstays from the PSAdmin.io slack community  – Charlie Sinks. He is a regular in the community and a frequent guest on their PodCast giving UMRUG recaps and discussing automation. He also presented at the inaugural PSAdmin.conf on Implementing Rundeck with PeopleSoft (the recording is available here and is well worth an hour of your time). I’m thrilled that he has added his profile to our ‘How I Work‘ series.

charlie 2

Name: Charlie Sinks

Occupation: Sr. Software Engineer and PeopleSoft Admin at Andersen Windows
Location: Oak Park Heights, MN
Current computer:
At work: Dell Latitude E7470 laptop running Windows 10.
At home: a PC that I built from bits and pieces currently running Windows 7 and Ubuntu Linux
Current mobile devices: Motorola Moto G4 Plus and a cheap Timex wristwatch
I work: Fervently

What apps/software/tools can’t you live without?

  • PeopleSoft Deployment Packages (DPKs) and Puppet – I can’t even imagine deploying PeopleSoft environments and maintenance the old way anymore. It’s easy to get hung on the things we wish the DPK did better, but it really opened the door to automation in the PS Admin world for those of us who weren’t already using Puppet, Ansible, etc.
  • Rundeck – the ability to execute tasks – from simple commands to complex orchestration – on any number of remote servers has helped us go a long way towards automation. For example: single-click CPU patching on all of our non-Production servers at the same time. Even for simple service restarts, it’s so much easier to do it from a dashboard in Rundeck.
  • BeyondCompare – It’s crazy how many file formats this thing can compare. Best compare utility I’ve come across.
  • Password Safe – Way better than remembering a hundred passwords, and way WAY better than keeping them all in a spreadsheet. Also, using a password manager encourages me to use very long, complex passwords since I’ll never have to remember or retype them. Password Safe is great at storing passwords for all kinds of accounts, but doesn’t have good web browser integration for website accounts. So for that I use…
  • Dashlane – password manager with great browser integration for website accounts. Not as great for any other type of account. For that, see above.
  • Notepad++ / Visual Studio Code – For years I swore by Notepad++ because of its great plugins, macros, and language support. I still think it’s great, but I just discovered Visual Studio Code. That has everything I like about NP++ plus more. Much more streamlined extension and language support, themes, and its integration with Git is phenomenal. And it lets me turn on Vim keymapping with a single keystroke! I have a new favorite now.
  • MobaXterm – a nice upgrade from using a terminal like PuTTY for administering Linux servers. I haven’t begun to use all of the features this tool has, but I was quick to discover that it comes with a suite of simple games. I’m not really sure why… but it’s best not to question some things.

Besides your phone and computer, what gadget can’t you live without?
My coffee-maker. I use an Aeropress at home, and a French press at work. I always have a coffee mug in my hand. I may have a problem.

What’s your workspace like?
If I’m being honest, a bit messy with Post-It notes all over the place and the occasional coffee-mug ring décor. I write Post-It notes to remind myself of all sorts of things and try to put them in obnoxious places where I can’t ignore them. Yet I still manage to ignore most of them… I guess I’m so good at tuning things out that I can’t even trick myself.

workstation2 2

What do you listen to while you work?
Blues, jazz, electronica, old-school hip-hop, skiffle – it really depends on my mood and what type of work I’m doing. A lot of Tom Waits lately.

What PeopleSoft-related productivity apps do you use?
Change Assistant (for our internal releases in addition to the rest of it), DPKs, and puppet. I also like the Chrome extensions PS Utilities and PSChrome.

Do you have a 2-line tip that some others might not know?
When you’re developing or testing, instead of clearing your cache hit Ctrl+Shift+N in Chrome to open Incognito mode.

That was one line, can I do another one? If you’re newly upgrading to PeopleSoft 9.2, take some time to build out some navigation collections and homepage tiles. It’s really easy, will make your life easier, and will impress your end-users. It’ll also limit how often you have to use the new Nav menu… ick.

What SQL/Code do you find yourself writing most often?
Effective Date joins. Amiright?

What would be the one item you’d add to PeopleSoft if you could?
Open-source development! At least for the DPKs. Come on, Oracle. Let us fix the things we complain about so we can stop bothering you about it.

What everyday thing are you better at than anyone else?
No matter how good you are at something, there’s always somebody who’s better at it… so this is hard to answer. I do have a really high tolerance for eating extremely spicy food.

How do you keep yourself healthy and happy?
Spending time with my wife and three kids, reading, and getting out in nature.

What’s the best advice you’ve ever received?
Treat others as you would like to be treated, and always consider the other person’s point of view. Along those lines is my favorite Jack Handey quote: “Before you criticize someone, walk a mile in their shoes. That way, you’ll be a mile from them, and you’ll have their shoes.”

I’m Wayne Fuller and this is how I work

Wed, 2018-05-02 05:00

This week we’re featuring another of the ‘leading lights’ from the PSAdmin.io slack community  – Wayne Fuller. He is a regular in the community and a frequent guest on their PodCast discussing running large scale PeopleSoft while at Wells Fargo (amongst other places). He also presented at the inaugural PSAdmin.conf on The Future of PeopleSoft Administration (the recording is available and is well worth 30 minutes of your time). I’m thrilled that he has added his profile to our ‘How I Work‘ series.

Name: Wayne Fuller

Occupation: Application Engineer
Location: Minneapolis
Current computer: HP EliteBook
Current mobile devices: Nexus 5X
I work: Proactively

What apps/software/tools can’t you live without?
Any app that I can learn quickly that saves me time, i.e. Beyond Compare etc.

Besides your phone and computer, what gadget can’t you live without?
My refrigerator.  It keeps the beer cold.  Also my Kindle because you have to have something to read while you are sipping a beer.

What’s your workspace like?
Just a small open cube when I actually go into work. Since I am part time I don’t have a permanent workspace. When I work from home I sit at the kitchen counter.

What do you listen to while you work?
Other people whine.

What PeopleSoft-related productivity apps do you use?
Is Change Assistant a productivity app? How about the images? Integration Broker? I know, event mapping.

Do you have a 2-line tip that some others might not know?
MOS actually can answer questions. Sometimes you just have to read between the lines.

What SQL/Code do you find yourself writing most often?
Code to query PeopleTools tables to discover where and how some of the new objects are stored. Useful for behind the scenes compares.

What would be the one item you’d add to PeopleSoft if you could?
A guarantee of longevity.

What everyday thing are you better at than anyone else?
Pretending that I am good at troubleshooting by using Google search.

How do you keep yourself healthy and happy?
I work 2 days a week and don’t think about work when I am at home.

What’s the best advice you’ve ever received?
Never be afraid to give your opinion on something you are expert in. You likely know better than your boss as you are the one who works with the stuff daily. He should value, nay require your opinion on things that you do.

I’m Jason Fletcher and this is how I work

Tue, 2018-03-06 07:00

To anyone who frequents the PSAdmin.io slack community (and that’s almost 500 people) the name Jason Fletcher (or fl3tchr) will be one that’s instantly familiar. He is not only seemingly ever-present, but also dishes out rapid-fire PeopleSoft advice, humour, gifs and good-natured sarcasm in more-or-less equal measure. I’m thrilled that he has added his profile to our ‘How I Work‘ series.

Name: Jason Fletcher

Occupation: It breaks, I fix. (AKA administrator for the City of Albuqerque)
Location: Albuquerque, NM
Current computer: My workstation is a HP ZBook 15″
Current mobile devices: iPhone 6s Plus (gotta have the larger screen for when I have to RDP into work)
I work: Humorously

What apps/software/tools can’t you live without?
1) Beyond Compare – So much better than Compare Reports.  So much.

2) EditPad Pro – It’s been my text editor for over a decade.  Handles gig sized files without much issue.

Besides your phone and computer, what gadget can’t you live without?
None.  I’ve been accused of loving my computer more than my wife.

What’s your workspace like?
Workstation is an i7 with 8 GB RAM and docked to 2×24” monitors. Yes, it is a nice view.

What do you listen to while you work?
Depends on the intensity of the concentration.  Routine work is subject to podcasts (a large amount of the TWiT network & Tom Merritt) followed by rock and instrumental music.  Concentration requires instrumental or even white noise. (SimplyRain is a great app for rain noise.  Which I don’t hear much of in the high desert.)

What PeopleSoft-related productivity apps do you use?
1) Slack – psadmin.io.  It’s like a responsive MOS.

2) SQL Developer is my go-to SQL client.

3) Oracle Enterprise Manager for troubleshooting database performance.

Do you have a 2-line tip that some others might not know?
I’ve put this one in psadmin’s slack: in Windows Explorer, typing cmd (or powershell) in the address bar opens a command prompt at that location.

What SQL/Code do you find yourself writing most often?
A lot of effdt/seq SQL or SQL that joins psoprdefn & psroleuser.

What would be the one item you’d add to PeopleSoft if you could?
git or some other integrated versioning system.

What everyday thing are you better at than anyone else?
Beats me.

How do you keep yourself healthy and happy?
I’m currently a 1 gup in taekwondo (red belt with black stripe), which is the first rank below a 1st degree black belt. The outdoors are great in New Mexico most of the year so I do quite a bit of hiking. At nights I spend a lot of time playing Overwatch.

What’s the best advice you’ve ever received?
Love the Lord God with all your heart and soul and love your neighbour as yourself.

Larry’s Keynote – The World’s 1st Autonomous Database

Mon, 2017-10-02 07:04

Larry Elison came on stage last night to pumping rock music and laid out the details on Oracle’s latest big product unveilings – Oracle Autonomous Database and Highly Automated Cyber Security. Wearing a black polo shirt, faded blue jeans and a pair of ASICS running shoes he was relaxed and candid, obviously talking in an area that is comfortable for him.

Cyber Security

This session was mostly on the Autonomous Database, however Larry spent some time striving to convince us all that the safest place to store your data is in an Oracle database – where they do everything they can to prevent human intervention, and therefore the risk of human error. The upcoming Cyber Security product – the subject of his Tuesday keynote – is designed to detect threats when they first occur, and then handover to the database to automatically apply patches rather than wait for humans to notice the breach, schedule downtime and then implement new security measures or patches. He made the point that the worst security breaches in history were made after the patches to fix the vulnerability being exploited were available – the issue was that the patches weren’t applied.

Much of what he said must be ringing in the ears of Deloittes after their cyber leak– where the breach went unnoticed for months and lax security processes allowed hackers to easily access customer data.

It seems that much of the cleverness behind these advances is machine learning, where the system watches events and looks for patterns that do not fit normal usage – e.g. someone logging in through an IP address on the TOR network, or from an unusual country.

Autonomous Database

Larry claims that the new 18c Autonomous Database reduces 100% of the human labour needed to run a database – it automatically provisions, upgrades, patches and tunes itself while running. The SLA guarantee is 99.995% – meaning less than 30 minutes downtime a year (planned and unplanned).

Adding to this, he added that it would run at 50% of the cost of Amazon and that Oracle would write that into your contract. The database is called 18c due to the calendar year, however the data warehouse version will be available in Dec 2017, with the OLTP database coming in June 2018.

Larry then continued with several examples of Oracle pricing being cheaper than AWS due to Oracle’s faster processing (both Oracle on Oracle Public Cloud vs Oracle on AWS and Amazon’s DB on AWS)… “If you want the extra security, if you want the extra automation that Oracle provides, you’ve got to be prepared to pay less.” Of course vendor produced comparisons should always be treated with a level of scepticism, however if Oracle are willing to write the savings into your contract then that does underline their claim.


Interesting PS Roadshow / Exec Dinner Snippets

Thu, 2017-05-04 09:00

We recently held the annual PeopleSoft Roadshow and Executive Dinner (summary here) and I wanted to highlight a couple of observations that I think are important enough to be revisited:

Fantastic UI

While Marc was demoing some new functionality it struck me how big a stride the PeopleSoft UI has taken over the last few years.

If you’d shown me this picture a few years ago I’d have refused to believe that it was PeopleSoft. Very few applications can boast a UI as attractive as this.

Selective Adoption is being Aggressively Adopted

Julie Alonso showed this slide, detailing how many customers are really making the most of Selective Adoption.

You might need to click these to see full-size, but let me highlight the key point. The right-hand pie-chart shows that 31% of customers are ‘staying current’ – i.e. doing a get current 4 times a year! A further 25% are getting current twice a year. So more than half of customers are getting current at least twice annually. I think this is really tremendous take-up of the benefits of Selective Adoption – and the PeopleSoft team must be delighted. I had fully expected most customers to lapse into an annual update.

 


PeopleSoft Roadshow and Executive Dinner

Wed, 2017-05-03 08:00

Two great events took place at the end of April – the UKOUG PeopleSoft Roadshow and the annual Cedar PeopleSoft Executive Dinner. Marc Weintraub and Julie Alonso spoke at both events so I’ve combined the highlights into a single post covering PeopleSoft improvements (including the new Onboarding module), PeopleSoft customer numbers looking strong, extension to the Support end date and more.

The full post can be found on the Cedar Consulting blog, here.


Come to the UKOUG PeopleSoft Roadshow

Wed, 2017-04-19 08:16

The UK Oracle User Group PeopleSoft Roadshow is nearly upon us. It’s my favourite PeopleSoft event in the UK’s calendar as you know that everyone there has a focus on PeopleSoft and the agenda is always really strong.

It’s 26th April (yes, a week today!) in the Crowne Plaza, London – the same as last time, which was a great venue.

Oracle US Speakers

In terms of Oracle speakers, we’re spoiled this year with both Marc Weintraub and Julie Alonso presenting.

Marc Weintraub

Pretty much everyone should know Marc by now, and he’s always good value. He’s giving multiple sessions including a PeopleSoft Update, Modernising with Fluid, Fully Executing on Selective Adoption and PeopleSoft in the Cloud.

Julie Alonso

A new speaker to those who’ve only attended UK PeopleSoft events is Julie Alonso. She is Product Management Director within PeopleSoft HCM Strategy and the brains behind the monthly PeopleSoft HR Newsletter (if you don’t know what this is, either see Julie on the day or drop me a mail and I’ll link you up). Julie is presenting on The Power of PeopleSoft HCM.

It’s great that Oracle are supporting the event with two such speakers, and it’s wonderful to see a new face on the circuit.

Cedar Speakers

We’ve also got a couple of speakers from Cedar on the agenda.

Graham Smith

As with Marc, everyone should know Graham by now. He’s a rare blend of techie that’s been around PeopleSoft for long enough to know the history behind just about everything, but has such fantastic enthusiasm that he’s always trying the latest tools and techniques. Graham is talking about Selective Adoption and the Oracle Cloud.

Sarah Hurley

For those with excellent memories, Sarah has spoken at a PeopleSoft conference before (on a custom recruitment front-end that Cedar built for a client) however that was a few years back. Sarah has been busy managing some of Cedar’s PeopleSoft projects in the interim and is giving learnings from a Fluid implementation for a client – Fluid Development – Getting to Grips with a Different Skill Set.

Other Speakers

Check out the agenda for the full listings, but in addition to the above we’ve got Paul Smit from Oracle Netherlands, Malcolm Hewlett from Excel4Apps and Ken de Landro talking about Hays’ automated PeopleSoft testing investigations.

If the above sounds like the sort of content that would interest you – and there’s something there for pretty much everyone – it’d be great to see you there. Book here.


I’m Colton Fischer and this is how I work

Mon, 2016-12-12 08:00

The next profile in our ‘How I Work‘ series is Colton Fischer. Colton is one of the crop of new PeopleSoft bloggers bursting on the scene during 2016. His PeopleSoft Mods blog is a treasure trove of great content and if you’ve not been there before it’s worth scrolling back through Colton’s historical posts – as he doesn’t just look at existing delivered functionality but extends PeopleSoft in ways that it’s clear to see the business benefit, frequently explaining how you can get the same results.

colton_fischer

Name: Colton Fischer

Occupation: Application Developer at the University of Houston
Location: Houston, Texas, USA
Current computer: My desktop is a Dell Optiplex 9020 and my laptop is a Dell Precision 3510
Current mobile devices: Samsung Galaxy S5
I work: Eagerly

What apps/software/tools can’t you live without?
Snipping Tool – Helpful tool for when I need a quick screenshot to document or demonstrate something
VPN Client and Remote Desktop – I don’t work from home too much, but this is a lifesaver when I forget some files on my machine at the office
YouTube Mobile App – I am more of a visual learner, so I enjoy watching educational YouTube videos on my phone when I have some down time
ESPN Mobile App – Allows me keep up with collegiate and professional sports

Besides your phone and computer, what gadget can’t you live without?
I’d have to say my coffee maker. That thing gets me through each morning because I don’t know what I would do if I didn’t have my coffee.

What’s your workspace like?
I would say that my workspace is pretty basic. I will admit that it is not normally as clean as it is in this picture. Most of the work I do happens on my desktop computer. I use my laptop for running personal demo systems to do “experimental” development on. I also use the systems on my laptop when I do development that requires constant app and web server bounces so that I don’t bother anyone else.

desk

What do you listen to while you work?
I enjoy most all genres of music, but what I listen to while I work relies heavily on the type of work that I am doing. If I am doing something that requires me to think hard, I listen to soft acoustic guitar songs. If I don’t need to think too hard, then I mostly find myself listening to metal rock, punk rock, and occasionally dubstep.

What PeopleSoft-related productivity apps do you use?
I have App Designer, SQL Developer, and Chrome windows open at all times. I like to use Chrome add-ons or other web-based productivity apps. I use Advanced REST client for Chrome when I need to work with web services. When I need to quickly view some unformatted XML, I use an online XML viewer to format it for me. I often work with base64 encoded values, so I use an online base64 decoder to obtain the decoded values. I also use the Chrome DevTools to view the source behind fields on PeopleSoft pages.

Do you have a 2-line tip that some others might not know?
I am not sure how well-known this is, but I recently discovered that meta-HTML can be used in the message catalog. Using meta-HTML (or even regular HTML) in messages can allow for some cool configuration-based functionality.

What SQL/Code do you find yourself writing most often?
I usually write queries on the security tables that deal with roles and permission lists. However, here lately I have been writing some queries on the PSACCESSLOG and PSPTLOGINAUDIT tables. There is some really interesting information in these tables from a security perspective.

What would be the one item you’d add to PeopleSoft if you could?
I would like to see some built-in functionality to make it easier to identify sensitive data (bank account numbers, SSNs, etc.) fields in PeopleSoft.  It would be nice if the field definitions that are used to store\display sensitive data would have a setting to distinguish the level of sensitivity.  Having this information stored in the meta-data tables would allow for the ability to easily write queries to determine where in the application sensitive data is being exposed.  This would, in- turn allow for PeopleSoft security administrators to more effectively secure their PeopleSoft applications.

What everyday thing are you better at than anyone else?
I am not sure if I am better than anyone at this, but I am good at time management and not procrastinating.

What’s the best advice you’ve ever received?
I enjoy playing golf and tennis when I have someone available to play with. When I am solo and I want to do something physical, I usually go skateboarding. Something else that keeps me happy (but not so healthy) is playing Xbox.

What’s the best advice you’ve ever received?
The best piece of advice I’ve received is to start each day fresh and with a clean slate regardless of how the previous day went.  It’s easy to carry struggles and frustrations with us from day to day, but it only hinders your productivity and outlook.


Paco on Continuing Investment in PeopleSoft

Tue, 2016-11-08 05:00

There’s a great episode of Marc Weintraub’s PeopleSoft Talk interview series, featuring a 30 minute discussion with Paco Aubrejuan. There’ll be some great points for everyone to take away from it, however here are my highlights:

On the current Support End date of December 2027:

There’s no plan on ending support for PeopleSoft then, it’s actually not that important a date. It happens to be the date right now that our lifetime support goes to … that probably won’t be the case and as we get closer to that date the plan is to move those dates out.

On Continued Investment:

For me investment and support are one and the same. It’s hard to support applications without continuing to enhance them as well. We’re planning to support and enhance them through that date.

On Fluid Adoption:

We have 2-300 customers who are live on it, and many of whom aren’t live with just a few applications but with Fluid across the board. We’ve got to that hockey stick period in terms of adoption where the majority of our customers who are doing projects or upgrades are deploying Fluid.

On replacing SES with Elasticsearch:

“it’s easier, cheaper, faster, better for customers to run Elasticsearch versus SES”

plus lots more on Cloud, Fluid Approvals and Selective Adoption. It’s well worth a watch:

 

 


PeopleSoft – What Does The Future Hold?

Wed, 2016-09-14 09:00

In an earlier post titled Banishing PeopleSoft Myths I shared my perspective of the current state of the PeopleSoft product and marketplace. I thought it’d be an interesting exercise to try to look forwards and to define what I think the future might hold for the product line. Some of this might be a little off-target, some might be a mile off target and some I might have changed my mind on if you ask me next week, but hopefully it starts some discussions.

PeopleSoft Moves to The Cloud

An easy one first. There’s a strong push to move to The Cloud and that should be apparent to pretty much everyone. There are some compelling success stories for PeopleSoft in the Cloud, customers have gained huge performance oracle-public-cloudincreases and flexibility in infrastructure, as well as saving money. So far these success stories have been on AWS, and – to a lesser extent – on Azure, however Oracle wants a piece of that pie now. The Oracle Compute Cloud should be an option whenever there’s a discussion on Cloud hosting (and this discussion should be held before any hardware refresh or major upgrade/get current).

Oracle is also making it easier for customers to move to The Cloud. The PeopleSoft Cloud Architecture is a set of functionality and tools that eases the transition, and it will be enhanced in future PeopleTools versions.

The PeopleSoft Marketplace Remains Buoyant

Cedar’s current experience is that there is a lot of activity in the market. Through the coming years we shouldn’t expect a huge number of net-new clients buying PeopleSoft, however existing clients are very loyal to the product and will continue to take advantage of the new features that are added to the product. It’s easy to imagine that over the coming years there will be widescale adoption of Fluid and Cloud Architecture.

More PeopleSoft Hosting

It’s becoming easier for customers to outsource the care of their PeopleSoft systems to partners – or, in the future, maybe even Oracle themselves. The Cloud makes the infrastructure significantly cheaper, and the PeopleSoft Cloud Architecture will make the administration simpler too. The PeopleSoft application will simply be provided to the client as a service, with all the hardware, DBA services and patcsa-image-hosting-iconhing performed by the partner for a flat monthly fee. PeopleSoft updates could also be rolled into this as Selective Adoption forms a key piece of the application maintenance model and lends itself very well to the Cloud hosting model.

There have been other advances in PeopleTools too that make it easier to reduce customisations – thereby making it easier for organisations to host multiple customer environments. The new related content event mapping functionality enables you to replace (some) customised code, and I’m sure the PSAdmin.io guys mentioned a technique for adding fields to a page via config instead of customisation (but I can’t find a link for it). The closer you are to vanilla the easier it is keep your application updated with the latest security, product fixes and new features.

Will Oracle provide “PeopleSoft as a Service”? Currently the answer – at least publicly – is ‘No’ however that might change over time. Oracle are moving their OnDemand offering over from physical hardware to Cloud infrastructure so they will host the servers and provide maintenance resources for clients.

PeopleSoft and Containers

The next evolution on from Virtual Machines is the use of ‘container’ technology. The problem with having a server containing multiple VMs is that each VM needs to have its own Operating System installed, kept patched and kept in sync. This – and the other software that could be shared – introduces a lot of duplication. Containers are like cut-down VMs, there is no OS within the container, just the application itself. Each of the containers shares the OS that’s installed on the host. There’s adocker
good intro to containers here.

Vendors have started to adopt this container technology – Docker is by far the most widely known – and it’d be no surprise if PeopleSoft starts to do the same. It’d be great to be able to drop in another App Server container without having to mess around with building one. The DPKs get us part way there, but this could be the next progression. First we’ll need to wait for Oracle Compute Cloud support for Docker first (or whatever snappy name Oracle gives to their Docker equivalent … maybe the ‘Oracle Enterprise Container Management Service’?)

Greater Fluid Adoption

Somewhere between 50-60% of customers are on v9.2, which means they’re either using or preparing to use Selective Adoption. Once a customer starts on the Selective Adoption path, they’ll find that the Fluid UI is the interface that updates and fixes will be delivered on. This will drive Fluid adoption. This is good for Self Service users as they’d typically benefit the most from a Fluid roll-out.

Although there is some pain involved in getting Fluid up and running all of the feedback that we’ve heard to date is that those who’ve made the jump are very happy with the results. Self Service users stand to gain the most as Fluid really makes PeopleSoft a lot more accessible to infrequent users.

The role of SysAdmin is Changing

The role of the PeopleSoft SysAdmin is dramatically different than it was 5 years ago. The advent of PUM, Selective Adoption, DPKs, Puppet and SES, and the imminent adoption of the Cloud Delivery Architecture and Elasticsearch have all shifted the landscape significantly.

Much of this is good news. For instance, Selective Adoption and DPKs have both made the SysAdmin’s life easier (once the toolset has been learnt). The future sounds like this trend will continue as Cloud Manager will allow one-click provisioning and refreshes of environments, and Elasticsearch promises to alleviate some of the SES headaches.

This greater functionality does come at a cost for the SysAdmin, and that is that there is a wider breadth to the set of tools that they are required to master. The days where the SysAdmin just needed to do installs and tuning have passed. This increased automation brings the requirement for DevOps SysAdmins – i.e. SysAdmins who are able to cut some code.

The role of Developer is Changing

Developers too are finding that the goalposts are moving. Developers who’ve only just recovered from swapping out their FuncLibs for App Packages are now reeling from the news that there is even more to learn. Fluid brings a requirement to know much more HTML, CSS and some JavaScript. Having seen a recent demo where Jim Marion completely re-laid out a Fluid page using the Chrome Developer console rather than PeopleCode really brought this home. The next tech coming over the hill at Deve
lopers is Oracle JET – a collection of the most useful JavaScript frameworks.

LogStash for PeopleSoft

I felt I should end with a real ‘out there’ prediction. With Elasticsearch we can see that Oracle are open to including a new 3rd party product as part of the stack (previously it seemed like 3rd party tools were slowly being phased out) so what other new products or tools might be included? Elasticsearch is made by a company called Elastic, but they have other offerings in addition to their core Search product.logstash The one that looks the most appealing from a PeopleSoft point-of-view is LogStash. I’ve looked at it a number of times over the years but its lack of Windows support was always a barrier for me, however now it’s available on Windows. LogStash is a log file aggregation tool, it takes all of the entries in all of your log files spread across all of your servers and makes them available for searching in one central repository. It’s easy to see how that might be incredibly useful in a PeopleSoft context. There are alternative tools that perform a similar role – Splunk for example – however I think LogStash is the most obvious selection.

UPDATE: The PSAdmin.io guys discussed Splunk and LogStash in their latest Podcast.

So, there are 8 predictions for the coming years. Have I missed anything glaring? Have I got one of them wrong?


PeopleSoft Partner of the Year

Tue, 2016-08-30 09:00

I would like to borrow a few minutes of your time to ask a quick favour. If you haven’t already, could you please vote ‘Gold’ for Cedar in the UK PeopleSoft Partner of the Year competition.

http://pya.ukoug.org/index.php/survey/index

Here’s why I believe we’re worth your vote:

  • We’ve been serving PeopleSoft customers for 20+ years, and in each of the last few years we’ve worked with more than 40 clients
  • We’re active members of UKOUG, with multiple employees dedicating time to its committees – quite an investment for a company our size
  • We’re active in the PeopleSoft community, with multiple blogs and free newsletters
  • We share knowledge freely, with multiple speakers at UKOUG’s Apps15 and Oracle OpenWorld last year
  • We host our own knowledge sharing events, enabling the PeopleSoft community to network and exchange ideas, whilst Cedar experts and customers share success stories
  • We’re on the cutting edge, if you want to know about Oracle Public Cloud, Fluid UI or Selective Adoption, we’re the people to speak to

I hope that’s enough to convince you. If you’ve voted for us please let me know. If you need more persuasion, please do get in touch.


I’m Logesh Balasubramaniam and this is how I work

Thu, 2016-08-18 07:00

The next profile in our ‘How I Work‘ series is Logesh Balasubramaniam. Logesh is one of the newer bloggers – posting on his LeanIT Designs site – however he provides great content and is usually one of the first to tackle new functionality. He has sometimes even managed to blog about new features before Oracle’s official post.

If you’re a fan of Logesh’s work it looks like he’s been selected to present at OOW this year, alongside his colleague Chamanthi Weerasinghe, on “Bang for Your Buck: A Practical Approach to Optimize Your Selective Adoption”.

Logesh

Name: Logesh Balasubramaniam

Occupation: PeopleSoft Consultant at Presence Of IT, Australia.
Location: Auckland, New Zealand.
Current computer: Lenovo Thinkpad T440s
Current mobile devices: Samsung Galaxy S3 & iPad Mini 2
I work: To achieve best possible outcome in the realms of Scope, Time & Cost

What apps/software/tools can’t you live without?
Apps – Kindle, linkedin, Keeper(Passwords), doubleTwist
Desktop essentials: MS office, Outlook, Notepad++, Snipping Tool

What’s your workspace like?
I am minimalist by nature and my workplace will reflect it. I don’t tend to carry any baggage(both hard & soft) and have a compulsion to get rid of anything after its purpose.

desk

What do you listen to while you work?
Silence, help me to focus. Leave my windows open and let in everything that my surroundings offer.

What PeopleSoft-related productivity apps do you use?
Browsers: Chrome & Firefox, Developer tools in both browsers, Extensions – Wizdler for chrome, HTTPFox for Firefox
PeopleTools – Whole suite of development tools and occasionally administration utilities
SOAPUI – Everything integration related
SQL Developer and SQL Server management studio

Do you have a 2-line tip that some others might not know?
I find ‘My Oracle Support Community (MOSC)’ to be very active and useful in PeopleSoft application space. Especially for those working on new features in recent product versions, post your queries and you will get immediate help with Oracle specialists. I also find Red Papers released on various topics by Oracle to be a very valuable resource to design solutions especially in integration, security and performance areas.

What SQL/Code do you find yourself writing most often?
Having spent most of my time in HCM application, subquery to get MAX(EFFDT), tops my list.

What would be the one item you’d add to PeopleSoft if you could?
Support/implement SAML based identity federation.

What everyday thing are you better at than anyone else?
Starting every day with the same eagerness, desire and will I had on my first day at work.

What’s the best advice you’ve ever received?
Nothing specific from a person, but an elementary quote that I find most relevant in our profession is “A stitch in time save nine”. As remote work culture and diverse work teams become ubiquitous, proactive communication is key to successful collaboration.


Hit by the ‘Tech Support’ Scammers

Fri, 2016-07-29 12:19

I got a call earlier today from the Tech Support Scammers. You’ve probably heard of this horribly unethical practice already, but the premise is that they cold-call seemingly randomly and try to convince you that there is a problem with your PC/router, and then attempt to get you to allow them remote access to your PC to ‘fix it’. Some then claim problems are due to expired warranties on the computer and demand payment, others setup a boot password and demand money for unlocking it. Either way, it’s a nasty thing to do and is taking advantage of people while pretending to help.

So, I thought I’d play along and see what they’d do.

The call appeared to come from a UK number, however it clearly originated from an offshore data centre. They introduced themselves as calling from my ISP and said that they’d detected a problem and needed to fix it on my PC. They could show me some symptoms to reassure me that they were legitimate. I asked them “who is my ISP?” as I wasn’t sure whether they’d know, however they were able to accurately answer.

The nice lady then got me to open Event Viewer and tell me how many errors and warnings were listed.

Event Viewer

I’d wager that most computers have a heap of entries here, but when I said that there was over 8,000 she did some great play-acting that 8-10 is a typical number, feigning shock and how this proves the appalling state of my laptop.

Next, she asked me to open a command-prompt and run the ASSOC command. This lists all the file associations on my laptop, and she read out a string and asked me to verify that it matched the CLSID below.

assoc

This, of course, proves nothing as it would be the same on all versions of Windows. However, she said that CLSID stands for “Computer Licence Security ID” and that by knowing this code it proved her authenticity.

At this point she asked me to visit http://www.support.me, which forwards to LogMeIn – a remote control system – and said she was going to pass me over to a technical colleague called ‘David’.

When David came on the line I said I’d used the lengthy delay to google what had happened and found out what they were doing. He then swore at me and hung up.

I feel sorry for the poor people that fall victim to these horrible practices and wish there was some way of stopping them preying on the innocent.


Banishing some PeopleSoft Myths

Thu, 2016-07-28 11:05

There seems to be quite a bit of uncertainty and misinformation in the PeopleSoft marketplace currently, so I thought it might be time to banish a few myths:

1. PeopleSoft isn’t being improved/getting investment

There are those with vested interests or other biases that will always deny this regardless of the evidence put in front of them, but PeopleSoft is improving in leaps and bounds. In the last couple of years PeopleSoft has been moving at an increasing speed, and one of the biggest questions on many client’s minds right now is “how do I keep up”. My Cedar colleague Graham Smith has a long list of recent new features in his PeopleSoft Predictions 2016 post, but if you just counted Fluid, Selective Adoption and Cloud Delivery Architecture I don’t think there’s ever been a time in which PeopleSoft has improved so much in a short space of time, pre or post-acquisition. Paco has repeatedly committed to keeping PeopleSoft around until at least 2027, and using the last few years as evidence I’m inclined to believe him.

2. PeopleSoft is Legacy/Old Fashioned

PeopleSoft is certainly very well established, with a long history and a wide customer base, that much is true. This can be a good thing, in that much of the system is tried and tested with the wrinkles ironed out. It is also true that some aspects of PeopleSoft do things the ‘old way’. The majority of deployments are on-premises, without the flexibility and efficiency that cloud deployment and automation can bring. You also pay for PeopleSoft up-front, rather than monthly. It doesn’t have to be this way, however. PeopleSoft can be deployed in an agile and efficient manner, taking advantage of some of the new technology available to us now, and the new enhancements within the product.

3. To be a future-proof system it needs to be SaaS

This is tricky as different people hold varying ideas about what constitutes SaaS, however PeopleSoft does get regular updates containing new functionality from the vendor (every ~10 weeks), can be deployed in the Cloud (to gain auto-scaling/elasticity of resources, a predictable monthly subscription and theoretically even multi-tenancy – at least above the database-level, if it was something that clients wanted). Furthermore, the application of the updates and the management of the cloud architecture can be handed over to a friendly partner in order to get even closer to purists’ definitions of what SaaS entails – if that is important to you.

4. PeopleSoft’s UI is out-dated

Up until a few years ago there wasn’t the focus on ‘consumer grade UI’ that there is now. In that era, PeopleSoft’s UI measured up pretty well. It was certainly more attractive than SAP and/or E-Business Suite. Recently this greater focus on the User Interface has introduced new competitors but PeopleSoft still keeps up well. Of course you can compare an old version of PeopleSoft with the latest from a competitor and it will appear dated in comparison, however if you use the latest PeopleSoft UI in the comparison it’ll fare rather better. The Fluid UI is (at least) the equal of anything out there, regardless of which device you view it on.

5. The PeopleSoft Market is Quiet

From what I can see there are fewer green-field implementations than 5 years ago, but there is a lot more upgrade activity. Clients are moving to 9.2 at a far greater rate than for 9.0 or 9.1, and then starting initiatives to really get value from the software once they get there. As a company I’m not sure Cedar has ever been busier.

So, now I’ve got that off my chest, I might do some predictions like Graham next …


PeopleSoft on the Oracle Cloud – what does it mean?

Mon, 2016-03-14 06:00

There have been a few announcements over the last couple of weeks about the Oracle Public Cloud. But what does it actually mean for the PeopleSoft community?

What is Oracle Public Cloud?PeopleSoft in the Oracle Cloud

The Oracle Public Cloud is Oracle’s competitor to the Infrastructure as a Service (IaaS) providers that have swiftly risen to create a whole industry that didn’t exist 10 years ago. Because they’re the market leader (by far) everyone automatically thinks of Amazon, however Microsoft Azure, Google Compute and Rackspace are also players in the market.

As PeopleSoft adopts more SaaS-like features (new UI, incremental updates etc) companies have started to move their infrastructure from their own data-centres to the cloud. For many companies this makes good business sense, however rather than have customers going to a 3rd party provider Oracle would rather provide the cloud service themselves. Obviously this is better for Oracle, however the customer benefits too (retaining a single vendor, and Oracle can potentially optimise their applications for their own cloud better than they can for Cloud infrastructure belonging to other vendors). There may also be cost savings for the customer, however I haven’t looked at pricing yet.

Doesn’t Oracle already do Hosting?

Yes, Oracle has long had a service that will host infrastructure on your behalf – Oracle On Demand. This is more of an older-style ASP (Application Service Provider). You’re more likely to be on physical hardware without much in the way of flexibility/scalability and tied into a long-term hosting contract, so the Oracle Public Cloud is a major step forwards in a number of ways.

How will Oracle Public Cloud be better?

I attended a couple of workshops on this last week and it looks very promising. It has all the attributes required for it to be properly classed as ‘Cloud’:

  • subscription pricing,
  • elasticity of resources (so you can scale instances according to demand),
  • resilience of data centres (so, if you’re based in the UK you might be looking at the Slough data centre, however there are two ‘availability zones’ within Slough so if one gets hit by an outage you’ll still be able to connect to the other one)

Interestingly, it also includes several ‘Database as a Service’ offerings, each offering increasing levels of performance. With this model you don’t need to worry about the virtual machine, operation system etc that your database runs on, you receive access to a database and leave the maintenance to others. You would still need to have your other tiers on the IaaS offerings.

This opens up the possibility of multiple tiers of Cloud service:

  1. Just the Infrastructure (client does all the database and application admin)
  2. DBaaS (client has other tiers on IaaS, but does not do DB admin)
  3. Full Cloud solution (uses Oracle Cloud and a partner to do all administration)
How can I best take advantage?

The best time to move is probably at the same time as an upgrade. Upgrades normally come with a change in some of the hardware (due to the supported platforms changing) so moving to the cloud allows the hardware to change without any up-front costs.

PeopleSoft 9.2 and the more recent PeopleTools versions have a lot of features that were built for the Cloud, so by running it on-premises you’re not realising the full capabilities of your investment.

We’d recommend you try using the Cloud for your Dev and Test instances first, before leaping in with Production at a later date. Oracle have tools to help you migrate on-premises instances to their Cloud. (At this point – Mar 2016 – we have not tested these tools.)

What will the challenges be?

The first challenge is “how do I try it?”. This is pretty straightforward, in that you get a partner to demonstrate to you, or can get yourself an Oracle Public Cloud account and then provision a PeopleSoft instance using one of the PUM images as a demo. This would work fine to look at new functionality, or as a conference room pilot.

One of the biggest challenges is likely to be security – not the security of Oracle’s cloud, but securing your PeopleSoft instances which previously might have been only available within your corporate LAN. If you need assistance with this speak to a partner with experience using Oracle Public Cloud.


I’m Sasank Vemana and this is how I work

Wed, 2016-03-09 08:00

The next profile in our ‘How I Work‘ series is Sasank Vemana. Sasank burst onto the PeopleSoft blogging scene in 2014 with his Sasank’s PeopleSoft Log site, and has been adding entries at a ferocious pace since. He is probably best known for his series of posts on altering the PeopleSoft branding to make it match a corporate palette, as well as configuration and code changes related to UI/UX.

I met Sasank at OOW15 and he’s a lovely chap. He has given some great responses to the questions. I’d love to know how he persuaded his employer to give him 4 monitors and about his use of dual mice!

Name: Sasank Vemana

Occupation: PeopleSoft/Enterprise Technology
Location: Tallahassee, Florida, USA
Current computer:
Desktop: Dell Optiplex 9020 (Windows 7, Intel Core i7, 8 GB RAM)
Laptop: Dell LATITUDE | E6530 (Windows 7, Intel Core i7, 8 GB RAM)
Current mobile devices: Samsung Galaxy S4. Yes – That reminds me I need an upgrade!
I work: To solve problems.

What apps/software/tools can’t you live without?
Google is my friend and my portal to everything. I try not to overload myself with information, which I know I can find. Google search helps me find what I am looking for. On a side note, I use Whatsapp and FaceBook to keep in touch with my family and friends who are scattered in different parts of the world. I also use S Health app to keep track of my physical activities and monitor my health.

Besides your phone and computer, what gadget can’t you live without?
Not a big gadget fan! I can live without them as long as I have a good internet connection, which seems to be the most important thing for me these days. With that, I can do my reading, research and also remote to any of my computers (if needed) regardless of the device. Same goes with entertainment – Netflix, Spotify, etc.

What’s your workspace like?
Over the past year and a half, I have been using a standing desk at work, thanks to my current employers who were kind enough to allow me to rearrange my workspace. When I am at work and not in meetings, I try to stand as much as possible and use a bar stool when I tend to get tired. Occasionally, I also just sit down with my laptop wherever I find space. The four monitor desktop setup helps tremendously when I have multiple applications running. I also have two mice and try to switch between my left and right hand. I am ambidextrous so it works for me (I will not recommend this otherwise!).

Sasank Vemana - How I Work - Picture 1

Standing desk, 4 monitors and dual mice

Sasank Vemana - How I Work - Picture 2

What do you listen to while you work?
Usually, I am zoned into whatever I am doing and mostly oblivious to events around me. I don’t listen to music while I am at work these days. At times, I listen to live cricket or tennis commentary if anything I care about is going on. A set of Bose noise canceling headphones has long been on my wish list (in case Santa is reading!).

What PeopleSoft-related productivity apps do you use?
Oracle Virtual Box/PUM Images – My savior for evaluation, experimentation and proof of concept purposes.
Web Services: SoapUI, Postman (Chrome Add-On)
Web Development: Browser based Developer Tools (Chrome/Firefox/IE), DOM/StyleSheets/JavaScripts Explorers, Device Emulators, etc., Fiddler, Live HTTP Headers (Firefox Add-On)
Text Editors/Journals: Notepad++, Programmer’s File Editor (PFE), WinMerge, Evernote
DB Tools: Golden (for the most part since it is light weight and does not hog resources), SQL Developer (for some activities), OEM – Oracle Enterprise Manager
Screen Capture/Recording: SnagIt and Jing (short videos) are great for communication

Do you have a 2-line tip that some others might not know?
Tracing tip: Use PeopleCode – 2048 (Show Each), SQL – 3 (Statement, Bind). This gives us every line of code and SQL that executed in sequence without all the other clutter which is not always useful especially when we are just trying to understand the logic.

What SQL/Code do you find yourself writing most often?
Generally speaking, queries on PeopleTools metadata tables. E.g.: PSAUTHITEM (security related queries), PSPRSMDEFN (portal navigation queries), etc.

What would be the one item you’d add to PeopleSoft if you could?
I would add/implement a log aggregation and mining utility. I have spent many hours combing through log files distributed across different servers. It would be great to see something that aggregates all server logs and provides mining capabilities (regex and/or free-form search). After attending Oracle OpenWorld 2015, I understand that PeopleTools 8.55 has some new features – as part of Health Center – that might assist with logs. I look forward to evaluating this functionality!

What everyday thing are you better at than anyone else?
Probably exploring! Although, I would be careful not to say that I am better at it than others. I just find myself doing that a lot without worrying about getting lost. It might seem like a wasteful effort at times but it is a natural way of learning for me.

What’s the best advice you’ve ever received?
These are not really advice received from someone but some of my favorite quotes that I can think of right now:
– Learn to profit from your losses.
– Don’t make decisions during a storm.
– A manager gets work done through people whereas a leader inspires people to meet shared goals.
– And miles to go before I sleep.


Pages