Skip to main content

About Financial Data

You Are Viewing Archived Content

The Financial Activity Hub (FinAH) system went live on August 15, 2020. Visit the FinAH page in Blink for current information and support.

Financial data is available from three locations:

IFIS (Integrated Financial Information System)

  • Multiple-source, historical data through FY 2019-2020
  • Data is available through Financial Link or Cognos

Oracle Financials Cloud (OFC)

  • Single-source financial data starting FY 2019-2020
  • Available as of July 1, 2020
  • No historical data - see IFIS
  • Custom and out-of-the-box reports
  • Find OFC reports information

Financial Activity Hub (FinAH)

  • Financial data repository containing Oracle data
  • Available as of August 15, 2020
  • No historical data - see IFIS
  • Custom reports, can blend data from multiple Activity Hub repositories
  • Data available through Cognos or Tableau
  • Find FinAH-based reports at reports.ucsd.edu

Financial Data

Reporting and analysis of financial data are possible directly within Oracle Financial Cloud's out-of-the-box and custom reports. Financial data is also availble for reporting in a central repository called the Financial Activity Hub. Activity Hubs contain financial, employee, student and research system data, with additional data types to come.

Activity Hubs allow financial data to be used for "blended" reports, which combine data from the multiple Activity Hub repositories.

financial-data-flow-reporting.png

Types of Reports

Report location and the tool used to create reports on financial data depends on several factors, including what the user is trying to accomplish, their access to data and skill level.

 

 

 

 FinLink,
QueryLink,

 OFC

reports.ucsd.edu

Reporting
Activity

(What I need to do)

 

Examples
(I'm looking for...)

Legacy
IFIS
(via data warehouse)

Oracle
Financial
Reports

Activity Hub: Cognos

Activity Hub:

Tableau

Look at historical data

Data Prior to 2020

turquois-check-mark.png turquois-check-mark.png

Historical Project Data

turquois-check-mark.png turquois-check-mark.png

5-Year Financial Trends

turquois-check-mark.png turquois-check-mark.png

Look at current financial data

Recreate a FinLink Report

turquois-check-mark.png

new data only

turquois-check-mark.png

old & new data

turquois-check-mark.pngold & new
data

Current Budget

turquois-check-mark.png turquois-check-mark.png turquois-check-mark.png

Charting –

Visualizations such as line, bar or column charts,
heat maps, etc.

turquois-check-mark.png turquois-check-mark.png turquois-check-mark.png

Projections

turquois-check-mark.png turquois-check-mark.png turquois-check-mark.png

Live Financial Data 

turquois-check-mark.png

Manage financial transactions

 

 

Email Notification –

Scheduled Oracle events

turquois-check-mark.png

Email Notification –

Scheduled or immediate Oracle events

turquois-check-mark.png

Invoice Template

turquois-check-mark.png

PO Template

turquois-check-mark.png

Use more than one kind of data

 

 

 

 

 

 

Budget +

Headcount

turquois-check-mark.png turquois-check-mark.png

Budget +

New Hires

turquois-check-mark.png turquois-check-mark.png

Financial Data +

Research Data

turquois-check-mark.png turquois-check-mark.png

Department Financial +

Student Enrollment

turquois-check-mark.png turquois-check-mark.png

Historical Finance +
Oracle Finance

turquois-check-mark.png

Financials +

Your Spreadsheet

turquois-check-mark.png turquois-check-mark.png

PI Funds +

Gift Funds +

Foundation
Endowments

turquois-check-mark.png turquois-check-mark.png

Financials per Building/Lab

turquois-check-mark.png turquois-check-mark.png

Access to Financial Data and Reports

Before you can view, analyze or report on financial or other data, you must request access to the data by contacting the owner, or steward. Each data steward has a unique set of requirements for viewing their data, which can include training, job needs and more.

Access must be requested directly from each data steward. See a list of data sources and contacts.