Reports

Aggie Enterprise data will be available through a variety of reporting tools.

Meeting our Reporting Needs

Aggie Enterprise is supported by Oracle Cloud Financials, which includes a robust catalog of built in and configurable reports. While Oracle functionality will meet many of our reporting needs, extensive analysis has been completed to identify gaps.

For reporting needs that cannot be addressed by Oracle, UC Davis will leverage Cognos reports, including a custom General Ledger Interface Detail Entries (GLIDE) reporting tool.

Reports have been prioritized into "Day 1" reports - those that we need available immediately - and reports that will be finalized after go-live to enhance our reporting capabilities. Additional information will be added to this page as Aggie Enterprise reports are built, tested and put into production.

Related Resources

  • Introduction to Data and Reporting Tools
    An introduction to some of the data and reporting tools available to support users. Materials include the demo recording, slide deck, and a question and answer document.
     

Jump to:

Cognos Reports list


Oracle Reports - Campus Facing


Finance

Report Name

Description

Audience

Frequency

Navigation

Link to KB

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. Campus Facing Scheduled N/A https://kb.ucdavis.edu/?id=9651
Account Monitor/Account Inquiry Tool View General Ledger balances and drill through to journal entry and sub-ledger details. Create and save customizing searches Campus Facing On Demand General Accounting>GA Dashboard https://kb.ucdavis.edu/?id=9756

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

Campus Facing

On Demand

Tools>Reports and Analytics>

https://kb.ucdavis.edu/?id=9611

Receivables Departmental Billing Adjustment Approval Report The 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. Campus Facing On Demand Tools>Reports and Analytics> https://kb.ucdavis.edu/?id=9635

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.

Campus Facing

On Demand

Tools>Reports and Analytics>

https://kb.ucdavis.edu/?id=9636

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 Campus Facing On Demand Financial Reporting Center https://kb.ucdavis.edu/?id=9758
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.

Campus Facing On Demand Financial Reporting Center https://kb.ucdavis.edu/?id=9653

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.

Campus Facing

On Demand

 

Financial Reporting Center

https://kb.ucdavis.edu/?id=9582

 

GL Summary

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 Campus Facing On Demand Financial Reporting Center https://kb.ucdavis.edu/?id=9759

 

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.  

Campus Facing

On Demand

Tools>Reports and Analytics>

https://kb.ucdavis.edu/?id=9579

Seeded Aging Multi-Fund Accounting Report – CGA and CAMPUS

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.

Campus Facing

On Demand

Tools> Scheduled Process>

https://kb.ucdavis.edu/?id=9637

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.

Campus Facing

On Demand

Financial Reporting Center

https://kb.ucdavis.edu/?id=9757

 


Project Portfolio Management

Report Name

Description

Audience

Frequency

Navigation

Link to KB

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.   

Campus Facing

On Demand

Aggie Enterprise> Tools>Reports and Analytics>

https://kb.ucdavis.edu/?id=9579

PGM Master Data Report

Report to review PPM award information to ensure all award data has been captured

Campus Facing

On Demand

Aggie Enterprise> Tools>Reports and Analytics

https://kb.ucdavis.edu/?id=9577

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). 

Campus Facing

On Demand and Scheduled

Aggie Enterprise> Tools>Reports and Analytics

https://kb.ucdavis.edu/?id=9574

PPM Project Cost Transaction Listing tool

Research detailed costs on PPM projects and tasks and export transaction listing to Excel

Campus Facing

 

On Demand

 

Aggie Enterprise> Projects>Project Financial Management

https://kb.ucdavis.edu/?id=9658

Scroll to section “View Detailed Costs for a PPM Project.”


Supply Chain

Report Name

Description

Audience

Frequency

Navigation

Link to KB

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.

Campus Facing

On Demand

Aggie Enterprise> Tools >Reports and Analytics

https://kb.ucdavis.edu/?id=9767

UCD PO Aging Report

The Purchase Order Aging Report is required to track the aging of Purchase Orders.

Campus Facing

On Demand

Aggie Enterprise> Tools >Reports and Analytics

https://kb.ucdavis.edu/?id=9767

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.

Campus Facing

On Demand

Aggie Enterprise> Tools >Reports and Analytics

https://kb.ucdavis.edu/?id=9767


Cognos Reports

All who currently have access to UCPath GL Cognos reports will automatically have access to new Cognos tools in October 2023, corresponding with the launch of the Aggie Enterprise hands-on environment. Those who do not have access to Cognos will need to request access by completing a Cognos access request form.

Report Title Details  Resources
Chart of Accounts Segment report Designed as a helper tool to support navigation of the new Chart of Accounts (CoA) structure. Introduction to Data and Reporting Tools
An overview of the CoA Segment report. (Beginning at 5:45 mark)
Request access to the Chart of Accounts report.
General Ledger Interface Detail Entries (GLIDE) reporting tool.

Designed to capture transactional details and store data to support reconciliation processes. GLIDE allows boundary applications to send over debits and credits, along with additional data fields.

GLIDE Reporting Demo
An overview of the General Ledger Interface Detail Entries (GLIDE) reporting tool. Materials include the demo recording, slide deck, and a question and answer document.
Request access to GLIDE.

Retiring FIS Decision Support (FIS-DS)

With the implementation of Aggie Enterprise, UC Davis will be retiring FIS Decision Support (FIS-DS).

Historical data will not go away; we have a plan to migrate the data from FISDS into a different platform, still to be determined, as part of our data archival strategy. Data retention will be aligned with the requirements outlined in the UCOP retention policy