Browse Available Reports
Search and Filters
Search and Filter Field Definitions
Filter by Report Type
- Show only reports of a particular type: Finance, PPM, Supply Chain, and/or Cognos. You can filter by multiple types simultaneously.
Search by Report Title
- Search by the title of the report. Search accepts partial entries.
Search Report Descriptions
- Search the report description field for matching terms. This is particularly useful if you're looking for a report, but are not sure which one will best meet your needs. Search accepts partial entries.
Search by Release Date
- Filter reports by the date they were first released. Find all issues that were released within a timeframe by entering a date for both the Min and Max fields.
Report Title Sort descending | Report Description / Use Case | Report Type | Release Date / Last Updated |
---|---|---|---|
Account Monitor/Account Inquiry Tool | View General Ledger balances and drill through to journal entry and sub-ledger details. Create and save customizing searches This is similar to some functions on the DS-1. You can find chart string balances for a given period. It is also similar to the DS-48; you can see balances by period for a specific natural account It is also similar to the DS256; you can see year-over-year comparisons. For more information, see KBA0009756. |
Finance | |
AE Chart of Accounts (CoA) Segment Report | This report displays the value set and hierarchy for the Chart of Accounts for easy viewing by the business user. This report displays the parent/child relationship between values in each CoA segment. Similar to the DS10, DS11, DS37 and DS50. More Information available in the Introduction to Data and Reporting Tools demo (beginning at 5:45 mark). |
Cognos | |
AE GLIDE Report | GLIDE stands for General Ledger Interface Detail Entries report. This report assists financial system users with GL reconciliation processes, the GL Journal service will be enhanced to capture boundary system journal details and store the data for use in a Cognos report. This report contains detailed records of the transactions that are being sent from boundary applications through the GLIDE framework to Oracle. Review the Understanding the GLIDE Report Knowledge Base Article. Similar to the DS2 and DS212. More information available in the GLIDE Reporting Demo. More information about Concur data missing from GLIDE can be found here: https://supplychain.ucdavis.edu/banking-card-program/glide-information. |
Cognos | |
AEE-318 AggieExpense Department Approvers Report | Allows you to view the current approver for a given department or employee. Use the report after making department approver changes to verify that the update is correct. For additional information, see KB0010799 AggieExpense: Viewing and Taking Approval Action on Requests and Reports. |
Cognos | |
AEE-416 AggieExpense Detail Report | Displays complete details of the expense report of interest. You can search for the report using the report key, located in the upper-left corner of the reporter page. For additional information, see KB0010827 AggieExpense: Creating an Expense Report. |
Cognos | |
AEE-417 AggieExpense Outstanding Cash Advances | Displays outstanding cash advances made in AggieExpense Request. Use the report to reconcile any outstanding cash advances after your trip concludes. For additional information, see KB0010785 AggieExpense: Creating a Request for Travel or Cash Advance and Reconciling Cash Advances. |
Cognos | |
AEE-418 AggieExpense Unreconciled Card Expenses Report | Displays outstanding Travel Card and Procurement Card transactions. Use the report to reconcile any outstanding Travel card transactions before or after your trip. For additional information, see KB0010840 AggieExpense: Creating a Procurement Card Reconciliation Report. |
Cognos | |
AEE-419 AggieExpense Report Lookup | Allows you to look up Travel and Entertainment reports by a variety of parameters, including Division, Department, Traveler Name, Report Name, or Report Type. For additional information, see KB0010827 AggieExpense: Creating an Expense Report. |
Cognos | |
AEE-421 AggieExpense Unreconciled Direct Billings Report | Displays outstanding Preferred Booking Program transactions. Use the report to reconcile any outstanding Preferred Booking Program transactions before or after your trip. For additional information, see KB0010840 AggieExpense: Creating a Procurement Card Reconciliation Report. |
Cognos | |
Asset Notification | Asset Representatives need to be notified of their moveable asset transactions including additions, adjustments, retirements, transfers, and any updates to the descriptive details, including descriptive flex fields. In Oracle FA an email notification will be sent at the end of each day to the Asset Representative of any transactions processed on their assets. This will enable the Asset Representative to review the asset transactions processed by the Central Equipment Management team. For more information, see KB0009651. |
Finance | |
Customer Billing History Report | This report is required to track all customer data billing history transactions for analysis purpose This report replaces today’s Decision Support report FIS408. For more information, see KB0009611. |
Finance | |
Department Billing Report | The report pulls in all unaccounted transactions in the Oracle Receivables Cloud system. This report is required to track the status of all incomplete invoices in order to clear out any transactions at month-end. |
Finance | |
Department P&L | Monitor department financial position and perform financial analysis. Summary of operations at a point in time with beginning balance, revenue, expenditures, and ending balance. Can be run for multiple parent or posting-level financial departments This is similar to some functions on the DS-1 and the DS-210. |
Finance | |
Equipment Activity Report | The Fixed Asset Equipment Activity report is to enable the UCD Central Accounting Office as well as campus department users to ensure that movable assets are properly recorded and transacted in Oracle Fixed Assets. The report is comprised of two tabs, both a summary and detailed report. The user can customize the report for their needs by selecting report parameters such as custodial code and fiscal period from and to. This report replaces today’s Decision Support reports 283, 370, and 371. |
Finance | |
Equipment Inventory Listing | The Equipment Inventory Listing is regularly utilized by both UC Davis Central Office and campus departments to monitor the accuracy and completeness of the university’s moveable equipment inventory and ensure the University meets physical inventory and sponsor requirements. This report replaces today’s Decision Support report 375 and 379. |
Finance | |
General Ledger Summary Report | Monitor department financial position and perform financial analysis. Summary of operations at a point in time by fund source with beginning balance, revenue, expenditures, and ending balance. Can only be run for a single parent or posting-level financial department This is similar to some functions on the DS-1 and DS-55, as well as the Aggie Budget Sources & Uses report. |
Finance | |
NIFA Reporting - PPM | The NIFA report is for use by the College of Agriculture and Environmental Sciences applications to generate a mandatory Sponsor Annual Report. |
Project Portfolio Management | |
NIFA Reporting – GL | This report is necessary to create a location where Projects and Grants users can easily review necessary project and award information and ensure that award creation meets standards. This will help central users look for inconsistency in the award data – to confirm quality of creation / maintenance of awards applications to generate a mandatory Sponsor Annual Report. |
Finance | |
PGM Master Data Report | Report to review PPM award information to ensure all award data has been captured. |
Project Portfolio Management | |
Receivables Aging Report | Receivables Aging Report is an on-demand report. The report pulls in all open (current and overdue) transactions system. This report is required for to track aging of transactions for analysis purpose. |
Finance | |
Receivables Departmental Billing Adjustment Approval Report | The Receivables Departmental Billing Adjustment Approval Report pulls in all billing transactions in the Oracle Receivables Cloud system that requires approval by the department. The requirements are needed for the various departments to have the ability to isolate their specific departmental adjustments for approval. |
Finance | |
UCD Comprehensive Spend Report | The Comprehensive Spend Report will provide the data required to analyze category spend, Small Business First and 5402 Reporting compliance and spend by time period. |
Supply Chain | |
UCD Faculty and Department Portfolio Report | Report showing all PPM activity for an individual Faculty (PI), and individual Project Manager or a project-owning organization (Financial Department). Similar to the DS 325-PI Ledger Review. |
Project Portfolio Management | |
UCD FTCR Quarterly Report | This Federal Cash Transaction report will provide the necessary information for completing the Federal Quarterly Reports. Federal Report requires Quarterly activity in addition to Cumulative to Date detail. |
Project Portfolio Management | |
UCD GL Balance Summary Report | Similar to UCD GL and Sub-ledger Reconciliation Report moving accounts from default Parents in balancing with the General Ledger Summary Report (i.e. 775xxx from Revenue to Expense, etc...). Resembles the FISDS-1 report.
|
Finance | |
UCD PO Aging Report | The Purchase Order Aging Report is required to track the aging of Purchase Orders. |
Supply Chain | |
UCD PPM Cost Transfer Report | Research detailed costs on PPM projects and tasks and export transaction listing to Excel This tool is similar to the DS-2 Transaction listing report, but will only return results for costs on PPM Projects. See related KBA for more information. (Scroll to section “View Detailed Costs for a PPM Project.”) |
Project Portfolio Management | |
UCD PPM Department Kickout Project Balances | Departments must periodically review their Department Kickout (DKO) projects and transfer these costs. This report helps units identify their current DKO balances so they can take appropriate action. For additional information, see KBA0010958. |
Project Portfolio Management | |
UCD Requisition & PO Activity Report | The Requisition and PO Activity Report will allow UCD to perform analysis based on document milestones, and review status updates. |
Supply Chain | |
UCD Transaction Listing Report | Monitor the accuracy and completeness of GL postings, review financial transactions, and perform financial analysis. Provides details of journal entries by period, journal source, journal category and COA attributes; also provides commitments, obligations, and actual balances. This is similar to the DS-2, DS54, DS-17 Object Transaction Detail reports. Note that it contains summarized transactions from subledgers; you may need to go to the subledger directly to see individual transactions. |
Finance | |
UCD Transaction Listing Report - GL and Subledger Detail | The report will provide users with Summary Chart of Account balances and information for sub-ledger and General Ledger journal entries Detail. Works toward an FISDS-2 Replacement.
For more information, see KB0010829. |
Finance |