|
|
| |
| This section of the website contains information about reports in the Integrated System. This is a good place to start for any questions about the ODS, Discoverer, or other reporting issues. |
|
|
|
| ANNOUNCEMENTS |
October 15 , 2009
Help File Updated
The ODS Help File has been updated. To download a current copy of the Windows version, please visit The Help File.
An updated HTML version of the Help File is available also. |
|
|
June 5, 2009
PO_Not Auto Final Closed: new report.
The purpose of this report is to list all non-cancelled POs in a "CLOSED" status that fail to meet the criteria for being finally closed by the Integrated System's automated final close process. It can be run by either Project Number, Award Number, Project Carrying Out Org, MBU or Dept. Note: departments should observe a number of guidelines before finally closing a PO. See Focus on Report session 26 for more details. |
|
|
June 3, 2009
LD_Labor Suspense Project Balances: new tab added.
This report now contains two tabs. The first tab, "LD Suspense Project Balance," is the report as it has existed, with no changes. It shows the current and project-to-date Labor Suspense Project balances.
The second tab, "LD Suspense Project Balance Detail," is new. It shows all transactions that do not net to zero for the same PTAEO, Employee, and Expenditure Item Date. Transactions include LD pay and adjustment transactions, associated fringe benefits, F&A (if applicable), and correcting GA cost transfers that may have been done by a central office. This report is helpful to see what transactions still need to be adjusted, as well as those adjusted by a central office with a cost transfer. ( See Focus on Report session 25 for more details and report samples.)
LD_Labor Suspense Project Detail: new parameter added.
A new optional "Project Number" parameter has been added to this report. Users may now choose to run the report by selecting either an "Employee Assignment Org" or a "Project number."
The LD_Suspense Detail Report lists all original payroll transactions along with any LD adjustments that were sent to suspense. This report is helpful for making LD corrections, as it shows all needed data to process an adjustment along with the reason it went to suspense. (See Focus on Report session 12 for more details and report samples.)
Note: This report does not show you any associated fringe benefits, F&A (if applicable), or any correcting GA cost transfers that contribute to the Labor Suspense project balance in Grants Accounting. To see all GA activity detail that contributes to the labor suspense project balance, see the detail tab of the LD_Labor Suspense Project Balance report. |
|
|
May 27, 2009
UVA - P Cards Distributions Report
The UVA – P Cards Distributions Report shows P-card charges during the window of opportunity that p-card holders and/or alternate approvers have to make PTAEO distribution changes via the Pcard distribution form. This report is not a Discoverer Report, but rather a standard report from the Integrated System real-time so that any changes made on the P-card distribution form can be immediately viewed on the report.
Run at the beginning of the P-Card distribution window, this report shows all purchases (for selected p-card holders/alternate approvers that were included during the current billing cycle so the necessary supporting documentation/log can be gathered prior to entering distribution changes.
Run after the distributions have been made, this report gives P-Card holders /alternate approvers an easy way to review all distribution changes for accuracy to eliminate unnecessary cost transfers after the transactions post.
See Focus on report Session 24 - UVA - P Card Distributions Report for more details. |
|
December 3, 2008
The FUSS and PI Usability groups are proud to announce two new FM reports.
IS.FM_Project Multi-Period and Year Expenditure Comparison Report
This report is an analytical report that allows you to make a side-by-side comparison of total expenditures for multiple periods. The report includes all award types (i.e., SG, LG, DR, ER, etc) including sponsored program (Gx) awards.
There are 3 tabs to the report. Each tab shows expenditure comparisons at different aggregation levels through the end of the periods selected.
- The first tab shows total monthly and YTD expenditures.
- The second tab shows just monthly expenses only.
- The third tab shows Budget, Expenditure and BBA totals as of the end of each UVA fiscal year selected.
See the Focus on Reports session entitled, “Session 22 - FM_Project Multi-Period and YTD Expenditure Comparison,” for more details.
IS.FM_PI Multi-Period Expenditure Comparison Report
This report contains the standard PI report header and is similar to the report above, except it only includes sponsored program (Gx) awards.
There are 2 tabs to the report. Each tab shows expenditure comparisons at different aggregation levels through the end of the periods selected.
- The first tab shows a summary of monthly expenditures at the sponsored budget category level for selected projects.
- The second tab shows a summary of monthly expenses at the project level for selected awards.
See the Focus on Reports session entitled, “Session 23 - FM_PI Multi-Period Expenditure Comparison,” for more details.
Hint: to see note pages associated with the slides with more explanatory comments, follow the instructions on the first page of the focus on report session. |
|
July 31 , 2008
Help File Updated
The ODS Help File has been updated. To download a current copy of the Windows version, please visit The Help File.
An updated HTML version of the Help File is available also. |
| |
New Discoverer Report: IS.PO_PO or Invoice Distribution Detail
This new report has three tabs that show PTAEO distribution amounts for: PO Invoices, Payment Vouchers, and approved Purchase Orders. In addition to showing the amounts distributed to various PTAEOs, each tab contains additional information to provide as broad a picture as possible of the transactions, such as: invoice paid status, posted status, and PO ship-to-location.
The report can be used as an aid in: viewing electronic invoice distributions, determining where to file invoice documentation for monthly reconciliation purposes, as well as other analysis of invoice/PO distribution details.
See the Focus on Reports session entitled, “PO or Invoice Distribution Detail”, for more details. |
| |
FM Report Standardized Parameters
Starting March 17, 2008, as part of a FUSS initiative, all FM reports will have their parameters expanded to provide additional options at run time.
The expanded selection options include the ability to choose a single project or award, or to select multiple organizations via an MBU or Dept option, as well as miscellaneous other parameters depending on the report. Also, a “Default to prior period” option was added to reports with a period parameter to allow you to schedule reports to run on a recurring cycle (i.e., at the beginning of the month) without having to change the period parameter.
Please note: if you are running a user modified version of the standard FM reports, you are not required to redo those changes. Your reports will continue to work with no changes required.
See the Focus on Reports session entitled, “FM Report Standardized Parameters,” for more details. |
|
GENERAL INFORMATION |
| Reports in the Integrated System may be obtained from one of two sources: |
- The Operation Data Store (ODS)
The ODS is a copy of the Oracle applications database that is created specifically for reporting. This copy is updated each night.
The primary tool for reporting from the ODS is Oracle Discoverer.
|
- Application Reports
These are reports which are run form within the Oracle Application. They are either standard reports that are provided with the application, or custom reports that were developed by the Integrated System Deployment & Support staff.
For information on application reports, please refer to the appropriate module. For information on scheduling Application Reports to run at a future time, please see Scheduling Oracle Standard Reports.
|
|
|
|
| THE OPERATIONAL DATA STORE |
The Operational Data Store (ODS) is a separate database, on a separate machine from the primary Integrated System application database. Each night at 5:30, a backup of the application database begins. Later in the night, this backup is copied to the ODS. Therefore, the data in the ODS is an exact copy of what was in the application database the previous evening. However, because nightly batch processing has not yet taken place at the time the backup is created, some data in the ODS may appear to be older. For example, transactions entered into the application yesterday may not have been posted to the General Ledger at the time the backup is created. This is illustrated in the Refresh graphic. Please note that this represents what will happen on a typical day. At month-end, the ODS will not be refreshed until month-end processing is complete, so all relevant data should be present in the ODS the following day.
The ODS is located behind the U.Va. firewall. Therefore you must be logged into VPN in order to be able to access the ODS.
The primary tool being provided for use with the ODS is Oracle Discoverer. Through Discoverer, users have access to a number of easy-to-use predefined reports. Those who need to create their own reports can do that by adapting the predefined reports to their own needs, or by creating new reports.
While Discoverer is the primary tool provided and supported by ISDS, other tools may be used. Regardless of the tool you intend to use with the ODS, you should install Discoverer, because the installation includes other software that is needed to connect to the Oracle database from any tool.
In order to use Discoverer or other tools with the ODS, you need to have an active Integrated System account, including one or more of the following responsibilities:
- UVA ODS Specialist
- UVA ODS Specialist-Limited
- UVA ODS Specialist-Restricted
- UVA ODS Specialist-Deducts
- UVA ASC ODS Viewer
When you use the ODS, you will be using a number of database views which combine data from many sources in order to make them easier for you to use. Most of these views are part of a purchased product called Noetix Views. Others were developed by ISDS to meet U.Va.'s particular needs. If you use Discoverer, the views will be divided into broad Business Areas that indicate their general purpose. Through other tools, you will see the views in a single alphabetized list. It is extremely important to choose the correct view or views for the information you need. For more information on the ODS views and the data they contain, see the ODS Help file.
The ODS is not to be confused with the U.Va. Information Warehouse. The ODS only contains information from the Integrated System Oracle Financials application. This data begins with fiscal year 2002 (i.e., the July 2001 accounting period). Data for prior years should continue to be obtained from the Information Warehouse. |
|
|
| FOCUS ON REPORTS PRESENTATIONS |
The Finance Usability and System Solutions (FUSS) Task Force prepares a series of presentations that focus on reports. Each session focuses on several reports and explains how to read them and when to use them, and any related features available. The slides from each presentation are posted here for future reference.
To view or print a copy of one of these presentations, complete with text of the presentation:
- Click on the appropriate Focus on Reports document, and open it.
- From the Menu bar, select: Edit, Edit Slides.
- From the Menu bar, select: Print.
- Select Note Pages from the Print what: drop down box.
- Click Preview to view on line, or OK to print.
|
|
