PeopleSoft Tipster

Following OpenWorld ‘08 I posted about some of the new functionality coming in PeopleTools 8.50, including partial page refresh, modal lookup and prompt dialogues, redesigned menu pagelet etc.

Oracle have now made the RVP available so we get a better idea of what is included in the release.

I’ve picked out a few things that I hadn’t heard about previously:

Maximum number of rows to return on search pages

Search pages will now contain an option to limit the number of rows returned.  The maximum is also configurable globally in PeopleTools Options.

64 bit only software

It seems from Tools 8.50 onwards that the hardware the components are installed upon will be 64-bit only.  No more installing a sandpit environment on your 32-bit laptop … [EDIT 17th May: It seems that running a 64-bit VM on a 32-bit host is possible with VM Ware, but not Virtual PC.  See comment below from Jim Marion.]

Parallel file deploy in CA

Finally!  This should speed up file copies.

Decoupling of PS_Home

It seems that there’ll be a read-only PS_Home with all of the binaries etc, and a seperate read/write config_home for the environment specific config files.

Graphical routings of messages

Should help troubleshooting Service Operations

Interactive PeopleCode debugger

It appears that during a debug session you’ll be able to change variables on the fly.  Pretty nice.

App Class method drilldown

Right-click and jump to the method, just like you can with PeopleCode functions.

New ‘Swan’ contemporary style sheet

A lick of paint for the UI ‘matching Oracle Corporate application standards’, whatevr they may be.  I hope that doesn’t mean the ‘mustard and blue’ that Oracle e-Biz suite users had for years.

Looking forward to it, roll on September …

This year the UKOUG PeopleSoft Conference has been split out from the Oracle Conference (last year it was in the same building, just on a difference floor).  We’ve also teamed up with the GPUG (the HCM Global Product User Group) so there’ll be an extra stream of content this year (HCM, Financials, Tech, Round tables and GPUG).

I’ve been for a few years running now and thoroughly enjoy it.  There’s always something new in the presentations (check out the agenda if you need convincing), it’s excellent for networking with fellow professionals, and there’s nothing like being able to coral some of the industry’s experts to answer a question or two from back at work.

Finally, there’s been a change of venue.  We normally have a contigent of overseas visitors, and seeing as it’s practically on the end of one of Heathrow’s runways it couldn’t be more convenient (just make sure you don’t bring swine flu with you!).

If you’re quick, the early-bird discount will save you a bit of money too …

Click here to register.

In a previous post I’ve spoken about the benefits of creating a custom Navigation Collection on your homepage.

(Note: this doesn’t need to be Enterprise Portal, this can be done in the HR/Financials/CRM/Student Admin application).

I also covered migrating your setup to other environments.  A step I neglected to mention is a common one, when colleagues enviously notice your productive new setup how do you easily apply it to their user profiles so they can benefit also?  Or perhaps you’re setting up a homepage to roll-out to the entire user community?

Here’s how you do it:

(more…)

Today I had the need to check something on an old Tools 8.18 / HR v8.3 environment that hadn’t been booted for many a year, and it was quite an eye opener.

The environment was hosted within an old VM, last touched in 2003 and it was fun to mess around and battle to get it booted.

Those of us that have been around for a few years will remember the old Tools 8.1x user interface with the breadcrumbs, but one of the surprises for me was how fast it runs on a modern laptop.  I gave it 1.5GB Ram and it absolutely flew!

(more…)

It can be a good idea to frequently take flat-file backups of your App Designer Projects, depending upon how reliable the infrastructure is at your site, and how frequently environments get refreshed from Production.  I’ve often thought “I wish that there was a shortcut for this procedure”, but have never done anything about it.

I recently chanced across the excellent PeopleSoft Wiki and noticed a batch file containing many command lines to control App Designer, including exporting projects to command line.

Now I’m not awfully keen on automating migration between environments (I like to run the compare reports and set the flags myself immediately before migration) but the exporting of projects caught my eye.

Using the same command line we can create a batch file that’ll loop through a list of projects and export them – one at a time – into a directory of your choosing.

Create a file in the same directory as the batch file with a list of the projects you wish to export (one on each line) named project_list.txt.  Then run the following batch file:
set pside=C:\Tools\bin\client\winx86\pside.exe
set export_path=C:\temp\exports\
set dbtype=ORACLE
set user=ddavies
set pwd=******
set srcdb=DEV
FOR /F %%a IN (project_list.txt) DO %pside% -HIDE -PJTF %%a -FP %export_path% -CT %dbtype% -CO %user% -CP %pwd% -CD %srcdb% -QUIET -AF 0 -DDL 1 -PPL 0 -CFD 0 -CFF 0 -LF %export_path%%%a.log
pause

Update: 2nd Feb
Anyone having the same issue as Jeff in the comments (where your project flags are set incorrectly and as a result the project gets copied, but not the objects) can set the flags via SQL.

UPDATE PSPROJECTITEM
SET COPYDONE = 0, TAKEACTION = 1
WHERE PROJECTNAME = ”;

One extra note, when you run the above SQL the results aren’t always immediately visible in App Designer. Sometimes I’ve had to shut it and re-open, and sometimes I’ve had to clear the cache also.

After seeing some of the slides and blog posts that followed Oracle Open World ‘08 I thought I’d put together a recap of what improvements Oracle are including in their next release.
(more…)

Have you stumbled across Stack Overflow yet?  It’s a great new website that fills a gap for the perfect place to post programming questions.

It is free, unlike Experts Exchange.

It isn’t rammed with adverts and link-spam, unlike PeopleSoftFans.

And it is a lot easier on the eye, more Web 2.0 and faster than IT Toolbox.

The site designers (including Joel Spolsky of Joel on Software fame and Jeff Atwood of Coding Horror), are themselves well known and respected individuals in the art of programming and UI design, and it shows.  It has lots of nice features, but I like being able to vote up answers and comments, so the better responses rise up the page.

It has only just come out of closed beta so there isn’t much on there for a niche like PeopleSoft yet, but once the answers start getting indexed by Google I imagine it’ll become the first stop for programming issues.  If we can get enough people treating this as ‘the site’ for PeopleSoft Q&A then I think we’d all be winners.

If you ask a question, make sure you tag it with ‘PeopleSoft’ so it’s wasy to find.

A nice spot to Grant Johnson of Amadensor for asking the first question.