Contact us at:
fad_communications@harvard.edu
Or via the UIS Helpdesk, 6-2001


Special Oracle 11i Upgrade Edition
Nov. 15, 2002
Volume 4, Issue 8


Oracle Financials Release 11i  top

On Monday, December 2, the University will be releasing a major upgrade to its financial applications. This upgrade, which will move us from Oracle 11.0.3 to Oracle 11i, will introduce a new look and feel, new login techniques, and a new method of navigation for Web Voucher, General Ledger, Accounts Payable, Accounts Receivable, Budget Tool, AWS2, HUDINI, and Applications Administration.

In addition to the new Oracle features, the Web Voucher system has been completely redeveloped to improve performance and incorporate a number of enhancements that users have requested.

This special issue of the e-News will introduce you to the look and feel of the new systems. It provides specifics to help you through the transition, including a detailed list of the changes that you will see.

After reading this issue, we expect that current users should easily make the transition to Oracle 11i without retraining. However, users who would like a preview of the new systems can try our online simulations, which provide a guided tour of logging in, navigating, and creating a Web Voucher in Oracle 11i.

The two most significant changes are:

  • The introduction of Oracle's Personal Homepage, which gives users a single point of access to all Oracle systems, including Harvard's customized vendor payment and reimbursement system, Web Voucher.

  • A variety of updates to the Web Voucher system, including:
    • adjustments to the navigation and screen appearance so that Web Voucher will work seamlessly with Harvard's other Oracle applications
    • updates to Web Voucher terminology to eliminate the sometimes confusing purchasing language that was resident in the old system, and
    • user-requested enhancements to the copy line function, searching, and notifications.

This upgrade also represents significant "under the hood" changes to the technical architecture of the systems, which will take seven days to complete. To minimize the impact to the user community, the project team will perform the upgrade over the week of Thanksgiving (a system outage of only three business days).

In addition to the core financial applications, Bottomline, Windstar, PCard, the Chart Request system, the Chart Maintenance system, and the CoA Validator will all be down during the upgrade, since they rely on access to production servers. Key dates during the transition period follow.


Readiness Checklist    top

The key actions that you will need to take to be ready for the upgrade are to:

1

Make sure the new J-initiator software plug-in is installed on your computer.

2

Make sure that you have the Internet Explorer web browser on your computer.

3

Read through the key dates for the upgrade and plan your work accordingly.

4

View the online simulations that provide a tour of the system.

More details on each of these topics appear further down in this e-News.


Key Dates for the 11i Upgrade and
November Month-End Closing    top

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

The paperwork for all approved web vouchers must reach Accounts Payable in Holyoke Center 370 by 5 p.m. All invoices received after this time will be posted in December. Any web vouchers not approved by this time will not be converted, and will have to be recreated after the upgrade. All invoices processed by Accounts Payable that come due between November 22 and December 2 based on their payment terms will be paid on November 22.

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 5 p.m. 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 10 a.m. will be placed and a new check will be issued prior to shut down of AP. Any stop payment request received between 10 a.m. on November 22 through 5 p.m. 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 5-1647 for University policy on processing a manual emergency check.

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

At 6 p.m., 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 6 p.m.

Saturday, 11/23 - Wednesday, 11/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 5-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 5 p.m. 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 5-5693 or 5-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, 11/28 - Friday, 11/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, 11/30 - Sunday, 12/01

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, 12/02

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, 12/03

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, 12/04

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, 12/05

All systems should be working as normal.

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

Friday, 12/06

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, 12/09

This is the new month-end closing date for November.

Manual journal vouchers entered into the system by 8 a.m. 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, 12/10

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




Updates to the Desktop Standards    top

Concurrent with Harvard's upgrade to Oracle 11i, the following changes to our desktop standards will take effect.

  • An upgrade to J-initiator version 1.1.8.19 will be required to use Oracle financial applications and HUDINI.

  • Microsoft Internet Explorer will be the required browser to use all of the Oracle financial applications as well as the two reporting applications.

  • Netscape 4.7.x (where x>3) will remain the required browser for the PCard, HIRES, and HURIS systems.

Unless your password would normally expire between 11/22/02 and 12/02/02, there will be no need to change your password as part of this upgrade.

If you encounter a problem reading PDF files, you may need to adjust the settings in your Adobe Acrobat Reader. See the section on Reporting later in the e-News for details.

Installing the New J-Initiator

With the upgrade to 11i, a new J-initiator software plug-in (version 1.1.8.19) will be required to use the Oracle financial applications and HUDINI.

The new J-initiator is currently available for download from the UIS Helpdesk website and will be available for download from the VPF applications log-in page beginning December 2. The system will prompt you to install the new plug-in the first time you try to log in to one of the applications that requires it. The important thing to remember is to "just say yes" to the prompts provided by the system. Please note that abandoning the J-initiator upgrade routine after it has started may have an adverse effect on your system.

To install J-initiator version 1.1.8.19:

1

To install the J-initiator before December 2, download it from the UIS Helpdesk web page or get it from your local desktop support provider.

To install J-initiator after Oracle 11i goes live, go to the Financial Administration Applications page and click the J-initiator 1.1.8.19 link. (Note that the plug-in won't be on this page until December 2.)

Note: It is important that you download J-initiator from one of these Harvard sites since the plug-in has been customized for Harvard.

2

Save the installation file (oajinit11819.exe) to your desktop.

3

After you have downloaded and saved the file, quit IE.

4

Double-click the oajinit11819.exe file on your desktop to run the installer.

5

Accept the default answers to all of the installer's prompts and let it run. This may take a minute or two.

6

After the installer has finished, relaunch Internet Explorer.


Internet Explorer Is Now the Required Browser for Oracle Financial Applications

Beginning December 2, Internet Explorer (IE) will be the required browser to use all of the Oracle financial applications as well as AWS2 and HUDINI. IE 5.0 and 5.5 may be used, but IE version 6.0 will be the recommended, supported browser. Consequently, our desktop standards will be expanded to include the Windows XP Professional operating system.

Click one of these links to get help with:

Our thanks to the hardworking staff at the School of Public Health for putting this information together! Please note that these IE versions will also work with any of the PeopleSoft applications.


Oracle 11i Application Changes  top

All changes to Oracle that will affect the way users work in the systems are listed in the tables that follow.

Preview the New Systems  top

We have developed three online simulations to provide you with a hands-on guided tour of logging onto the new personal homepage, changes to navigation in Oracle 11i, and creating and submitting a web voucher in the new system. These simulations are available on ABLE and you can view them now from these links:

Note: Internet Explorer is required to run these similations as well as to use the 11i applications.

If you encounter a problem with running the simulations in Internet Explorer, try the following:

  • Select Tools > Options from your browser menu.
  • Click on the Advanced tab.
  • Scroll down the list to the Microsoft VM section.
  • Make sure that the JIT Compiler entry is checked. If it isn't, check the box then close and relaunch Internet Explorer.

If you have any other problems, please call the Helpdesk at 6-2001.

General Changes to Navigation  top
Feature / Change Description

Screenshot (if applicable)

Personal homepage

After December 2, when you log in to any of the Oracle financial applications, you will go through a new login window to the Oracle personal homepage.

The main menu of the personal homepage acts as a central point where you can log into any of the systems you have access to, as well as providing a link to the support documents on ABLE (through the button on the toolbar).

After logging onto the personal homepage, you can jump between all of the Oracle applications you have access to by returning to this page.

The main menu on the personal homepage is divided between Oracle Self Service applications (like Web Voucher and Web Voucher Reimbursement) and traditional Oracle forms-based applications (like General Ledger and Accounts Receivable).

Please note that you will still access AWS2, HUDINI, and any non-Oracle application separately from the Financial Administration Applications page.

Guide to accessing University financial systems

Oracle login page

Personal homepage

New VPF applications page

Oracle applications window All Oracle applications will run in a single "holder" window (called the Oracle applications window), rather than having multiple windows floating all over the screen.

Oracle applications window

Colored fields

Different colors are now used to denote different types of fields. For example:

  • White = a basic data entry field
  • White with green text = a field with drilldown capability
  • Yellow = a required field
  • Gray = a display only field
  • Blue = a searchable field
 
Navigation tabs Navigating between windows is now done by clicking tabs, making it easier to see what options are available to you. These are used primarily in the AR and AP systems.  
Drilldown and list of values buttons

The drilldown and list of values buttons are now adjacent to the fields that they work with rather than only being available from the toolbar.

The drilldown button will appear to the left of a field that has drilldown capability.

The list of values button, which has changed from to , will appear to the right of a field that will display a list of valid values for that field.

 
System alert for large queries A system alert has been added that warns you if you try to run a query that will have a large number of results, letting you cancel the query if desired.  
Right-clicking Right-clicking in Oracle 11i will open a window that displays common editing shortcuts.  
Toolbar

The Oracle toolbar buttons have been updated. A complete list of the new Toolbar buttons is available here.

One important note is that the icon, used in older versions of Oracle to switch between active responsibilities, is no longer available. To change responsibilities in Oracle 11i, you will need to select "Switch Responsibility" from the File menu.

See the Oracle applications window for a sample of the Toolbar icons
Function keys The function keys have not been changed. To get a list of all the function keys available, use Help > Keyboard Help while in an Oracle system.  
Web Voucher Changes  top
Feature / Change Description

Screenshot (if applicable)

Main menu

When you log into your Oracle personal homepage, you will see three Web Voucher options under the Self Service heading. If you click on any of these options, the appropriate Web Voucher tasks will appear as a sub-menu.

WV Main Menu:
  • Notifications
  • Create Web Voucher
  • Create Credit Memo
  • Copy Web Voucher
  • Edit Saved Web Voucher
  • Invoice Search
  • Open Requisitions/Vouchers
  • Requisition/Voucher History
  • Reprint Web Voucher

WV Reimbursement:

  • Notifications
  • Create Reimbursement
  • Create Employee Advance Request
  • Create Amex Direct Pay
  • Create Amex Credit
  • Create Travel Authorization
  • Copy Web Voucher
  • Edit Saved Web Voucher
  • Invoice Search
  • Open Requisitions/Vouchers
  • Requisition/Voucher History
  • Reprint Web Voucher

WV User Preferences:

  • Harvard Preferences
    • Default Approver
    • Default Account Coding
    • Create/Delete Notification Rules
  • Reimbursement Email Maintenance
  • Change Password

Personal homepage

WV main menu

WV Reimbursement

WV User Preferences

Terminology

Where appropriate, the old procurement terminology has been removed from Web Voucher and replaced with terms associated with Harvard's business practices.

Examples:

  • "Place Order Now?" has been replaced with "Submit Voucher Now?"
  • The terms "Requisition Number" and "PO Number" have been replaced with "Web Voucher Number"

 

Copy line

Users will be pleased to know that the Oracle 11i upgrade will combine the "Apply Changes" functionality with the "Copy Line" button. Therefore, you will no longer need to click "Apply Changes" before using "Copy Line."

Additionally, you can now enter the number of new lines you want directly onto the main Web Voucher window, rather than using the pop-up window (up to 10 at a time).

Create WV

Preferences

The WV User Preferences menu can be used to do the following tasks:

  • Set a default approver for your vouchers
  • Set default CoA coding that will be used in all of your vouchers (you can always edit the default coding when creating a new voucher, if necessary)
  • Create or delete notification rules
  • Set the email address that a reimbursement notification should be sent to
  • Change your password

The option to create notification rules is relatively new to Web Voucher and allows users to minimize the number of notifications they receive. These rules will cause certain types of notifications to be deleted after one day rather than five. This is especially useful for users who create and approve their own vouchers.

WV User preferences

Harvard preferences

Searching by invoice

Currently there are two invoice search options in Web Voucher: "Search by Invoice Number" and "Search by PO Number."

In Oracle 11i these have been combined into a single search. The new functionality lets users search by PO number, vendor name, invoice number, and/or date in a single screen. Here is a quick reference that shows you how to look up information in Web Voucher.

 
Notifications

In Oracle 11i, there are two updates to the WV notifications:

  • You can now forward multiple vouchers to another reviewer all at once, rather than one at a time.
  • An icon will appear next to any notification that requires an action, alerting you that you need to go into the notification.
Reassign notifications
Supplier search The supplier search is no longer case-sensitive, although your searches will run faster if you use all upper case.  
List of values button The list of values button has changed from to , making it consistent with the other Oracle applications.  
Error messages

Several system messages and alerts have been updated to be easier to understand. A complete list of all of the messages, why they would appear, and how to resolve them is available here.

 
Copy voucher

This function, which is relatively new to Web Voucher, allows users to make a duplicate of an existing web voucher and use the copy as a template to create a new voucher. You can copy any web voucher, regardless of whether it was for a payment or a reimbursement, submitted or incomplete, approved or rejected.

Once you have chosen a voucher to copy, the system will automatically create a new voucher (with a new voucher number) containing the exact information from the original voucher. You can then edit any field (except Supplier) or submit the voucher as is.

This feature is particularly useful for users who need to process periodic vendor invoices that are the same each month or each time they are billed.

 
Fiscal Budget Tool Changes  top
Feature / Change Description

Screenshot (if applicable)

Downloading a file

When downloading a file from the Fiscal Budget Tool in Oracle 11i, the system will no longer give the file a ".bgt" extension by default. You will need to change the default file name that appears, which will vary depending on your desktop configuration, and add the .bgt extension before saving the file.

 

Uploading a file

In Oracle 11i, the second browser window that opens during upload processing will not close until the file upload has finished.

 

General Ledger Changes  top
Feature / Change Description

Screenshot (if applicable)

Recurring journals

Depending on your security access, you may now be able to schedule automatically recurring journals. This option will appear on all user screens, but authorization to use it is limited.

 

Reversing a journal

When reversing a journal, the prefix has been changed from "Reverse" to "Reverses." Note that when searching for a journal after it has been reversed, you will need to enter the correct prefix.

 

Additional ADI alert When importing a journal, ADI will now alert you if an error occurs.  
Subledger inquiry and drilldown support

You can now drill down from the account balances screen (in the Account Inquiry form) and from journal entries to transaction details within Oracle Receivables and Oracle Payables (subledgers).

Sub-Ledger Analysis provides two additional windows (T Accounts and Summary Activity), which show transaction account coding. You can view these windows simultaneously or one at a time.

You can also drill down to a transaction within Oracle Receivables and Oracle Payables to the associated transaction details from GL journals or balances screens. The view accounting windows (T Accounts and Summary Activity) are available in the GL, AR, and AP modules.

T Accounts

Summary activity

Accounts Receivable Changes  top
Feature / Change Description

Screenshot (if applicable)

Accounting button

The accounting button is now called "distributions" on the transactions screen, making it more consistent with other Oracle applications.

 

Find / enter screen

This screen has been updated in many ways, including having the find screen come up automatically when you enter the customer screen. This will help all users, especially those responsible for customer maintenance. After your search completes, the "Match Results" screen will automatically appear.

When querying in the customer summary screen, the query results are listed numerically rather than alphabetically.

AR Find / Enter

Reporting Changes (AWS2, HUDINI, OLTP)  top
Feature / Change Description

Screenshot (if applicable)

Text reports

Reporting systems will no longer provide TEXT versions of reports after Oracle 11i goes live. Wherever there was a TEXT version only, a CSV version has been created, and wherever there was a TEXT and a PDF, a CSV has been created to replace the TEXT version.

In other words, for every report there will be at least a CSV, and in most cases a CSV and a PDF.

 

Opening a PDF

Users may encounter a problem with opening a report run in the PDF format. To avoid this problem, you will need to make the following change in your Adobe Acrobat preferences:

1. Close Internet Explorer.
2. Open Adobe Acrobat Reader.
3. Go to Edit > Preferences > General > Options.
4. Deselect "Display PDF in Browser."
5. Restart Internet Explorer.

You should now be able to view PDF files normally.

 

 


Getting More Help    top

As always, you can get help with using any University financial or reporting system by calling the UIS Helpdesk at 6-2001 or by reviewing the support documents on ABLE. New documents that reflect the Oracle 11i changes will be posted to ABLE by December 2.

 


e-News for PeopleSoft Users   top

PeopleSoft will be down from 5 p.m. today to 8 a.m. Monday, November 18 so that data processing of employee elections can occur. Please follow this link for additional news of interest to PeopleSoft users.


About the e-News   top

The Financial Administration publishes this semimonthly electronic newsletter for users of Harvard University's financial, HR, and reporting systems, policies, and procedures. Generally, the e-News is published on or around the 12th and 26th of each month.

It contains:

  • updates on projects underway to build or improve University administrative systems;
  • information about new University policies, procedures, and forms;
  • reminders about upcoming deadlines and cut-over dates;
  • tips and tricks for working more easily or productively.

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: fad_communications@harvard.edu