Some Cool Tools for the PeopleSoft Support Team

1
Some Cool Tools for the PeopleSoft Support Team

• Session 20649
• March 13, 2006
• Alliance 2006 Conference
• Nashville, Tennessee

2
Stanford University

• Founded in 1891
• Private university
• 6,753 undergraduate
• 8,093 graduate
• 1,775 faculty
• 7,565 staff
• Located 30 miles south of San Francisco and just
  north of Silicon Valley.

3
Stanford University and Oracle

• Products currently installed
• Campus Solutions 8 SP1
• PeopleTools 8.22.05
• Enterprise Portal 8.8 SP1
• PeopleTools 8.44.03
• Enterprise Learning Management 8.8 SP1
• PeopleTools 8.45.12

4
Student HR Systems

• Student HR systems is part of Administrative
  Systems
• The infrastructure group is consists of a
• 1 - Manager
• 5 - system analysts,
• 3 - Oracle DBAs
• 2 - Windows Administrators.
• A separate group of developers are also part of
  Student HR Systems.

5
Overview

• Tools were developed to aid
• developers
• help maintain security
• monitor environments
• The Infrastructure Team Supports
• 6 learning management databases
• 5 enterprise portal databases
• 9 student administration databases

6
The Tools

• PS Developers Page
• PS Security Page
• PS Status Page

7
Administrators Page
8
The Cool Tools
9
The Cool Tools
10
PS Developers Page
Allows developers to

• Lookup Database objects
• PL/SQL
• packages
• procedures
• functions
• triggers
• Run Oracle Explain Plans

• Upload / Download
• SQR
• COBOL
• Log Files
• Input Files
• Check Security Setups
• Search for various objects

11
PS Developers Page
12
PS Developers Page - SQR
13
PS Developers Page - Upload
14
PS Developers Page - Display
15
PS Developers Page - Download
16
PS Developers Page App Server Logs
17
PS Developers Page Process Logs
18
PS Developers Page SQR Output
19
PS Developers Page SQR Output 2
20
PS Developers Page SQR Output 3
21
PS Developers Page Cobol Output
22
PS Developers Page App Engine Output
23
PS Developers Page SQR Input
24
PS Developers Page SQR Input 2
25
PS Developers Page Database Objects
26
PS Developers Page PL/SQL Packages
27
PS Developers Page PL/SQL Procedures
28
PS Developers Page PL/SQL Functions
29
PS Developers Page - Triggers
30
PS Developers Page Search for Files
31
PS Developers Page Stored Statements
32
PS Developers Page Explain Plan
33
PS Developers Page Explain Plan
34
Security Page
Displays security for

• Enterprise Portal
• Campus Solutions (HR Student Administration)
• Learning Management System

• Roles
• Permission Lists
• Oracle DB Roles Users
• Navigation for SQRs

35
Security Page
36
Security Page PS User Security
37
Security Page Database Security
38
PS Security Page SQR Security
39
PS Status Page

• This page provides
• Database Version
• Application Servers
• Process Schedulers
• Application Messaging
• Publication and subscription
• Links to the status for databases

40
PS Status Page
41
PS Status Page
42
Questions?
43
Contacts

• Ross Shimabukuro
• System Analyst, Student HR Systems
• Stanford University
• E-mail ryshima_at_stanford.edu
• Jeff Butler
• Lead System Analyst, Student HR Systems
• Stanford University
• E-mail jbutler_at_stanford.edu
• Carol Jordan
• Manager, Technical Infrastructure
• Stanford University
• E-mail cajordan_at_stanford.edu

44
This presentation and all Alliance 2006
presentations are available for download from the
Conference Site
Presentations from previous meetings are also
available