WorkingScripts

The Stuff that Just Works

WorkingScripts header image 5

Entries Tagged as 'PeopleSoft'

SQL for Retrieving Portal, Security, Record and Navigation

June 5th, 2009 No Comments

SELECT DISTINCT ltrim (rtrim (a.classid)) AS classid, ltrim (rtrim (b.menuname)) AS menuname, ltrim (rtrim (b.barname)) AS barname, ltrim (rtrim (b.baritemname)) AS baritemname, ltrim(rtrim(d.pnlname)) AS [...]

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

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

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: