Earlier this week Cedar held its Oracle Talent Acquisition Cloud event in Oracle’s London City office. We have a really strong team of UK-based Talent Acquisition specialists within our ranks:
Jo, Prachi, Marc and Mel are all experts in the various aspects of Oracle Talent Aquisition Cloud – Taleo Recruit, Sourcing and Onboarding – and Cedar has multiple implementations under our belt covering all of the above products, so we were able to put on a seminar with strong content.
I’ve put a post on the Cedar blog with lots of photos from the day here.
Both Oracle and Workday have recently announced figures for their Cloud application suites and it’s interesting to see how they both compare.
In its Q4 results Workday stated that they have 1,528 HCM customers with 136 of the Fortune 500, plus 320 financials customers. 70% of their HCM customers are live.
In its recent Analyst Briefing Oracle shared that they have 1,600+ HCM customers with 275+ of the Fortune 500, and 3000+ financials customers. 1,000 of their customers are live (giving a figure of 62.5%).
Here’s what that looks like in pictures:
(Taking Oracle’s figures of 1,600+ and 1,000+ as 1,600 and 1,000)
(The Fortune 500 is an annual list compiled and published by Fortune magazine that ranks 500 of the largest U.S. corporations by total revenue for their respective fiscal years. This chart assumes that no corporation has both HCM Cloud and Workday. It also takes Oracle’s 275+ figure as 275.)
(Taking Oracle’s figures of 3,000+ as 3,000)
Those of you who know me will know that I’m working at Cedar and we’re moving from PeopleSoft to the Oracle Cloud. I won’t talk about the company’s journey, but more how I’ve found the transition personally.
In brief, there’s a lot to learn.
Data Model knowledge
In the PeopleSoft world, once you know the table structures you could work significantly faster. Whether you were writing an SQR, an App Engine, an XMLP report, a migration script, an ad-hoc Query or a piece of page code the source was always the same – the PS tables.
In the Oracle Cloud world the tables are still there, although they’re closer aligned to the eBusiness Suite data model so they’re not immediately familiar to those from the PeopleSoft background. This isn’t the end of the story however, as the raw tables are only accessed some of the time (for instance, during a BIP report). If you’re doing an ad-hoc Query in OTBI then you’ll need to know the Subject Area structure and this is very different from the underlying tables. If you’re writing an HCM Extract then you’ll need to know the UE structures, and they’re different again.
Is this better than what we had in PeopleSoft? These abstractions are good in some respects, for instance OTBI Subject Areas are easier for end-users to pick up than the database tables for ad-hoc querying. But it does mean that for techs there are multiple different data models that you’ll need to learn.
I was never involved in a File-Based Loader migration – luckily it seems – but we’ve used the new HCM Data Loader tool a couple of times now, once for a migration and once for a mass update of existing data (annual salary uplifts). It’s actually quite nice, once you get the spreadsheets setup – and I had a couple of colleagues helping with that – and the data goes in pretty well.
Is this better than what we had in PeopleSoft? Yes, I think it probably is. Many times the code for PeopleSoft migrations was handwritten from scratch and would be thrown away after it was completed. With HDL there’s a lot of re-use and it’s probably quicker to put together too.
In the PeopleSoft world we have three levels of role-based security, the user profile, roles and permission lists, all managed from a handful of pages and covering both page access and data security.
In the Oracle Cloud world it’s a much larger model, with abstract roles, data roles, job roles duty roles, security profiles. Each is managed from a different set of pages in completely different areas of the system. The system is moving in the right direction, as the Security Console does bring some of this into a single place.
Is this better than what we had in PeopleSoft? I’m not sure. I don’t consider myself a security expert in the Cloud yet, and although I can see it’s a larger framework with more moving parts I’m not yet sure whether this is a better thing.
In the PeopleSoft world we had a very capable toolset and the access to change whatever we wanted. This could be dangerous as although something ‘could’ be changed, it wasn’t always the case that it ‘should’ be changed. With a little experience it was generally pretty easy to see between these cases however. This generally meant that whenever there was an issue it could be fixed by getting into the code and making some changes.
In the Oracle Cloud world it’s a similar story when it comes to typical tech tasks – migration, interfacing, etc, but it’s a different.answer when it comes to issues with the delivered system. If there is a problem then it’s often the case that you’re helpless to do anything other than raise an SR.
Is this better than what we had in PeopleSoft? I think time will tell here. Everyone is still learning to work together in this area. Our SRs could probably be more detailed in order to prevent a lot of to-and-fro between Oracle and implementation team, and the Oracle support teams are still learning as well, especially as the system is moving target with new releases every 6 months. In general Oracle Cloud fixes get delivered about the same speed as PeopleSoft ones (assuming the client is on 9.2 with Selective Adoption).
Is my life any easier in the Oracle Cloud world? Not yet, but that’s largely down to the amount of time I’ve spent working on the Cloud vs my PeopleSoft experience. I’m confident that I’ll improve – and the product keeps improving at breakneck pace – and I’ll be able to help many more customers make the move.
Cedar held its annual Oracle Day in Oracle’s City office last Thursday – it was actually our 6th year of running the event. The attendance was great – just short of 100 – and with 3 streams of content there was plenty to choose from. If you weren’t there, here’s the highlights of the sessions that I attended:
After the opening keynote from Dan Woolstone, Oracle’s James King and myself spoke to a full room on Top 10 Tips for a Successful HCM Cloud Implementation. There was a good mixture in the audience of clients already running in the Cloud and those at some stage of their journey, and we received some great questions.
Swiftly following on was Mike Everitt peeling back the curtains on HCM Cloud R11 and revealing some of the new functionality we can look forward to.
Next up was a customer success story from one of Cedar’s recent go-lives – Chubb Insurance. The team spoke about real business benefits from implementing Oracle HCM Recruit (formerly Taleo) and how Cedar and the in-house team worked together to deliver the project within the time-frame. We’re now working with them on a phase 2.
After networking lunch I went to the payroll stream to listen to Oracle’s Andy Spencer introduce the Oracle Payroll Cloud.
The final session I attended was Merrick Hartslief and the benefits of Oracle Social Sourcing (extending Taleo Recruiting functionality).
Before we all headed off to the pub for some well-earned refreshments and sharing of learnings we all got together for a prize-giving, including an iPad, some champagne, etc:
If you missed out and would like to attend next time, please contact email@example.com
HCM Data Loader (HDL) data ready to load into Oracle HCM Cloud is in pipe separated text file format, however most people will create and manipulate these files in MS Excel as it’s the handy swiss-army-knife for data manipulation that almost everyone is familiar with.
The way that we’ve worked is that we create template files containing the sheets and columns corresponding to the fields that the client is using, which the client then populates, then we’ll validate and load into HCM Cloud. Although we use the Data File Validator for HDL as a final pass, most of this validation is first performed in Excel.
Some of this validation is basic (checking for trailing spaces, making sure the provided values are valid in the lookups etc) and some is slightly more complex, eg. looking at consistency across templates. It was whilst doing the latter today that I colleague and I came across a tip that we didn’t previously know.
How VLOOKUP almost works
My normal method of looking up a value in a table elsewhere in Excel is to use the VLOOKUP function. It’s quick, easy and has saved us from countless data issues by spotting problems early. There’s a problem however, which I’ll explain, and provide the solution.
A simplified example is Banks and Branches. First we obtain the list of valid Banks, then we check the list of Bank Branches to make sure that the Bank operating each Branch appears on our list of Banks.
On the left here we have the list of valid Banks in column B, and a text string in column C saying ‘OK’. This is the value that gets returned if the bank matches. (This is a heavily simplified example, the genuine data would have many thousands of branches to check.)
On the right we have the list of Branch owners to lookup against the list on the left.
By using a formula we want to check each of the banks in column E is somewhere in the table on the left. So we use:
=vlookup(<bank to check>, <table of valid banks>, <column to return>, FALSE)
which translates to this for the first cell:
This works a treat, giving the following results:
We can clearly see which branches are run by banks on our list and which are not.
The reason that this sometimes fails is VLOOKUP isn’t case sensitive. Looking up the value LLoyds in the valid banks table would result in a match (despite the second upper case L), however it would obviously fail when we tried to load the data in using HDL.
The method that I now use is a ‘Lookup Exact’. It combines two Excel functions (surprisingly, LOOKUP and EXACT) to give a case sensitive equivalent to VLOOKUP (with the added benefit that the lookup table doesn’t need to be sorted alphabetically).
The formula has the syntax:
=LOOKUP(1,1/EXACT(<table of valid banks>, <bank to check>), <values to return>)
which translates to this for the first cell:
And if I add this to column G we can see that it looks up perfectly against our table, correctly identifying even those in the wrong case (where vlookup in column F fails us).
To give credit where due, I didn’t create this Excel function. It is well explained in this YouTube video:
The ‘Year in Blogging’ reports have come through so I can see what posts and newsletter items garnered the most views.
The Fusion Tipster Blog
So, according to the summary, the most popular post was Introducing OTBI-E, followed by What’s Coming in Taleo 14B, and then the posts on specialisation. Of those, only the former was written in 2015, with the other two coming from 2014. The other popular posts written in 2015 were Storyboarding with Oracle and Microsoft Edge and the Oracle HCM Cloud.
About 40% of the traffic is from the US, 20% from India, and 15% from the UK and smaller amounts from Brazil, Canada and Australia.
The Fusion Weekly Newsletter
The Fusion Weekly newsletter subscriber base rose from 174 to 216 during 2015 which is an approx 20% increase. The ‘open rate’ sits around 40% for any one issue (against an industry average of 17%) with the US and UK each accounting for 35% of readers, and India 9%.
Interestingly, the Fusion Weekly readers are a lot more likely to read on a mobile than the PeopleSoft Weekly readers (32% vs 22%).
The top articles in terms of clicks were:
- Compare Oracle HCM Cloud to Workday (45 clicks)
- BT’s Journey from PeopleSoft to Oracle HCM Cloud (31)
- Gartner on Picking between SAP, Oracle, Workday (30)
- Oracle vs Workday (28)
- Spotlight on HCM Cloud R10 (26)
- Hakan Biroglu’s Tips & Tricks for a succesful implementation (24)
- Histography (22)
- Continue Learning Post-Oracle OpenWorld (22)
- HR in the cloud, is it secure? (21)
- Dennis Howlett’s Oracle OpenWorld Verdict (20)
- Is it really cheaper to put your HR system in the Cloud? (20)
- Why Workday is Tumbling (19)
- Seven Ways to Compare the Enterprise HCM ‘Big 3’ (19)
- 10 aspects you should consider before selecting a SaaS solution (19)
- Oracle is quietly becoming a cloud giant (18)
- HCM Data Loader Overview (18)
- Enterprise Software’s Life Lessons (17)
- The real-life Doppleganger (17)
- Back Stretch of the HCM Horse Race (17)
- The 10 Most Valuable Features of HCM Cloud R10 (17)
Although there had been many analyst and Oracle ACE briefings for much of the preceding week, Sunday night was the ‘proper’ opening for Oracle OpenWorld 2014. It kicked off with Larry’s first keynote of the conference. (He traditionally does two, however skipped the second last year to watch the thrilling finale to the 2013 America’s Cup.)
His hour long address was given over exclusively to the cloud. Here’s a summary of the important points for those in the Oracle applications marketplace.
Layers of the Cloud
There are of course many layers within The Cloud … the Applications sit at the top level (Software as a Service), however there’s also the platform beneath this (Platform as a Service), and the infrastructure at the bottom (Infrastructure as a Service). Oracle is moving to being a company that can offer the complete stack of cloud services to the enterprise. Larry’s first big point was that Oracle is the only company that can do all three layers.
It’s an interesting – although to a certain degree, academic – point to debate. He said Salesforce only does the Application layer (he’s correct that they don’t have the infrastructure service layer, although I think that they would rightly argue that they have a large and mature platform layer – Salesforce1). He also said that Amazon just does the Infrastructure layer (although they would quite correctly argue that they also provide a platform layer).
The only companies that can come close to Oracle’s delivery in all three layers are Microsoft – they have Infrastructure (Azure) and Applications (Dynamics is now available in the cloud) but their PaaS offering is not as well known – and Google – who have infrastructure (Google Compute Engine) and Platform (Google Application Engine) however their SaaS offerings are Gmail, Google Calendar and Google Docs, rather than full-blown HCM or ERP offerings.
Platform in the Cloud
The newest of Oracle’s three offerings is the Platform layer. You can now move any database to Oracle’s database in the cloud service very simply. Furthermore, any Oracle application (or any Java application) that runs on top of an Oracle database can be moved to the cloud very simply too. This is apparently possible on Oracle’s upgraded 2014 platform. Larry’s also promised that these migrations can be done with just two button presses, which is a bold – many would say unbelievable – claim.
This platform supplies the building blocks with which any applications in the Oracle Cloud are built – whether they’re built by Oracle or by customers/partners. One of the points that Larry stressed again was that Oracle is the only vendor that gives end users the same platform to develop on that they use internally. Other vendors either have no platform service at all (Workday) or use different tools in-house (like Salesforce – who offer Salesforce1 to customers but use a different platform to develop the core application with in-house).
In what sounds like an entertaining session, during his second Keynote on Tuesday Larry has promised to both extend Fusion applications and perform the ‘two button migration’ in live demos. I think you should always get extra marks for demoing your own products, as many speakers usher someone else on-stage for this section – although as Larry is CTO now I guess we shouldn’t be surprised that he’s going it himself.
Infrastructure in the Cloud
Larry spoke briefly about Oracle’s IaaS offering. He skipped over a few of the slides quite quickly, I’m not sure if he was running short of time, however he made some interesting points. It still strikes me as unusual when he claims that Oracle will compete with Amazon and Google on price – as Oracle solutions are typically more towards the premium end of the price-scale – however it’ll be interesting to see how they get on in the commodity pricing marketplace.
Larry’s claim that “the Oracle Cloud is bigger than most people think” was certainly correct for me. They currently have 30,000 servers and serve 62,000,000 discrete users every day!
HCM in the Cloud
Larry stated that Oracle has long held the lead in Talent Management in the Cloud – he was clearly talking about Taleo here – however for the last two quarters Oracle has overtaken the competition and is now the top-seller in Core HR. This ties in with the information from the latest Oracle earnings call (in the last financial quarter Oracle sold Fusion HCM to 60 new customers, and during the same period Workday only added 25).
Larry believes that the reason that Oracle HCM Cloud is selling so well is that it’s got Social integrated. Benefits, Payroll etc. is “table stakes”, but the Social tools are important for what he calls 21st Century HCM.
ERP in the Cloud
Larry says that he is particularly proud of the Oracle ERP Cloud as it was built in-house. He says that Oracle is the first company to sell mid-market and high-end ERP in the cloud. Given that Oracle has only been really selling this for a touch over 12 months, this is an impressive logo slide:
He also mentioned that Oracle is selling EPM in the cloud – so they’ve moved Hyperion to the cloud – and claims that Oracle are the only company within an EPM in the Cloud offering.
Speed of Growth
Larry stated repeatedly that Oracle’s strategy is “build and buy” … some of Fusion has been developed in-house, other parts have been purchased. Of the parts that have been built in-house, this is the growth (or hyper-growth in Larry-speak) in the last 12 months:
He says that 2014 is an inflection point for Oracle in terms of selling these solutions. The fact that 19 out of the top 20 SaaS providers use the Oracle Database and Java is obviously something that Larry would enjoy (and the lone company that doesn’t – Workday – uses another Oracle Database – MySQL – for some of its back-end processing).
He also poked fun at SAP for their HANA powers the cloud slogan by asking “whose cloud does it power, because it doesn’t power theirs” (SuccessFactors, Ariba and Concur all run on Oracle).
In summary, despite stepping down from the CEO role Larry couldn’t resist opening the conference with a bang. There weren’t as many new product announcements as previous years, however he was able to shine a light on some strong progress and healthy sales traction across many product lines. It’s clear however, that the product lines that will get the most focus are ones with ‘cloud’ in the name. There wasn’t a single mention of PeopleSoft, eBusiness Suite or Siebel during the entire session.