Some Cool Tools for the
PeopleSoft Support Team
Session #20649
March 13, 2006
Alliance 2006 Conference
Nashville, Tennessee
Stanford University Stanford University
• Founded in 1891Founded in 1891
• Private university Private university
• 6,753 undergraduate 6,753 undergraduate
• 8,093 graduate 8,093 graduate
• 1,775 faculty 1,775 faculty
• 7,565 staff 7,565 staff
Located 30 miles south of San Located 30 miles south of San
Francisco and just north of Francisco and just north of
Silicon Valley.
2
Stanford University and OracleStanford University and Oracle
Products currently installed:
Campus Solutions 8 SP1Campus Solutions 8 SP1
PeopleTools PeopleTools
Enterprise Portal SP1Enterprise Portal SP1
PeopleTools PeopleTools
Enterprise Learning Management SP1Enterprise Learning Management SP1
PeopleTools PeopleTools
3
Student & HR Systems Student & HR Systems
Student & HR systems is part Student & HR systems is part
of Administrative Systemsof Administrative Systems
The infrastructure group is The infrastructure group is
consists of a consists of a
1 - Manager1 - Manager
5 - system analysts, 5 - system analysts,
3 - Oracle DBAs 3 - Oracle DBAs
2 - Windows Administrators. 2 - Windows Administrators.
A separate group of developers A separate group of developers
are also part of Student & HR are also part of Student & HR
.
4
OverviewOverview
Tools were developed to aid
• developersdevelopers
• help maintain security help maintain security
• monitor environments monitor environments
The Infrastructure Team Supports
• 6 learning management databases6 learning management databases
• 5 enterprise portal databases 5 enterprise portal databases
• 9 student administration databases 9 student administration databases
5
The ToolsThe Tools
• PS Developer’s Page
• PS Security Page
• PS Status Page
6
Administrator’s PageAdministrator’s Page
7
The Cool ToolsThe Cool Tools
8
The Cool ToolsThe Cool Tools
9
PS Developer’s PagePS Developer’s Page
• Upload / Download
• SQR
• COBOL
• Log Files
• Input Files
• Check Security
Setups
• Search for various
objects
Lookup Database
objects
• PL/SQL
− packages
− procedures
− functions
− triggers
• Run Oracle Explain
Plans
Allows developers to
10
PS Developer’s PagePS Developer’s Page
11
PS Developer’s Page - SQRPS Developer’s Page - SQR
12
PS Developer’s Page - UploadPS Developer’s Page - Upload
13
PS Developer’s Page - DisplayPS Developer’s Page - Display
14
PS Developer’s Page - DownloadPS Developer’s Page - Download
15
PS Developer’s Page – App Server LogsPS Developer’s Page – App Server Logs
16
PS Developer’s Page – Process LogsPS Developer’s Page – Process Logs
17
PS Developer’s Page – SQR Output PS Developer’s Page – SQR Output
18
PS Developer’s Page – SQR Output 2PS Developer’s Page – SQR Output 2
19
PS Developer’s Page – SQR Output 3PS Developer’s Page – SQR Output 3
20
PS Developer’s Page – Cobol OutputPS Developer’s Page – Cobol Output
21
PS Developer’s Page – App Engine OutputPS Developer’s Page – App Engine Output
22
PS Developer’s Page – SQR InputPS Developer’s Page – SQR Input
23
PS Developer’s Page – SQR Input 2PS Developer’s Page – SQR Input 2
24
PS Developer’s Page – Database ObjectsPS Developer’s Page – Database Objects
25
PS Developer’s Page – PL/SQL PackagesPS Developer’s Page – PL/SQL Packages
26
PS Developer’s Page – PL/SQL ProceduresPS Developer’s Page – PL/SQL Procedures
27
PS Developer’s Page – PL/SQL FunctionsPS Developer’s Page – PL/SQL Functions
28
PS Developer’s Page - TriggersPS Developer’s Page - Triggers
29
PS Developer’s Page – Search for FilesPS Developer’s Page – Search for Files
30
PS Developer’s Page – Stored StatementsPS Developer’s Page – Stored Statements
31
PS Developer’s Page – Explain PlanPS Developer’s Page – Explain Plan
32
PS Developer’s Page – Explain PlanPS Developer’s Page – Explain Plan
33
Security PageSecurity Page
• Enterprise Portal
• Campus
Solutions
(HR & Student
Administration)
• Learning
Management
System
Roles
Permission Lists
Oracle DB Roles
& Users
Navigation for
SQRs
Displays security for
34
Security PageSecurity Page
35
Security Page – PS User SecuritySecurity Page – PS User Security
36
Security Page – Database SecuritySecurity Page – Database Security
37
PS Security Page – SQR SecurityPS Security Page – SQR Security
38
PS Status PagePS Status Page
This page provides:
• Database Version
• Application Servers
• Process Schedulers
• Application Messaging
• Publication and subscription
• Links to the status for databases
39
PS Status PagePS Status Page
40
PS Status PagePS Status Page
41
Questions?
ContactsContacts
Ross ShimabukuroRoss Shimabukuro
System Analyst, Student & HR SystemsSystem Analyst, Student & HR Systems
Stanford UniversityStanford University
E-mail: ryshima@-mail: ryshima@
Jeff ButlerJeff Butler
Lead System Analyst, Student & HR SystemsLead System Analyst, Student & HR Systems
Stanford UniversityStanford University
E-mail: jbutler@-mail: jbutler@
Carol JordanCarol Jordan
Manager, Technical InfrastructureManager, Technical Infrastructure
Stanford UniversityStanford University
E-mail: cajordan@-mail: cajordan@
43
This presentation and all Alliance 2006
presentations are available for download from the
Conference Site
Presentations from previous meetings are also availablePresentations from previous meetings are also available
