WorkingScripts

The Stuff that Just Works

WorkingScripts header image 5

Entries Tagged as 'PeopleSoft'

PeopleSoft Security Logging

August 19th, 2009 No Comments

This question came up during the recent application security audit – how does PeopleSoft track user sign in attempts and locations.
Aside from the obvious PSOPRDEFN table there is PSACCESSLOG – this table has OPRID, LOGIPADDRESS, LOGINDTTM, LOGOUTDTTM columns that give you information about user sign on activity. LOGIPADDRESS will contain the RemoteAddr property  of  [...]

Tags:   ·

QuestDirect Conference Notes

August 9th, 2009 No Comments

I have not had a chance to write anything earlier – had to catch up with my primary responsibilities at work. But now I would like to give a short overview of QuestDirect OUIG Conference that I had a chance to attend.
I would like to start from the end and the good news for all [...]

Tags:   · ·

What Environment Am I in?

July 10th, 2009 9 Comments

As I was going through some of the sessions on the QUEST NORTHEAST CONFERENCE I noticed on of the presenters mentioning customizing Test environments Main PeopleSoft CSS PSSTYLEDEF so that the users are always able to distinguish between environments.
The solution that I have employ to solve this problem is to modify the PT_BRANDING:BrandingBase class to [...]

Tags:   · ·

Notepad++ for Peoplecode and SQR

June 10th, 2009 14 Comments

There are a few people who mention different tools for Application Development in PeopleSoft. Over the past years I have tried many of the IDEs like TextPad, UltraEdit. For the past 6 months I have started extensively using Notepad++ and I absoltely love it. Unfortunately App Designer does not include a good syntax highlighting, Intellisense [...]

Tags:   · · ·

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

Oracle’s Safari Online – Free Edition?

June 2nd, 2009 No Comments

It seems that Oracle have caught on with the Virtual Documentation, not only lots of books are available in common formats, but they allow you to format your search results as a book as well. Now you can take just what you need and read it on your screen or printed and stapled. I [...]

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

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