Skip navigation.

Duncan Davies

Syndicate content The PeopleSoft Tipster Blog
A PeopleSoft Tips and Tricks Blog
Updated: 9 hours 50 min ago

PeopleSoft-Taleo Out-Of-The-Box Integration Deprecated

Tue, 2015-07-28 06:47

Oracle have made the interesting announcement that the delivered integration between PeopleSoft (HCM 9.1 or 9.2) and Taleo is being deprecated. This is a positive move from Oracle and simplifies things greatly from a client and partner perspective.

Previously Oracle delivered two different integration methods, prebuilt integration using web services and PeopleSoft Integration Broker, or the Taleo Connect Client (TCC) tool – which is a highly flexible tool for any kind of Taleo integration. It’s only the former that is being deprecated.

TCC remains the tool to use for integrating Taleo and PeopleSoft (or indeed, Taleo and any system) and it’s mature, robust, widely used and much liked.

Integration between Taleo and PeopleSoft rarely fits the ‘standard’ requirements as each client will have different processes around whether someone leaving in PeopleSoft automatically creates a requisition in Taleo or not, and what the approval chains are. Likewise, the new hires coming back in from Taleo can go to more than one place in PeopleSoft, and the amount and types of data brought over can vary wildly – especially if Taleo Onboarding is included. It’s preferable to have a TCC-built integration that fits the requirements than a bare-bones delivered process that can’t be improved.

The removal of the Integration Broker/Web Services integration as an option is a positive move as clients would regularly spend precious effort evaluating it, before concluding that it was too restrictive for their specific requirements and then using TCC.

The official announcement is here:
http://www.oracle.com/partners/secure/campaign/eblasts/peoplesoft-taleo-out-of-the-box-2613641.html


I’m Javier Delgado and this is how I work

Mon, 2015-07-13 07:00

July’s entry in the ‘How I Work’ series is PeopleSoft Blogger Javier Delgado. Javier is a PeopleSoft consultant and manages the PeopleSoft Practice at BNB (Business Network Builders). Javier has been writing on his ‘Javier’s PeopleSoft blog‘ site since 2007, however it’s only in the last couple of years that he’s started posting really regularly. In fact his 24 posts in 2015 probably make him last year’s most prolific blogger. We often link to his posts from the PeopleSoft Weekly as he posts on great topics, including Cloud deployments, upgrading with zero downtime and doing cool things with Integration Broker. Javier can be followed on Twitter here: @javierdelgado

Javier_Delgado

Name: Javier Delgado

Occupation: PeopleSoft Practice Manager at BNB
Location: Madrid, Spain
Current computer: MacBook Pro 13” (8GB RAM, 512GB SSD)
Current mobile devices: Samsung Galaxy S5, Apple iPad 2, Amazon Kindle
I work: as a consultant, or practice leader, or project manager. Whatever is needed within the circumstances. Although my main responsibility is being the leader of the PeopleSoft and Cloud practices at BNB, I still prefer the hands on work.

What apps/software/tools can’t you live without?
I use PeopleBooks as a constant reference source, in particular the API and Language Reference books. I also refer to them when learning a new module or functionality (lately I’ve been playing a bit with REST services and P-Card features in Purchasing).

For issue resolution on non open parts of PeopleSoft, Google search and My Oracle Support are always of great information.

Lately, I’ve been using Feedly and Twitter lists as a source for research. I save any item that interests me in Pocket and future actions to be taken in Trello boards. Virtualization, and VirtualBox in particular is a great way to practice in a controlled sandbox environment.

Finally, I extensively use Google Apps (Docs, Sheets, Slides and other plugin applications) to produce deliverables collaborating with the rest of the team. Earlier this year I uninstalled Microsoft Office from my machine. Will I survive?

Besides your phone and computer, what gadget can’t you live without?
It is not a gadget in all its forms, but I can’t live without books. When reading literature, I prefer printed books, while I normally read technical books using my Kindle. Don’t ask me why I make this distinction. It just happens.

What’s your workspace like?
Normally a mess. This has motivated me to get rid of paper as much as I can. In the last year or so, I always took notes using my Macbook Pro. This is the only way I can be sure of not losing my notes. On top of it, my workspace is much tidier.

