Rutgers logo
University Finance and Administration
  • Home
  • Resource Library

Oracle Reporting Logo

Oracle Reporting

Rutgers offers several Financial Management (Oracle Cloud) reporting technologies available to users for their reporting needs.  The Financial Management system includes these tools for running reports: Financial Reporting Center, Excel Plugin, Reports and Analytics Catalog and Scheduled Processes.

Financial Reporting Center:

  • Financial Report Studio Reports: These reports are built in the Financial Reporting Web Studio using Budget and Actual data in the General Ledger balances cube. For example, Profit/Loss Statements, Trial Balance and Balance Sheet reports. These reports are mainly run by users with General Ledger access.

Excel Plugin:

  • Smart View Reports: Smart View is a multidimensional pivot analysis tool combined with full Excel functionality. Smart View enables you to interactively analyze your balances and define reports using a familiar spreadsheet environment which accesses Budget and Actual data in the General Ledger balances cube. To share Smart View queries, users can email them to other users. These reports are mainly run by users with General Ledger access.

Reports and Analytics Catalog:

  • Oracle Transactional Business Intelligence (OTBI): These analyses and reports are built off transactional tables using subject areas. This tool also presents a self-service option for users using various General and Sub-ledger subject areas.
  • Business Intelligence Publisher (BI Publisher): This requires a BI Developer using SQL to create and modify the reports. These reports are designed for high volume, pixel-perfect reporting and can also be scheduled.
  • Dashboards: Dashboards put all the information, functions, and actions that a business user must have to do their job in one place. Dashboards may contain OTBI and BI Publisher reports along with prompts for parameter entry.

Scheduled Processes:

  • Pre-defined Report: Most of these reports are predefined by Oracle and must first be submitted and resubmitted to see the latest data by the Oracle Enterprise Scheduler through the Scheduled Processes navigation.

Training and Job Aids

Job aids and training are available for running Oracle Reports, SmartView, BI Publisher, Oracle Fusion Transaction Business Intelligence (OTBI), and other Oracle System Information. 

FAQs & Contact

The Finance, Data, Analytics, and Reporting team has created numerous reports and they are available in the Report Catalog.   If you have a need for a report or any questions, please reach out to the Finance, Data, Analytics, and Reporting at reporting@finance.rutgers.edu.