WorkingScripts

The Stuff that Just Works

WorkingScripts header image 5

Entries from May 30th, 2009

Introducing PSUnit – Automate Your Testing

May 30th, 2009 No Comments

It seems that PeopleSoft is really becoming object oriented – now it has it’s own automated unit testing  tool, like JUnit – this one is called PSUnit. I hope this one is as good as it sounds. Check out the Wiki article below
Introducing PSUnit – Oracle Wiki
You can download the actual project file here:
http://blogs.oracle.com/peopletools/2009/03/psunit_unit_test_framework_for.html

Tags:  

PeopleTools 8.50 Roadmap

May 30th, 2009 1 Comment

 
Take a look at this great post by  Peter Slager about upcoming PeopleTools release
And here you can find the latest about PeopleTools 8.50 from Oracle – just an overview of things to come:
Release Value Propositions available
By matthew.haavisto on May 14, 2009 1:58 PM
Two new release value propositions are now available: one covers PeopleTools 8.50, another [...]

Tags:  

nVision Performance Tuning

May 23rd, 2009 No Comments

As many PeopleSoft developers and managers I have suffered through my share of nVision Tuning efforts and until very recent we could not get our reports to run under 4 hours, until the recent change… In any case here are a few points from my experience: We experienced an almost [...]

Tags:   ·

SQR – PRINT-IMAGE & IMAGE-SIZE

May 23rd, 2009 No Comments

 
After searching the Web, I have found that there is not enough documentation about IMAGE-SIZE of the PRINT-IMAGE command, or I have not done the search right ;-). Either way here it goes in plain English: Excerpt from the Book:

1: PRINT-IMAGE

2: Syntax

3: PRINT-IMAGE[image_name]position

[...]

Tags:   ·

PeopleSoft Debugging Techniques – Part I (Batch)

May 23rd, 2009 No Comments

I would like to briefly describe some of the PeopleSoft  debugging techniques that I have used and found invaluable during development batch and online programs.
SQR Debugging

Flag

Description

-S
Choose Append Option on Parameter List of Process Definition. All of your SQL statements – simple and clear + execution counts

–debug(flag)
Choose Append Option on Parameter List of Process [...]

Tags:   · ·

Technorati Profile

May 22nd, 2009 No Comments

Just adding thisblog to my technorati profile:
Technorati Profile

Tags:

PeopleSoft for DBA Part 1

May 22nd, 2009 No Comments

Here a great presentation by David Kurtz the author of the
“PeopleSoft for the Oracle DBA”.  It has a few nice things that DBA should know, especially PeopleSoft DBA. I hope you enjoy this and share with others let me know if you have any questions and I will try to post more original and hopefully [...]

Tags:   ·

PeopleSoft and Fusion Platform

May 22nd, 2009 No Comments

This is an Oracle presentation from some time ago but I think it has a good overview of the Fusion Technology and general product direction that is still valid. It talks about how Fusion plugs into PeopleSoft and other architectures, XML Publisher etc.
http://www.scribd.com/doc/15708929/Technology-Directions-Oracle

Tags: PeopleSoft DBA

Tags:   · ·

Oracle Hosted PeopleBooks – at last

May 22nd, 2009 No Comments

At last Oracle has posted a full collection of the latest version of all peoplebooks with a powerful search. Here is a link to it, once you try it you would not go anywhere else. Here is a link:
Oracle Hosted PeopleBooks: http://www.oracle.com/pls/psft/homepage 
But in case you like to carry your stuff around on your hard drive [...]

Tags:   ·

Task Manager, System Monitor – best thing for DB2

May 22nd, 2009 No Comments

One of my colleagues have introduced me to this utility and we had our DBAs install it on the system, and voila – you can see DB2 in works: it’s running snapshots online, you can see bufferpools usage, your top processes and much much more. Here is a link to a IBM page that has [...]

Tags:   ·