20150223_151210

What do you listen to while you work?
I very rarely listen to music while working, mostly when there is too much environmental noise. In such cases, I normally use a classical music playlist I have in Spotify.

What PeopleSoft-related productivity apps do you use?
My preferred tool is tracing. I’ve always found PeopleSoft traces very information and normally use it almost for every issue I need to diagnose. More importantly, it is very reliable: if it is not in the trace, it didn’t happen.

Lately I have been playing around with some custom Javascript within PeopleSoft pages. Google Chrome seems to have the best debugging console for web applications. I guess I will be using it more and more with the advent of the new Fluid user interface.

Do you have a 2-line tip that some others might not know?
Inspecting the HTML pages is a great way to identify fields and then map them to record fields, but this was also shared by others in this same space.

One thing I found particularly useful lately are the Query Access Services than enable third party access to queries through web services. Once you got the integration done for one query, it is very easy to extend to further ones. The potential for quickly delivering web services to third party applications is great.

What SQL/Code do you find yourself writing most often?
Definitely the Effective Date subquery. %EffDtCheck meta sql has helped a lot, but it still does not work as expected for the JOB table, as it would include EFFSEQ as a join in the subquery used to retrieve the maximum EFFDT.

On top of that, I use the database specific functionality to create working tables based on a query (CREATE TABLE AS in Oracle and SELECT INTO in SQL Server).

What would be the one item you’d add to PeopleSoft if you could?
Quite a few, mostly around Application Designer. From my point of view, this was a great IDE more than a decade ago, but it has not evolved as other IDEs used for Java and Javascript development. It is still a very productive tool, but there are a few features that would make it better.

One way would be to enable third party developers to produce plugins to complement Application Designer features. With thisability, it would not take too long before programming tools such as versioning, lint and refactoring were made available to the PeopleSoft community at no cost.

On the other hand, and although I think Fluid is a great step forward, it almost made the page design redundant. True, we still use pages with group boxes to set the responsive divs in our Fluid pages, but it seems to me a rather complex way of doing things. This is probably out of the bounds of this answer, but I see room for a new paradigm, pretty much a PeopleSoft 8 compared to previous versions. Unfortunately, I don’t think Oracle has the same plans in mind.

What everyday thing are you better at than anyone else?
I have a quite broad knowledge of PeopleSoft architecture, development and functionality. This is purely based in that I always wanted to work with software. In other words, I love what I do, and I don’t think there is a better fuel than passion.

What’s the best advice you’ve ever received?
From my literature teacher in my last year at high school. He was giving the grades of the previous exam to the final one. He first addressed the people who had passed the exam by inches, telling them to make a bigger effort for the final exam. Then, he told the ones having the best grades: “you should make an even bigger effort, as there is no shorter path for mediocrity than self complacency. Always believe in yourselves, but always doubt, as doubt will protect you from self complacency.” There is a bit lost in translation from Spanish, but I hope I made the idea clear.


OpenWorld and UKOUG Apps 15 Sessions

Fri, 2015-07-10 05:03

I’m delighted that the sessions that I’ve submitted to both Oracle OpenWorld and UKOUG’s APPS15 conference have all been accepted.

The sessions are as follows:

OpenWorld:

PeopleSoft Selective Adoption Best Practices from the Front Line (joint with Mark Thomas of Hays)
PeopleSoft Selective Adoption is genuinely transformative, but to make the best use of it you need a plan. Come to hear from the one of the earliest adopters of this new model on defining how it can work best for you, not just the implementation but the ongoing effective use of PeopleSoft Images using PeopleSoft Update Manager (PUM), the frequency of patch application and the business benefits achieved.

UKOUG APPS15:

Taleo for PeopleSoft People
We’ll show you the Taleo products that work well with PeopleSoft and explain the circumstances in which they might be a good choice for you. We’ll also show the products working together and explain how you can deploy it without breaking the bank.

Running PeopleSoft as a Service
We’ve all heard of the ‘Software as a Service’ (SaaS) vendors. You don’t need to abandon the many benefits of PeopleSoft to gain the agility, security and efficiencies of consuming PeopleSoft as a Service however. We’ll show the key tenets of ‘as a Service’ delivery and how functionality like Selective Adoption enables you to attain them with PeopleSoft.

