DokuWiki - hrms-sfis-upgrade

archived_notes

Anonymous (anonymous@undisclosed.example.com) — 2007-01-31T18:01:03+00:00

OLD NOTES --- Steven Machuga 2007/01/31 13:00 List of Questions for Vendors, Institutions and Friends * Hardware * Operating Systems * Oracle Version (10g v. 9) * Timelines * Personal Data Table v. New Biographical Table adaption * Patch Level Prior to Upgrade

archived_schedule

Anonymous (anonymous@undisclosed.example.com) — 2007-03-07T21:35:26+00:00

December 2006 --- Steven Machuga 2007/01/31 09:34 * 12/9-12/10 Maintenance Packs * 12/11 Database released to Upgrade Team * 12/11 Tom/Uday Compile list of Issues * 12/12 List of Problems released * 12/19 Meeting (Uday returns to campus) * Review PeopleSoft environment and Wes Mods

interim_portfolio_steps_for_go_live

Anonymous (anonymous@undisclosed.example.com) — 2007-07-16T14:01:37+00:00

Steps to initiate the Interim Portfolio for the go-live weekend * Backup PSPROD 81 database on Fuji (~45 minutes) * Stop the listener on Fuji; rename the listener log to start fresh; restart the listener (while the backup is happening) * Alter the sqlnet.ora, tnsnames.ora on the interim portfolio machines, locally redirecting the tns entries PSPROD and SFIS to PS81TRNG on Bigsky.

main

Anonymous (anonymous@undisclosed.example.com) — 2007-06-13T20:29:27+00:00

Links * Main Tasks and Schedule * Changed PL/SQL List * Custom Menus and W89 Projects * List Autosys Jobs * CVS Information * Citical Path Tasks * Sources of Objects for PS8.9 Upgrade * Upgrade Issues Database * Barbara's Process Scheduler document * Upgrade Problem List (is this being used?rpl) * Test Portfolio Review * Developer Database Link page * User Database Link page

main_tasks_and_schedule

Anonymous (anonymous@undisclosed.example.com) — 2007-07-31T21:28:26+00:00

CVS Information Post Go-Live Issues 7/31/2007 * Tom is working getting the SQLServer/Oracle Connection Issues as well as Database Issues. * Steve is working on putting up the stand-by database and database copies. * Darrell is squaring away the CIGNA, Fidelity files and transfers.

mod_plsql

Anonymous (anonymous@undisclosed.example.com) — 2007-07-11T20:11:57+00:00

PLSQL Modified Objects SchemaObject Name User Description SYSADMWES_GET_ETHNICITYDAKChanged ethnicity_code to ethnic_grp_cdSYSADMWES_GET_WESPODAKModified to use new xlat tableSYSADMWES_GET_NAME_PARTSDAKModified to use new xlat table/ GBROWN 3/9/2007 in Function valid_name_type changed to use ps_HCR_NM_TYP_I as cursor

problems

Anonymous (anonymous@undisclosed.example.com) — 2007-01-30T21:17:15+00:00

Upgrade Problems Upgrade Issues Database * NAME_FORMAL in PS_NAMES should not contain the NAME_INITIALS! (ie my name_formal is “Daniel DK Koepf” ) * The PS_ORG_APPL_VW should not contain multiple rows for effective dated names. * LOC_ADDR is now in a table called ADDRESSES_SA. Is that table maintained interactively or where does it come from? I have built a new view wes_ps8_address which joins the two tables.

task-db

Anonymous (anonymous@undisclosed.example.com) — 2007-01-31T14:57:12+00:00

Unassigned * unassigned example 1 Steve In Progress * Example 1 Done * Done Example 1 Tom In Progress * ===== Upgrade Issues Test Move 1 ===== * ps_item_line_sf (item_line_sf) must have its Indexs Rebuilt prior to doing the next test move. This should be done in production. This is done in App. Designer.

task-fin

Anonymous (anonymous@undisclosed.example.com) — 2007-01-02T21:54:31+00:00

Unassigned * unassigned example 1 Barbara In Progress * Example 1 Done * Done Example 1 Rich In Progress * Example 1 Done * Done Example 1

task-hrms

Anonymous (anonymous@undisclosed.example.com) — 2007-02-14T17:38:58+00:00

Detailed Documentation <\\stowe\htmldocs\Upgrade to 8.9\Peoplesoft upgrade fixes\Peoplesoft Upgrade Fix Detail.doc> <\\stowe\htmldocs\Upgrade to 8.9\Peoplesoft upgrade fixes\HRMS FUNCTIONS AND PROCEDURES.DOC> Unassigned * Intermittent Employee Process - Not Used - Delete? * Manager's Tool Box Annette In Progress * Effective Dated Schedule Done * Academic Affairs * Health Center * Temporary Employee Process Darrell

task-portfolio

Anonymous (anonymous@undisclosed.example.com) — 2007-04-11T18:12:30+00:00

Portfolio Testing Meeting Notes 4/2/2007 I believe this is what we agreed to: * Mike Loegering (with Henk's help) will retrieve a list of “representative” sequel statements as executed in the perlly bowels of the portfolio (4/9/2007). * Mike will write a program to execute and review the results of the

task-sfis

Anonymous (anonymous@undisclosed.example.com) — 2007-03-20T18:05:05+00:00

Unassigned Registrar * Course Information Document * Drop/Add * Wesmaps Admissions * RDE panels * WES_ADM_SUSPN Campus Community * Student Security Dan In Progress * Admissions: Prospect Panels * Wesleyan Admission Inquire Panels

uday_list

Anonymous (anonymous@undisclosed.example.com) — 2007-08-10T16:23:14+00:00

1. Commitment Accounting w. Chris Andrews, Mary Kelly, Ed and/or Steve: Can you please contact Chris Andrews (x3153) to set up a time to pay him a visit. He and Mary Kelly have had intermittent, but frequent, problems getting a selected acct_cd to populate from the Chartfield Details sub-panel back to the main Commitment Accounting panel. I’d appreciate some help trying to troubleshoot this.

upgrade-cvs

Anonymous (anonymous@undisclosed.example.com) — 2007-01-30T21:54:07+00:00

Version Control Implementation External Documentation Links * Brandeis CVS Info * Quest Stat for PS * Subversion * Subversion Home Page