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. See New Report Requests to check status of reports that are in development.

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 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.	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 This is similar to some functions on the DS-1 and the DS-210.	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
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.	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. 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.	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). Similar to the DS 325-PI Ledger Review.	Campus Facing	On Demand and Scheduled	Aggie Enterprise> Tools>Reports and Analytics	https://kb.ucdavis.edu/?id=9574
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.	Campus Facing	On Demand	Aggie Enterprise> Tools>Reports and Analytics	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
Cognos is a tool designed to help provide reports on various systems data. See below for more information Cognos reports and access.

Aggie Enterprise Cognos Reports

Two Cognos reports are available to support Aggie Enterprise reporting needs at go live.

Report

Details

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)

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.

Access is automatically provisioned to users that have at least one of the following roles in Aggie Enterprise:
- UCD Projects Cost Inquiry JR
- UCD General Ledger Inquiry JR

Timeline for access
- Users with the above roles have been provisioned at go live.
- Going forward, Aggie Enterprise Security Liaisons will be able to request these reports for users via the User Role Mapping process for Aggie Enterprise.
- Reports will be available in Cognos Production environment

For those not auto-provisioned
- Please reach out to your department's CAO or fiscal office to determine which reports you should be provisioned.
- Submit access request via email to your Security Liaison(s); cc your CAO or fiscal officer.
- Note that the Security Team will only process requests submitted by designated Security Liaisons.

AggieExpense (Concur) Reports
Cognos offers reports to view AggieExpense, Procurement and Travel Card transactions, as well as those made through the Preferred Booking Program (PBP). The following reports are available:
1. AEE-318 AggieExpense Department Approvers Report
2. AEE-416 AggieExpense Detail Report
3. AEE-417 AggieExpense Outstanding Cash Advances
4. AEE-418 AggieExpense Unreconciled Card Expenses Report
5. AEE-419 AggieExpense Report Lookup
6. AEE-421 AggieExpense Unreconciled Direct Billings Report
7. AEE-425 AggieExpense Spend Report

Access is automatically provisioned to users that have at least one of the following roles in Aggie Enterprise:
- UCD Projects Cost Inquiry JR
- UCD General Ledger Inquiry JR

Timeline for access
- Users with the above roles will be provisioned by the end of January 2024.
- Going forward, Aggie Enterprise Security Liaisons will be able to request these reports for users via the User Role Mapping process for Aggie Enterprise.
- Reports will be available in Cognos Production environment

For those not auto-provisioned
- Please reach out to your department's CAO or fiscal office to determine which reports you should be provisioned.
- Submit access request via email to your Security Liaison(s); cc your CAO or fiscal officer.
- Note that the Security Team will only process requests submitted by designated Security Liaisons.

See Supply Chain's Cognos Reports: Viewing AggieExpense, Card, Preferred Booking Program Expenses for more information.

Enter Cognos Production Environment

Questions about Aggie Enterprise Cognos Reports can be submitted to the Aggie Enterprise Help Desk.

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.