1 / 44

Some Cool Tools for the PeopleSoft Support Team

Some Cool Tools for the PeopleSoft Support Team. Session #20649 March 13, 2006 Alliance 2006 Conference Nashville, Tennessee. Stanford University. Founded in 1891 Private university 6,753 undergraduate 8,093 graduate 1,775 faculty 7,565 staff

yamin
Download Presentation

Some Cool Tools for the PeopleSoft Support Team

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 Developer’s Page • PS Security Page • PS Status Page

  7. Administrator’s Page

  8. The Cool Tools

  9. The Cool Tools

  10. 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 PS Developer’s Page Allows developers to

  11. PS Developer’s Page

  12. PS Developer’s Page - SQR

  13. PS Developer’s Page - Upload

  14. PS Developer’s Page - Display

  15. PS Developer’s Page - Download

  16. PS Developer’s Page – App Server Logs

  17. PS Developer’s Page – Process Logs

  18. PS Developer’s Page – SQR Output

  19. PS Developer’s Page – SQR Output 2

  20. PS Developer’s Page – SQR Output 3

  21. PS Developer’s Page – Cobol Output

  22. PS Developer’s Page – App Engine Output

  23. PS Developer’s Page – SQR Input

  24. PS Developer’s Page – SQR Input 2

  25. PS Developer’s Page – Database Objects

  26. PS Developer’s Page – PL/SQL Packages

  27. PS Developer’s Page – PL/SQL Procedures

  28. PS Developer’s Page – PL/SQL Functions

  29. PS Developer’s Page - Triggers

  30. PS Developer’s Page – Search for Files

  31. PS Developer’s Page – Stored Statements

  32. PS Developer’s Page – Explain Plan

  33. PS Developer’s Page – Explain Plan

  34. Enterprise Portal Campus Solutions (HR & Student Administration) Learning Management System Roles Permission Lists Oracle DB Roles & Users Navigation for SQRs Security Page Displays security for

  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@stanford.edu • Jeff Butler • Lead System Analyst, Student & HR Systems • Stanford University • E-mail: jbutler@stanford.edu • Carol Jordan • Manager, Technical Infrastructure • Stanford University • E-mail: cajordan@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

More Related