1. Using U.S. Federal Financials
  2. Federal Reports

Federal Reports

Reports provide access to business information in a structured format to support business operations, analysis, monitoring, decision-making, and compliance requirements. Sometimes these tools can also be used to generate outputs that need to be submitted to the Department of Treasury, the Office of Management and Budget (OMB), or some other government agency.

Oracle Fusion Applications provides multiple reporting and analytics tools that enable users to access, analyze, and distribute business information as described in the following table:

Reporting Tools

Reporting Tool Related Information
Financial Reporting Center Overview of Financial Reporting Center
Standard reports See the prebuilt reports table in this topic.
Oracle Analytics Publisher Overview of Analytics Publisher
Oracle Transactional Business Intelligence (OTBI) Overview of Transactional Business Intelligence
AI agents Overview of AI Agent Studio
Data Extraction Overview of the Data Extraction Tool

In addition, U.S. Federal Financials provides prebuilt reports for commonly required business information across functional areas. They're available as ready-to use reports and include predefined data fields, layouts, and filters. For more information, see the applicable chapters in this guide.

The Financial Management Quality Service Management Office (FM QSMO) maintains a list of prebuilt business reports required for core federal financial systems.

The following table lists the prebuilt reports identified in the FMCF and the Oracle Fusion Applications reporting tools that can be used to support each reporting requirement:

Prebuilt Reports

Report Source Area Tool
Status of Funding Budget Formulation to Execution Oracle Analytics Publisher
Combined Schedule X (Schedule P data) Budget Formulation to Execution Oracle Analytics Publisher
Obligation Status Budget Formulation to Execution Oracle Analytics Publisher
AP Invoice Status Payables Management Oracle Analytics Publisher
AP Prompt Pay Payables Management Oracle Analytics Publisher
1099-INT Interest Income Payables Management Oracle Analytics Publisher
1099-MISC Miscellaneous Information Payables Management

Standard report:

US 1099 Report
Reimbursable Agreement Status Intragovernmental Transactions Oracle Analytics Publisher
Reimbursable Agreement Analysis Intragovernmental Transactions Oracle Analytics Publisher
Dunning Notice Receivables and Collection Management Oracle Analytics Publisher
Receivable Status Receivables and Collection Management Oracle Analytics Publisher
Aged Receivables Receivables and Collection Management
Transaction Detail
  • Payables Management
  • Receivables and Collection Management
  • General Ledger Management

Oracle Analytics Publisher
Trial Balance General Ledger Management
GL Account Abnormal Balance Analysis General Ledger Management Oracle Analytics Publisher
GL Account Relationship Analysis General Ledger Management Oracle Analytics Publisher
Reconciliation of Net Operating Cost and Net Budgetary Outlays General Ledger Management Oracle Analytics Publisher
Balance Sheet General Ledger Management Oracle Analytics Publisher
Statement of Net Cost General Ledger Management Oracle Analytics Publisher
Statement of Changes in Net Position General Ledger Management Oracle Analytics Publisher
Statement of Budgetary Resources General Ledger Management Oracle Analytics Publisher
Statement of Custodial Activity General Ledger Management Oracle Analytics Publisher