WorkingScripts

The Stuff that Just Works

WorkingScripts header image 5

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:   ·

Oracle and Social Media Networking

May 21st, 2009 No Comments

Oracle has become increasingly active with creating communities around its various software practices which includes PeopleSoft, Oracle Applications , JD Edwards and … other stuff Larry Ellison bought in the past 5 mins.
Here are a few that I have found to be useful :
Oracle Mix: http://mix.oracle.com
Oracle Wiki: http://wiki.oracle.com
Oracle OTN: http://otn.oracle.com
In case you would like to [...]

Tags:   ·

Browser Setup for Peoplesoft

May 21st, 2009 No Comments

I have found that a lot of users have intermittent problems with PeopleSoft browser compatibility. Some of those can cause a lot of unnecessary time spent troubleshooting these issues, i.e. spreadsheets are not being downloaded, pop-up blocker etc. These steps preferably should be implemented on the Domain Security policy level and given to HelpDesk personnel. [...]

Tags: