Oracle Overview Oracle system, information and links can be found at http://pegasus.binghamton.edu:6128/allapps.htm
Signing on to Oracle Applications

Project Manager - Project Costing
Project Manager - End User Reports
End user reports provides expenditure summary information for a specific project, broken down by its individual tasks, as well as actuals only (not commitments), equivalent to the data in the “Expenditure Inquiry” screen.





Expenditure Summary Report
The Expenditure Summary Report will provide the end-user with:
Expenditure Detail
The Expenditure Detail report will provide the end-user with expenditure detail, actuals only information for a specific project, broken down by its individual tasks and expenditure types.



Expenditure Detail Report
The Expenditure Detail Report will provide the End-user with the following information:


NOTE:If this is the first export to Excel you have performed, refer to the section on exporting data to Excel.
Project Manager - Customizing Data Presentation
Personalize Your Access to Oracle Applications: You can use several features of Oracle Applications to enhance your proficiency in the system. Use a Navigator top ten list to put your commonly used forms on your main menu or Navigator. Additionally, you can create a folder definition which you can specify query criteria and rearrange the layout of the form.
Creating a Navigation Top Ten List
The Navigator Window: If there are forms that you use frequently, you can add them to a navigation Top Ten List located on the right side of the Navigator window. The Top Ten List displays your forms numerically so you can choose them instantly without having to search in the navigation list. You can add a maximum of ten forms to the list and you can create a different top ten list for each responsibility for which you have access. A top ten list is unique for the responsibility and user sign-on combination that you use. 
NOTE:Sometimes the form that you add changes names when it appears in the top ten listing.
Folders:
A folder is a special block in which the field and record layout can be customized. You can identify a folder from a regular block by noting that an Open Folder button appears in the upper-left corner of a folder block, or that an enabled Folder Tools button appears on the toolbar when your cursor is in a folder block.
Creating Folder Definitions: You can create and save new folder definitions or open and delete existing folder definitions. When you open a new folder definition, the layout for the new folder definition replaces the layout for the current folder definition.


Using Folder Tools: When you navigate to a folder block, the Folder Tools button becomes enabled on the Toolbar. Click this button to display the folder tools on your screen. 
You can customize the presentation of data in a folder using the Folder Tools menu.
| Menu Item | Description |
| New | Creates a new folder definition. |
| Open | Opens a saved folder definition. |
| Save | Saves changes to the current folder definition. |
| Save As | Saves the current folder definition to a new name. |
| Delete | Deletes an existing folder definition. |
| Hide Field | Hides the current field. |
| Show Field | Displays a field that is currently hidden. |
| Move Left | Moves the current field to the left. |
| Move Right | Moves the current field to the right. |
| Move Down | Moves the current field down (not always available). |
| Move Up | Moves the current field up (not always available). |
| Shrink Field | Decreases the width of the current field. |
| Widen Field | Increases the width of the current field. |
| Change Prompt | Changes the prompt for the current field. |
| Autosize All | Adjusts all field widths proportionately to fill the window. (This cannot be undone without resizing each window.) |
| Show Order By | Toggles the display of the Order By Buttons so you can specify the sort order for the first three field columns. |
| View Query | Displays the query criteria for the current folder definition. |
| Reset Query | Erases the current query criteria. |
| Folder Tools | Displays the folder tool palette. |
Recovering the Original Default Folder Definition for a Folder: Once you create a custom folder definition and make it the default, you can recover the original default folder definition shipped with the product. Note that if you like the original default folder definition, give it a name and save it (without making any changes) before you create any new folder definitions. This way, you can open the original folder definition by choosing it from a list of all your predefined folder definitions.

Opening a Folder Definition:

Saving Changes to a Folder Definition:
NOTE:If you save a folder definition to Open as Default and then open another folder definition and save that second definition also as Open as Default, the second definition is reset as the new default.
If you modify a public folder definition in any way, saving it makes it a private folder definition.
Deleting a Folder Definition:

