Quick Link to FAD E-News


Finance OfficeBulletin 11/9/02

1. University ORACLE Upgrade (11i) Coming in December
The November 15th edition of the FAD eNews is now available on-line at:

http://vpf-web.harvard.edu/training/enews/html/111502.html#article1

The bulletin contains important information relating to the ORACLE 11i upgrade. We encourage you to pay close attention to the key dates for the upgrade - specifically please note that all American Express corporate card payments must be received by the Travel Office by 5pm on Thursday, November 21st in order to be posted by the next cycle cut on November 26th.

What to Expect: The Timeline
Users will need to ensure that all web vouchers are completed prior to the system outage. Below is a timeline for the upgrade:

Thursday, November 21 All American Express corporate card payments must be received by the Travel and Reimbursement Office by 5PM in order to be posted by the next cycle cut on November 26.
Friday, November 22

All created/submitted web vouchers must be approved by the close of business before the upgrade. Any web vouchers not approved will not be converted, and will have to be recreated after the upgrade.

The Harvard Data Warehouse (HDW) and its related reporting systems will be available the week of Thanksgiving through Monday, December 2, with data as of November 22. All scheduled reports and request sets will be copied into the new Oracle 11i data warehouse and will not be lost. However, in preparation for the upgrade, all completed reports stored in the report status areas of AWS2 and HUDINI will be purged on November 23. Please print or save any reports you need to keep by 5PM on November 22.

November 22 is also the last day that many central financial processing services will be available prior to the outage. Accounts Payable, Accounts Receivable, General Accounting, Applications Administration, and Travel and Reimbursement services (including
Web Voucher Travel Authorization forms) will be suspended during the three business days before Thanksgiving. Please note that both AP Customer Service and Vendor hotlines will be unavailable during the Thanksgiving week outage.

Any stop payment request received by Cash Management by 10AM will be placed and a new check will be issued prior to shut down of AP. Any stop payment request received between 10AM
on November 22 through 5PM on November 27 will be placed at the bank but a check will not be reissued until December 2. In the event of an emergency please contact Michelle Sazo at 495-1647 for University policy on processing a manual emergency check.

All wire transfer requests must be submitted to Cash Management by 10AM. Please note that the associated web voucher must be approved in the system and all paperwork submitted to Cash Management prior to the 10AM deadline.

At 6PM, the General Ledger, Accounts Payable, Accounts Receivable, Applications Administration, Web Voucher, Budget Tool, PCard, CoA Web Maintenance Application, Bottomline, and Windstar systems come down. Cut off for ADI journal processing also occurs at 6PM.

Saturday, November 23 - Wednesday, November 27

Financial systems remain unavailable.

HDW and related reporting systems are available with data last refreshed as of close of business on November 22.

Wire transfers are unavailable and there will be no foreign drafts issued. In the event of an emergency please contact Cheryl Margey at 495-5471.

All credit vouchers received daily between November 22 and 12 noon on November 27 will be deposited daily to the bank, processed in AR, and posted to the GL for November. This is necessary to allow the staff in Cash Receipts adequate time to enter the credit vouchers in the AR systems.

All Mass Taxable Sales deposits should be deposited daily at the bank and delivered to Cash Management. All deposits received in Cash Management by 5PM on November 27 will be posted to the GL for November.

Requesting emergency checks to vendors is strongly discouraged. According to University policy, this service is limited to student emergencies, mortgage checks, and gold purchases. However, emergency checks can be processed manually during the business days of November 25-27 if authorized by the local unit Financial Dean or equivalent (on letterhead, with coding, authorizing signature, and original invoice provided) and delivered to the Director of Procurement for approval. You will be required to prepare a web voucher when the system comes back up on Monday, December 2.

All emergency check requests for student refunds or stipends must be made through the Students Receivable Office (SRO) by calling Mark Ford at 495-5693 or 495-2739. Once approved by SRO, emergency checks can be processed manually during the business days of November 25-27 if authorized by the local unit Financial Dean or equivalent.

Thursday, November 28 - Friday, November 29
(University holiday)
All offices are closed and financial systems are down.

HDW and related reporting systems are available with data last refreshed as of close of business on November 22.

Saturday, November 30 - Sunday, December 1 The project team performs testing of the 11i upgrade to confirm that it was successful. Any feed files sent to the General Ledger, Accounts Receivable, and Accounts Payable during the Thanksgiving week outage will be processed. If you plan to transmit multiple feed files during the outage, be sure to use a unique file extension to avoid writing over your own files.
Monday, December 2 Release 11i will be in production and OLTP systems available to the Harvard user community.

HDW and related reporting systems will be available with data as of November 22.

The HDW will be upgraded from version 11.0.3 to 11i overnight.

Tuesday, December 3 HDW upgrade to 11i complete.

HDW and related reporting systems will be unavailable, giving the HDW team time to identify and resolve any problems resulting from the upgrade.

Wednesday, December 4 HDW and related reporting systems will be available and will reflect all data entered on December 2-3 as well as any feeds that were processed during the previous weekend.
Thursday, December 5 All systems should be working as normal.

Feeds entered by 5PM on Thursday, December 5 that have Nov-02 indicated as the period will be processed in the month of November.

Friday, December 6 This was the originally planned month-end closing date for November. However, since users may need extra time to process their journal entries or run reports after the upgrade, the November month-end closing date will be extended until December 9.
Monday, December 9 This is the new month-end closing date for November.

Manual journal vouchers entered into the system by 8AM on Monday, December 9 will be processed in the month of November.

Reports or request sets run on or before this date will reflect October as the last closed month, not November.

Tuesday, December 10 Reports or request sets run on or after this date will reflect November as the last closed month.

What to Do to Prepare
Please take time now to plan your work around the system outage to ensure a smooth transition. Make sure your desktop will meet the standards published at http://able.harvard.edu/other/standards.shtml. Please read the information under the anticipated changes to these standards link. In summary, it says you will need a new version of J-Initiator and the Internet Explorer web browser to work in Oracle 11i.

Back to Top

 

2. PCard Settlement System
Due to the Oracle 11i upgrade, the PCard settlement system and local administration system will be unavailable from Friday, November 22 through Monday, December 2. This means that users will be unable to log onto PCard for the entire Thanksgiving week.

The originally scheduled PCard sweep for the week of Thanksgiving will be moved to the prior week. There will now be two PCard sweeps on the week of November 18:

  1. First Sweep: Wednesday, November 20 (will contain transactions loaded onto system from November 1 through November 7)
  2. Second Sweep: Thursday, November 21 (will contain transactions loaded onto system from November 8 through November 14)

All transactions to be swept on Wednesday will appear on the system by November 8. All transactions to be swept on Thursday will appear on the system by November 15. Please note, however, that the sweep dates in the settlement system cannot be changed until the last file for that date has been loaded. So, the system will show a sweep date for Thanksgiving week for five days or so during the week of November 11.

Back to Top

 



Harvard Medical School. Last Updated: November 2002. Send feedback to: foa@hms.harvard.edu