Purpose
The following guide is intended for all stakeholders of the sponsored awards process including URA Administrators, Department Research Administrators, Faculty, Principal Investigators (PI), and research leadership.
Keep in Mind
- Go to Oracle’s Reporting Hub menu option to access the Orbit Reporting Hub
- The data available in Orbit will be updated nightly by the source system (i.e. Oracle, Workday, or AURA)
- Many of the reports within this dashboard have hyperlinked information. When a hyperlink is available, you can select the hyperlink to see additional information including payment details and original invoice.
- To filter details within a Dashboard Table, select the filter icon and input the filter requirements needed for your search.
- To export a Dashboard Table to Excel, select the menu (hamburger) icon, then select Underlying Data. A popup will appear, you can select the export icon on the top of the popup screen.
Accessing the Sponsored Programs PI Dashboards
To see the information in this report, you must have the following system access:
- Named Project Personnel on a Project in Oracle
- Will see project information and the award of the project in which the project is associated
- Named Award Personnel on an Award in Oracle
- Will see the award information and the projects tied to the award
- Business Unit/Organization Access
- Will see project and award data associated to the business unit/organization associated with the user's access
A user can have a combination of each of these security access requirements. If you are missing information, work with project administration or your Role Assignment Owner to get access.
Sponsored Programs PI Dashboard Reports
Select the report name to learn more about the data available in this report:
Terminology
- Actual Cost: Actual costs are the costs that are incurred within a project. These costs can originate from Account Payable Invoices, Receipts related to a Purchase Order, manual costs created for a project, and costs interfaced from third-party systems.
- Award: An award is an umbrella record that contains comprehensive financial and demographic information for a grant.
- Encumbrance: Encumbrances are pre-expenditures that can be recorded with the General Ledger. The primary purpose of tracking encumbrances is to avoid overspending a budget. Encumbrances can also be used to predict cash outflow and as a general planning tool.
Commitment entries generated by requisitions and obligation entries generated by purchase orders are included in encumbrances.
- Expense: once an obligation or encumbrance is paid, this becomes an expense.
- POETAF: an acronym that represents the most granular level of detail of a project. It is a combination of project segments that describe an expenditure item, including Project, Expenditure Organization, Expenditure Type, Task, Award, and Funding Source.
- Project: A primary unit of work that can be broken down into one or more tasks containing demographic and financial information at a more detailed level than an award. Multiple projects may exist to differentiate among funding years, departments, PIs, physical locations, F&A rates, or purposes such as capitalizable & non-capitalizable.
- Purchase Order: A purchase order is a legally binding agreement between a buyer and a supplier that commits the buyer to purchase goods or services. It specifies the tentative delivery schedules, charge account, quantities, and estimated cost of the goods or services that the buyer intends to purchase. Purchase orders can be created for subawards, payment requests, residential properties, goods, and services.
- Requisition: A purchase requisition is an internal document that contains the description and quantity of goods or services to be purchased, along with a required delivery date, account number, and the amount of money that the purchasing department is authorized to spend on the goods or services.
Accessing the Sponsored Programs PI Dashboard
- Log-in to Oracle

- Select the Reporting Hub menu option
- Select Orbit Reporting Hub

- Select the 'R' and select Reporting

- Select Shared with Me
- Select Sponsored Programs PI Dashboard

Once you access the Sponsored Program PI Dashboards you can open the available reports in the folder.
This feature provides a comprehensive overview of all encumbrances for an individual Principal Investigator (PI). It also allows you to analyze encumbrances by supplier and project.
- Select the PI-Encumbrance Detail report.
- Users can select among the following parameters: PI (Principal Investigator), Award Number, Award Name, Funding Source Name, Project Name, Project Organization, Project Start Date, Project Finish Date, Award Type, and/or Expenditure Type parameters for their search criteria.
- Select Run to view the report based on the given parameters.
You have now completed the process of reviewing PI Encumbrance Details
Provides expenditure details on the entire sponsored portfolio of an individual Principal Investigator (PI). This report helps users understand the direct and indirect budget, the authorized budget, total expenses, direct cost balance, and total balance.
- Select the Expenditure Details dashboard.
- Users can select among the following parameters: PI (Principal Investigator), Award Name, Funding Source Name, Project Name, Organization Name, Project Number, Project Start Date, Project Finish Date, Award Type, Project Task, Expenditure Type, and/or Expenditure Category parameters for their search criteria.
- Select Run to view the report based on the given parameters.

You have now completed the process of reviewing Expenditure Details
Provides a comprehensive overview of all the details necessary to manage an individual project. It also provides visibility into expense details versus project budgets.
- Select the Project Details dashboard.
- Select among the following parameters: PI (Principal Investigator), Project Name, Project Number, Award Number, Award Name, Project Start Date, Project End Date, Organization Name, Expenditure Type, and/or Award Type parameters for their search criteria.
- Select Run to view the report based on the given parameters.

You have now completed the process of reviewing Project Details
Provides a comprehensive overview of all proposals for an individual Principal Investigator (PI). It also allows you to analyze the breakdown of proposed amount by Direct, F&A, and Proposed Amount costs.
- Select the Proposal Detail dashboard.
- Select among the following parameters: PI (Principal Investigator), Proposal Name, Sponsor, Proposal Start Date, Proposal End Date, Proposal Status, and/or Proposal ID parameters for their search criteria.
- Select Run to view the report based on the given parameters.

You have now completed the process of reviewing the Proposal Detail Dashboard.
Multi-Project Award Report
Comprehensive details necessary to manage an individual award or project. Includes budget to actual as well as various KPIs that allow the ability to easily track award and expense activity.
- Select the Multi-Project Award Report dashboard.
- Select among the following parameters: PI (Principal Investigator), Award Name, Award Number, Award Type, Award Start Date, Award End Date, Funding Source, and/or Sponsor parameters for their search criteria.
- Select Run to view the report based on the given parameters.

You have now completed the process of reviewing the Multi-Project Award Report