NOTE:Note that you can only delete folders you have created. If another user is referencing that folder definition as their Open as Default folder, that reference is deleted as well.
Show Order By: Resorting Data: If you wish to sort data in a different way on the form, select How Order By from the Folder menu. Sort buttons will appear beneath the first three columns. Use the folder tools to move the columns you wish to sort by to one of the first three positions. The sort will be done by the first column first, then by the second column, and then the third. For example, if you sort by date in the first column and by name in the second column, then the data will be arranged overall by date and then alphabetically by name within each date. 
You can choose to sort in ascending order, descending order, or no ordering for that column. Click OK to change the sorting criteria. 
Keep the Run Query check box checked to sort your current data.
Exporting Data to Excel: When you query a set of records in Oracle, you often have the option to export the information into Microsoft Excel. Once in Excel, you are able to manipulate the data using all of Excel's funcationality. In combination with the use of Folder Tools (see below), Oracle enables you to customize how information is displayed to meet your specific needs.


Project Manager - Financial Web Reports
The BUGL IFR Inquiry report will provide the end-user with Binghamton University’s General Ledger Income Fund Revenue account information. The report is searchable via individual IFR account numbers.



NOTE:The BUPA Invoice Inquiry report will provide the end-user with Binghamton University’s Project Accounting information regarding specific payment information. The report is searchable via individual Project numbers.
Highlights of BUPA Invoice Inquiry include:


Review your invoice/payment information. (If you have questions/concerns regarding your account information, contact the Business Office at x72188.)
BUGL Account Summary Inquiry
The BUGL Account Summary Inquiry report will provide the end-user with General Ledger account summary information. The data is cumulative, year-to-date, so you will want to use a period name, i.e.: Jan-02, to limit your results.

BUGL State Inquiry Report
The BUGL State Inquiry report will provide the end-user with Binghamton University’s General Ledger state account information. The report is searchable via state account numbers.




NOTE:If you have questions/concerns regarding your account information, contact the Business Office at x72188.
Travel - Overview and Contacts
Binghamton University uses Oracle applications to enter all travel vouchers for University employees traveling on state funds. Information about the current New York State per diem rates, business rules, and travel policies are provided in this document to assist you with preparing an expense report.
NOTE:This process only covers submitting travel vouchers for Binghamton University employees.
Contacts:
Travel - Creating a New Expense Report

Travel - Entering Receipts
Note the following guidelines below when entering receipts:
Entering Receipt Information


Travel - Saving Expense Reports
Save your expense report by clicking on the Save button. Only click the Save button from the Cash and Other Expenses screen. (Do not Save on the browser or from the Details screen or you will get an error message.)
NOTE:If you want to finish the voucher at a later time, after you save as outlined above, you may return to the main menu and exit by choosing Return(at the bottom of the screen). When you want to return to the voucher, go to the main menu and click the Expense Home hyperlink in the Expense Reports Responsibility. Your report will show under Update Expense Reports. Then click the travel number of your report under the Report Number column to bring up your expense report. The Update Expense Report: General Information screen will come up. Click Next to continue.
Travel - Entering, Reviewing and Submitting Travel Expenses

Travel - Reprinting Travel Expense Forms












Creating Oracle Requisitions
Requisitions - Setting Preferences
There are two entries that can be entered from the preferences menu, Main and Project Information. Enter information you want to default on all new requisition lines you create. You can change these defaults on individual requisition lines if needed. You can fill in one or as many fields as you want.
Setting Main preferences:


Project Information
Project (or POET) information can be set to default for each line in the requisition as well. POET stands for Project Organization Expenditure Task.
NOTE:The Source of Funds code (S in POETS) cannot be set as a default. The Source of Funds needs to be identified and entered separately for each line in the requisition.

NOTE:Caution: If you are entering multiple requisitions, make sure to change information in your preferences that are not applicable before starting your new requisition.
NOTE:Remember, there is no field available to set a preference for the Source of Funds. You will still have to enter this by clicking on the Distributions button and then the Project tab as you enter each line of the requisition. If you are entering a requisition with multiple lines, you must go to the Distributions window and enter the Source of Funds before attempting to save or to proceed with the entry of additional lines.
Requisitions - Creating Headers and Lines
Requisition Header 