You can find out more about OpenWorld here and Apps15 here.


Exclusive: The Future of PeopleSoft with Marc Weintraub

Mon, 2015-06-01 08:00

Marc Weintraub (Senior Director of Product Strategy for PeopleSoft) appears in this exclusive Cedar Consulting video and discusses the Future of PeopleSoft with Cedar’s star HR Optimisation guru, Jo Randles.

They cover items such as the size of the PeopleSoft team, competing with cloud-only solutions, avoiding the ‘upgrade for compliance’ trap, self-funding quick wins, co-existence options and putting PeopleSoft in the Cloud.

If you’re curious about the direction that PeopleSoft is taking, or interested in the options available to you now, this is a must watch.


I’m Iouri Chadour and this is how I work

Wed, 2015-05-20 06:00

May’s entry in the ‘How I Work’ series is PeopleSoft Blogger Iouri “Yury” Chadour. Yury has been sharing his knowledge on his Working Scripts blog for 7 years, so is a valuable and consistent member of our community. Yury’s site is full of tips, particularly new tools to try and techniques ‘around the edges’ of PeopleSoft.  Thanks, and keep up the good work Yury!

profile_pic_blogger

Name: Iouri Chadour

Occupation: Vice President at Lazard Freres
Location: In the office in midtown NYC
Current computer: At work I use either standard Lenovo laptop or my VM client, my own machine is Lenovo X1 Carbon
Current mobile devices: Samsung Galaxy S3, iPad Air 2, Kindle Fire (Original)
I work: best when I have a set goal in mind – I like being able to check off my achievements from the list (more on that below.) As many others fellow bloggers have mentioned – challenge and ability to learn new things on the job are very important as well.

What apps/software/tools can’t you live without?
I use all of these Software Development Tools:

Application Designer
Notepad++ with lots of plugins PeopleCode user Defined language, Compare, AutoSave, NppExport, Explorer to name a few
Firefox with Firebug, AdBlock and Hootsuite
Feedly – this my main tool for following all the blogs and keeping up to date on the news
LastPass – very convenient password management for desktop and phone
KeePass – open source password manager
Toad for Oracle 12
Oracle jDeveloper
Aptana Studio
PeopleSoft TraceMagic
Wunderlist – Android app and Desktop for Taks Management
Microsoft Project or Project Libre
MS Excel
Greenshot Screen Capture
SnagIT
Gimp – basic image editing

Besides your phone and computer, what gadget can’t you live without?
I like my original Kindle Fire – I use it for reading more than any other device.

What’s your workspace like?
workspace

What do you listen to while you work?
Listening really depends on the mood at time of the day. I mostly use Slacker Radio to listen to everything from contemporary and classic jazz, Classical to Parisian Electro and House music.

What PeopleSoft-related productivity apps do you use?

App Designer
PeopleSoft Query Client for writing queries
Toad 12
Notepad++ to write and examine code and logs
TraceMagic for more advanced log review
Firefox with Firebug for HTML and JavaScript issues
On occasion Aptana Studio for JavaScript and HTML

Do you have a 2-line tip that some others might not know?
If I am stuck with a very difficult problem and can’t seem to find a good solution – I usually leave it and do something else – at some point the solution or a correct directions usually comes to my mind on it’s own.

What SQL/Code do you find yourself writing most often?
Since I work with a lot of Financials Modules so everything related to those modules. I do also write some tools related SQLs when I need to examine Process Scheduler tables.

What would be the one item you’d add to PeopleSoft if you could?
Code completion and Code/Project navigator – I use Notepad++ for now.

What everyday thing are you better at than anyone else?
I do not think I do something in particular better than anyone else, but I believe that I can be more efficient about some things than some of the people.

What’s the best advice you’ve ever received?
My family and my friends provided me with a lot of advice and support and I am greatly thankful for them being present in my life. But I do like the following quote:
“The more things that you read , the more things you will know. The more you learn, the more places you’ll go.” – Dr. Seuss


I’m Mark Heppell and this is how I work

Mon, 2015-04-20 09:00

Next up in the 2015 ‘How I work‘ series is Mark Heppell. Mark is one of Cedar’s longest serving employees having been with us for 16 years. As a consequence he’s been on almost all our client sites, so he’s one of our better known and most beloved consultants.

