Special Issue:
Oracle Release 12 Processing Deadlines
The Administrative Systems eNews is a monthly electronic newsletter for users of Harvard's financial, human resources, and reporting systems.
Contact us at: admin_systems_enews@harvard.edu or via the UIS Helpdesk at 6-2001
Financial Administration (FAD) Oracle Release 12 Upgrade Schedule
The University Oracle Applications will be unavailable from 5:00 pm Friday, November 16, 2012 until Monday, November 26, 2012. Please review the following for special processing deadlines, cutoff dates, and system and support availability, leading up to and through the upgrade period.
Some Financial and Sponsored systems/applications will be up during the upgrade; however, transactions will not be posted to the General Ledger, or refreshed into the CREW and DWCENPRD ad hoc reporting environments until after the Upgrade on November 26. The University Help Desk (617-496-2001) and FAD staff will continue to be available. On-call resources will be available 24/7, as usual. Online materials, such as those found on Eureka, iSites and ABLE, will be available 24/7, as usual.
Future issues of e-News will cover additional information concerning the upgrade, including contingency and emergency payment criteria, training schedules and the impact of the upgrade on other systems, such as PeopleSoft, HUBS, GMAS, etc.
| Departments and Systems | November Oracle Release 12 Upgrade Schedule Changes |
|
Contact: A/P: option 1 Vendor Setup: option 3 |
Invoices already in the AP system that come due for payment between November 19 -30, 2012 based on payment terms, will be paid on Friday, November 16, 2012. Approved vendor invoices that need to be paid by November 23, 2012 (rent, utilities, etc.) must reach AP at 1033 Mass Ave. by Noon on Tuesday, November 13, 2012. This includes any HCOM Payment Requests you may want to have paid prior to the upgrade. Invoice Feeds will be processed through 5:00 PM on Friday, November 16th. Feeds submitted from November 16th - November 26th should be given unique extensions so files are not overwritten. HCOM:The last day to create a new HCOM request is Friday, November 16. Note that while you can create Payment Requests until November 16, any approved vendor invoices you wish paid prior to the upgrade must be received no later than noon, Tuesday, November 13. Specifically, this means the following:
During the Upgrade, no transactions will be processed in HCOM. Emergency transactions will be managed on an individual basis, and will need to meet guidelines that will be established for exception processing as a result of this upgrade. Any electronic invoices transmitted, or invoice import batches will not be processed until after November 26, 2012. Shoppers will not be able to receive goods in the system during this period. All HCOM transactions, with the exception of incomplete change requests, are expected to carry over in HCOM after the upgrade. Standard Check Payments: Previously approved requests for Payment received by November 13, 2012 will be processed. Voided Checks: All checks that need to be voided and re-issued must be received by AP no later than noon Wednesday, November 14 for the check to be re-issued on November 16, 2012. Stop Payment Checks: The last date for Stop Payment requests for processing is Friday, November 16th at Noon. Non-standard check processing (Special Handling requests) received at 1033 Massachusetts Ave, 2nd floor by 5PM on November 14, will have a check available for distribution on November 16, 2012. Vendor Setup, Maintenance & Reactivation: New requests or updates needed to meet the above deadlines must be submitted online and approved in Oracle by 5 p.m. on Tuesday, November 13th. Foreign Currency Drafts and Wires: HCOM payments to be made in foreign currency must be entered and approved by the Tub and the related invoices must be received by AP at 1033 Mass. Ave. no later than Noon on Tuesday, November 13. Please note that a bank draft authorization or a wire transfer form must be attached to the front of the invoice. US Wire Transfers: HCOM payments to be wire transferred must be entered and approved by the Tub and the related invoices must be received by AP at 1033 Mass. Ave. no later than Noon on Tuesday, November 13. Please note that a wire transfer authorization form must be attached to the front of the invoice. |
|
Contact: |
1. Reimbursements:
2. Citi Direct Pay Transactions: Citi Direct Pay must be entered and approved by the Tub and the required documentation must be received by Reimbursements at 1033 Mass. Ave. no later than Noon on Friday, November 9. 3. Citi Credit Transactions: Citi Credit must be entered and approved by the Tub and the required documentation must be received by Reimbursements at 1033 Mass. Ave. no later than Noon on Friday, November 9. 4. WR Travel Authorization (WV-TAF's): The last day to create/approve a WR-TAF is by Noon on Friday, November 16th. Any Citi Direct or Citi Credit transactions created in Web Reimbursement between November 9 and November 16 will carry over in the Release 12 upgrade. The transactions will not be processed until after the upgrade. Note that Citi Combo transactions created between November 9 and November 16 will have to be re-entered into Web Reimbursement after November 26. |
|
Contact: |
Invoices to be entered by Central AR must be received by 5 p.m. Thursday, November 15 to ensure posting prior to the Upgrade. The deadline for customer setup/maintenance is also 5 pm Thursday, November 15. Manually entered invoices completed in Oracle AR before 4:30 pm on Friday, November 16th, will be posted prior to the Upgrade. No Invoices will be able to be entered into Oracle AR until Monday, November 26 when regular processing resumes. Invoice Feeds will be processed through 5:00 PM on Friday, November 16th. Invoice Feeds submitted from November 16th - November 26th should be given unique extensions so files are not overwritten. |
Authorized Requestor Information Contact:Oracle Authorized Requestors: appadmin@camail.harvard.edu |
User security & CVR requests received after 5pm on November 15th will be processed after the Upgrade beginning November 26. |
|
Contact: |
Budget Tool input and upload entries entered by 5 p.m. Friday, November 16 will post and be included in the nightly data refresh of the CREW and ad hoc reporting environments. |
|
Contact: |
CAPS forms submitted after close of business (5pm) Friday, November 16 will be held in queue until Monday November 26. Any changes to CAPS forms (including budget detail) will not be reflected in CREW until Wednesday, November 28. |
|
Contact: |
Credit Vouchers: Credit Vouchers will continue to be received and deposited in the Bank through Wednesday, November 21st. These transactions will be entered into Oracle after the Upgrade during the week of November 26th. |
Chart-Security Maintenance Application (CSMA) / Chart of Accounts / Oracle Security Contact: |
Chart of Accounts Requests: |
General Ledger / General Accounting Contact:Joe DeCristoforo, 5-4592 |
Any journals entered by 5:00 p.m. and journal feed files sent before 5:00 p.m. on Friday, November 16th will be posted and included in the Friday night data refresh of the CREW and the ad hoc reporting environments. They will be reflected in the CREW and ad hoc reporting environments on Saturday morning November 17. Journal feed files sent during the Upgrade from after cutoff on November 16th through Monday November 26th, will post on Monday night, November 26th and be reflected in the CREW and ad hoc reporting environments on Tuesday, November 27th. Feeds submitted during the break should be given unique extensions so files are not overwritten. |
|
Contact: Customer Service 5-8500 (option 6) |
Due to the Upgrade, the PCard sweep originally scheduled for Thursday, November 15th will be moved to Wednesday, November 14 at 3:00 pm. The sweep originally scheduled for Thursday, November 22 sweep will be moved to Thursday, November 15 at 3:00 pm. |
Reporting - Financial, Sponsored and Student and Human Resources Ad Hoc ( Fiscal & Sponsored and Human Resources) CREW- (Fiscal & Sponsored, Student and Human Resources) |
CREW Financials, Sponsored and Student: Friday, November 16th, 5 pm CREW HR Reports and Interactive Reporting HR Data: Friday, November 16th, 8 pm, Sunday, November 18, 8 pm and Monday, November 19, 8 pm |
Tag: Oracle
Summary Schedule for Processing Transactions Prior to Oracle Release 12 Upgrade and Reporting
This is the summary schedule for all transactions and reporting deadlines prior to the Oracle Release 12 Upgrade. Please click on the Print button found at the bottom of this article if you wish to print a version for quick reference.
|
Date |
Time |
Event |
Fri. Nov. 9 |
12 p.m. |
• All Approved Reimbursements and required documentation must be received at 1033 Massachusetts Ave, 2nd floor. Any Reimbursement Requests received that do not meet the audit requirements will be returned to the Tubs and will have to be re-entered by the Tub after November 26, 2012 |
Tues., Nov. 13 |
12 p.m. |
• HCOM payments to be made in foreign currency (drafts and wires) must be entered and approved by the Tub and the related invoices must be received by AP at 1033 Mass. Ave., 2nd Floor. Please note that a wire transfer authorization form must be attached to the front of the invoice. |
5 p.m. |
• Previously approved Payment Requests with all required documentation for Standard Check Payments will be processed |
|
Wed., Nov. 14 |
12 p.m.. |
All checks that need to be voided and re-issued must be received by AP for the check to be re-issued on November 16, 2012. |
3 p.m. |
PCard sweep for transactions loaded between October 25-November 2 |
|
5 p.m. |
Non-standard check processing (Special Handling requests) received at 1033 Massachusetts Ave, 2nd floor will have a check available for distribution on November 16, 2012. |
|
Thurs., Nov. 15 |
3 p.m. |
PCard sweep for transactions loaded between November 3-November 14 |
5 p.m. |
• AR Invoices to be entered by Central Accounts Receivable must be received by AR at 1033 Massachusetts Ave., 2nd Floor to ensure posting prior to the Upgrade |
|
Fri., Nov. 16 |
12 p.m. |
• Last date/time for processing Stop Payment requests prior to the Upgrade |
4 p.m. |
Last date/time to post any new sponsored accounts in GMAS prior to the Upgrade. |
|
4:30 p.m. |
Manually entered invoices completed in Oracle AR by this date/time will be posted prior to the Upgrade |
|
5 p.m. |
• Invoices already in the AP system that come due for payment between November 19 - 23, 2012 based on payment terms, will be paid |
|
8 p.m. |
Normal HR data loads processed |
|
Fri., Nov. 16-Mon., Nov. 26 |
9 p.m.-6 a.m. |
• AP Feeds submitted should be given unique extensions so files are not overwritten |
Fri., Nov. 16-Wed., Nov. 23 |
9 p.m.-5 p.m. |
Credit Vouchers will continue to be received and deposited in the Bank. These transactions will be entered into Oracle after the Upgrade during the week of November 26th. |
Fri., Nov. 16-Mon., Nov. 26 |
9 p.m.-6 a.m. |
The Oracle E-Business Suite will be unavailable. The following applications will not be accessible during the Upgrade period: |
Sat., Nov. 17-Tues., Nov. 20 |
8 a.m.-5 pm |
CREW and Interactive Reporting for Financials, Student and Sponsored reflecting data as of Friday, November 16th, 5 pm available; Financials, Sponsored and Student reports reflecting data as of 5 pm, Friday, November 16th available in Interactive Reporting |
Sat., Nov. 17 |
8 a.m. |
CREW HR Reports and HR Interactive Reporting data available |
8 p.m. |
Normal HR Processing Load into Data Warehouse |
|
Sun., Nov. 18 |
8 a.m. |
CREW HR Reports and HR Interactive Reporting data available |
8 p.m. |
Normal HR Processing Load into Data Warehouse |
|
Mon., Nov. 19 |
8 a.m. |
CREW HR Reports and HR Interactive Reporting data available |
8 p.m. |
Normal HR Processing Load into Data Warehouse |
|
Tues., Nov. 20-Monday, Nov. 26 |
5 p.m.-8 a.m. |
CREW Financials, Sponsored and Student reports unavailable. CREW report outputs run prior to 5 pm will be accessible during this time period. Interactive Reporting application available, but access to financials, student and sponsored data unavailable as the databases will be locked |
Tues., Nov. 20 |
8 p.m. |
CREW HR reports unavailable; Interactive Reporting available but access to HR data unavailable as the database will be locked |
Wed., Nov. 21-Sun., Nov. 25 |
8 a.m.-8 p.m. |
CREW HR Reports and Interactive Reporting HR reflecting data as of Monday, November 19th, available |
Fri., Nov. 23 |
8 p.m. |
Data that has been fed into the Accounts Payable System, Accounts Receivable System, GMAS, and General Ledger between Saturday, November 17-Friday, November 23 will be processed through the data warehouse |
Sun., Nov. 25 |
8 p.m. |
HR Data Loads resume |
Mon., Nov. 26 |
6 a.m. |
Oracle E-Business Suite available and financial processes resume. |
8 a.m. |
Journal feed files, AP feeds and AR Feeds submitted during the upgrade will be reflected in the CREW and Ad Hoc reporting environments. CREW HR Reports and Interactive Reporting HR Data available as usual |
|
8 p.m. |
Resumption of Regular Nightly Load Schedule to CREW Financial, Sponsored, and Student Reporting, as well as Financial Ad Hoc reporting environments. |
|
Wed., Nov. 28 |
8 a.m. |
Any changes to CAPS forms (including budget detail) submitted after close of business (5pm) Friday, November 16 will be reflected in CREW. |
Tag; Oracle
Oracle Release 12 Upgrade
The Oracle E-Business Suite Applications will be upgrading from Oracle Release 11i to Oracle Release 12 in the late fall of 2012. Please see article 1 for the latest update concerning the Release.
The Oracle Financial Applications are:
CREW FIN Releases
The Common Reporting Environment for the Warehouse (CREW) is a reporting system that draws data from a variety of sources which are updated on a nightly basis. Users can submit report requests for immediate processing or schedule reports to automatically run on a recurring basis. Types of CREW reports include financial, budget, receivables, HR management, benefits, costing, payroll, pension, security, grants management, and sponsored reports.
The next CREW FIN release, 3.2.18, is scheduled for October 2012. Details will be available in an upcoming issue of e-News.
HR (PeopleSoft)
PeopleSoft Version 9.1 was implemented on April 23, 2012.
HDW HR Release 33
The HDW HR 33.0 Release is tentatively scheduled for September 2012. Details will be available in an upcoming issue of e-News.
CREW Reports
In addition to the CREW Financial and CREW HR releases which correspond with the FINDINI and HR releases listed above, changes and enhancements to new and existing CREW reports are also released the 3rd weekend of each month.
| Release Number | Dates | Notes |
| 8.8 | 8/25//2012 |
Sponsored Systems Releases
HUBS Releases
The Harvard University Budgeting Sytems (HUBS) is a set of web-based Oracle Planning applications used for budget data entry, estimates, annotations, reporting, and submission associated with the annual budget and planning cycles.
HUBS 2.1 was released May 18-20, 2012. Please see the May e-News for more information.
About the e-News
The Center for Workplace Development publishes this electronic newsletter for users of Harvard University's financial, HR, and reporting systems, policies, and procedures. The e-News is generally published on or around the 15th of each month.
It contains:
We welcome questions and suggestions for improvement from readers. If your questions are of general interest, we will answer them in future issues.
Please send comments, questions, or suggestions for improvement by email to us at: admin_systems_enews@harvard.edu.
For information about subscribing or unsubscribing to the eNews notifications, visit our who gets the eNews page.