Mark is one of Cedar’s key PeopleSoft developers and is one of the first people that we all turn to when there’s something beyond our abilities. He’s currently waist deep in some great looking Fluid work (I’ve had a sneak peak).

Profile

Name: Mark Heppell

Occupation: Lead Technical Consultant
Location: Home office, Marlow, UK
Current computer: Dell Latitude E5520 laptop and Acer Aspire X3400 desktop
Current mobile devices: iPhone 4, iPad Air

What apps/software/tools can’t you live without?
I love any home automation gadgets.  I’ve got solar panels automatically turning on immersion heaters and everything in the lounge is controlled from my iPad.  It’s kind of an insurance policy, because without me, my wife can’t turn on the TV and would be sitting in darkness.

Besides your phone and computer, what gadget can’t you live without?
I’m not sure if it’s actually a gadget but if the broadband ever went down I think my teenage son’s world would end.

What’s your workspace like?
It’s good.  With Remote Desktop and Skype there’s very little need for me to leave my house.  If I get lonely I talk to the bonsai.

WorkPlace

What do you listen to while you work?
At the minute I’m listening to Imagine Dragons, Hozier and AWOLNATION, or I just put on the radio.

What PeopleSoft-related productivity apps do you use?
The usual PeopleSoft stuff, App Designer and SQL Developer.  Paint.net if I have to do any graphics, Notepad++ for html and trace files, FileZilla for Unix and ExamDiff for file comparisons.  With the advent of Fluid I seem to be spending more and more time looking at browser developer tools, generally Firebug for day to day stuff and Chrome for mobile device emulation.

Do you have a 2-line tip that some others might not know?
When creating javascript use something along the lines of
javascript:%SubmitScriptName(%FormName,..
or your javascript won’t work when the user clicks the “New Window” link.

What SQL/Code do you find yourself writing most often?
Working with HR,
Select * from PS_JOB J where J.EFFDT=(Select Max(J_ED.EFFDT) from ......,
will generally make an appearance a couple of times a week.

What everyday thing are you better at than anyone else?
Better at than anyone else is a bit of a stretch, but I do seem to end up with the more complicated/abstract client requests.

What’s the best advice you’ve ever received?
I’m sure my Dad gives me some wonderful advice, but he’s a Geordie and I can only understand 1 in 3 words he says.


Faster Download of PeopleSoft Images

Wed, 2015-04-15 10:32

With the advent of Selective Adoption, many more people will be downloading the huge PeopleSoft Images every 10 weeks or so. They’re large (circa 35GB) and that’s going to take a while even with a decent connection.

What makes matters worse is that the default method (clicking the Download All button) runs the downloads in serial. Even on a 1MB/sec connection that’s going to take ~10 hours to download all 35GB.

Download All

In addition, the download seems to be throttled somewhat, I’m not sure why. The speed reported in the above window varied wildly between 100KB/s and 500KB/s. Even at the top end of that range, only downloading one at a time it’s going to take almost 24 hours for the complete set.

An alternative is to run the downloads in parallel. Instead of clicking Download All, click WGET Options and download the script instead. After a little modification so that it ran on Windows I was able to run 4 copies of the script side-by-side, giving gains not only by downloading in parallel, but the downloads ran faster too:

Download All parallel wget

You can click for a bigger version, but basically the screenshot is of four downloads with a combined download speed of over 4MB/s! All downloads completed in a touch over 2 hours (and this is on a home broadband connection).

 


Cedar’s exciting new office

Tue, 2015-04-14 17:39

Today I got my first glimpse of Cedar’s new UK head-quarters in use. I’d seen it during the renovations, however now the work is complete and we’ve started to move in properly it’s really exciting to see people actually using it for real.

Main Office(Travis, Pete, Hardik and Kirti making themselves at home)

I’m particularly pleased that we’ve managed to purchase an office that’s still got the same great location as our previous premises, but is ours to decorate as we wish (witness the fantastic mural in the background of the above photo).

The full details, including some more photos are available here:

http://www.cedarconsulting.co.uk/news-details/April-2015-Cedar-Moves-to-New-UK-Head-Office/index.html