Federal Reports Table Setup

Federal Reports Table Setup Overview

This chapter describes how to set up federal reports tables in Oracle U.S. Federal Financials before generating the reports for the first time.

You must run the setup procedures described in this chapter must be run before generating these reports:

• SF 133 Report on Budget Execution

• Funds Available - Total Resources

• Funds Available - Funding Distributions

• Funds Available - Spending Activity

• Funds Available - Available Balances

• FACTS I

• FACTS II

• Balance Sheet

• Statement of Net Cost

• Statement of Changes in Net Position

• Statement of Budgetary Resources

• Statement of Financing

• Statement of Custodial Activity

• Reimbursable Activity Report

Prerequisites

Agencies must comply with the US SGL to take full advantage of FACTS I and FACTS II. Agencies that expand their numbering system to accommodate agency-specific requirements must designate a parent account that is a four-digit US SGL account.

Setting Up the SF 133 Tables

This procedure populates the SF 133 Report Definitions window with the SF 133 lines and the associated US SGL accounts, Balance Type and the various attributes for each detail line type.

To populate the SF 133 Report Definitions window:

1. Navigate to the Submit Request window.

2. In the Request Name field, select SF133 Table Set-up Procedure.

3. In the Delete existing SF133 Setup field select Y or N. If N is selected, only new lines and new accounts will be populated in the SF 133 Report Definitions window.

4. Perform the SF 133 Report Definitions Setup procedure to verify the data and to make modifications if needed.

Setting Up Funds Availability Tables

The Funds Availability Table Setup procedure populates these funds availability reports and the associated columns in the Funds Availability Report Definitions window:

• Funds Available - Total Resources report with these columns:

  • Authority Brought Forward

  • Appropriated

  • Contract Authority

  • Borrowing Authority

  • Offsetting Collections

• Funds Available - Funding Distributions report with these columns:

  • Total Not Yet Apportioned

  • Total Apportioned

  • Total Allotted

  • Total Allowances

  • Total Sub-Allowances

• Funds Available - Spending Activity report with these columns:

  • Budget Authority

  • Commitments

  • Obligations

  • Expenditures

• Funds Available - Available Balances report with these columns:

  • Apportionment Balance

  • Allotment Balance

  • Allowance Balance

  • Sub-Allowance Balance

Note: You can run the Funds Availability Table Setup procedure multiple times. Running the procedure does not overwrite any updates to the Account Assignments but does overwrite any Column Name updates.

To populate the Funds Availability Report Definitions window:

1. Navigate to the Submit Request window.

2. In the Name field, select Funds Availability Table Setup.

3. Perform the Funds Availability Setup procedure to add the account assignments for each column.

Setting Up US SGL Accounts Tables

Note: You can run the US SGL Accounts Table Setup procedure and the FACTS Attributes Table Setup procedure multiple times. Running these procedures could overwrite manual updates entered in these windows:

• Define US SGL Accounts window

• FACTS Attributes window

• Define Other Authorization Codes window

This procedure populates the Define US SGL Accounts window with this information:

• Valid US SGL accounts as defined by the Department of Treasury’s Financial Management Service (FMS).

• Normal balance values: debit, credit, or either.

• FACTS reporting status: FACTS I, FACTS II, or both.

• Edit check criteria for US SGL accounts that are required for FACTS II reporting.

Note: Because this setup procedure populates the data that identifies an account’s reporting type, such as FACTS I, FACTS II, or both, it is recommended that you run the US SGL Accounts Table Setup procedure before running the FACTS Attributes Table Setup procedure.

To populate the Define US SGL Accounts window:

1. Navigate to the Submit Request window.

2. In the Name field, select US SGL Account Table Setup.

3. To populate the Define US SGL Accounts window with US SGL account information, click Submit.

4. Perform the US SGL Accounts setup procedure to verify the populated data and to make modifications if required.

   Note: Since various reports are generated based on the data populated in the US SGL Accounts window, it is imperative that the data is correct. You must verify that the data was populated and make modifications if required.

Related Topics

To perform the US SGL Accounts setup procedure, see Federal Report Definitions Setup.

Setting Up FACTS Attributes Tables

This procedure populates the FACTS Attributes window with the required US SGL accounts, balance types, and attributes for FACTS reporting.

For information on the attributes required for FACTS I and FACTS II reporting published by the Department of Treasury, see the FMS website at the following URL:

www.fms.treas.gov/ussgl

This procedure also populates the Define Other Authorization Codes window with the following information:

• Known authorization codes

• US SGL accounts and attributes used to validate edit checks for Fund Balance with Treasury reconciliation

After this setup procedure is successfully completed, you must verify that appropriate attributes are associated with the US SGL account on the FACTS Attributes window and the Define Other Authorization Codes window.

To populate the FACTS Attributes window and Define Other Authorization Codes window:

1. Navigate to the Submit Request window.

2. In the Request Name field, select FACTS Attributes Table Setup.

3. In the US SGL Accounts Used field select Yes or No.

4. To populate the FACTS Attributes window with FACTS attributes information, click Submit.

5. Perform the FACTS Attributes setup procedure to verify the populated data and to make modifications if required.

   Note: Since various reports are generated based on the data populated in the FACTS Attributes window, it is imperative that the data is correct. You must verify that the data was populated and make modifications if required.

Related Topics

To perform the FACTS Attributes setup procedure, see Federal Report Definitions Setup.

Setting Up the Financial Statement Tables

This procedure populates the financial statement reports and the associated report line information for the following reports:

• Statement of Net Cost

• Statement of Changes in Net Position

• Statement of Financing

• Statement of Custodial Activity

The information populated for the detail line type includes the US SGL account, Balance Type, and the various attributes required for the associated report.

To run the Financial Statement Report Tables Setup Process:

1. Navigate to the Submit Request window.

2. In the Name field, select Financial Statements Table Setup.

3. To send the request to the concurrent manager, click Submit.

4. Perform the Financial Statement Report Definitions setup procedure to verify the populated data and to make modifications if required.

   Note: Since various reports are generated based on the data populated in the Financial Statement Report Definitions window, it is imperative that the data is correct. You should verify that the data was populated and make modifications, if required.

Related Topics

To perform the Financial Statement Report Definitions setup procedure, see Setting Up Financial Statement Report Definitions.

Setting Up the Statement of Budgetary Resources Tables

This procedure populates the Statement of Budgetary Resources window with the lines and the associated US SGL accounts, Balance Type and the various attributes for each detail line type.

To populate the Statement of Budgetary Resources window:

1. Navigate to the Submit Request window.

2. In the Request Name field, select Statement of Budgetary Resources Table Set-up Procedure.

3. In the Delete existing setup field select Y or N. If N is selected, only new lines and new accounts will be populated in the Statement of Budgetary Resources window.

4. Perform the Statement of Budgetary Resources Setup procedure to verify the data and to make modifications, if needed.

Related Topics

To perform the Budgetary Resources Report Definitions setup procedure, see Setting Up Financial Statement Report Definitions.

Setting Up the Reimbursable Activity Report Tables

The Populate Reimbursable Activity Report Definitions procedure populates the associated columns in the Reimbursable Activity Report Definitions window.

To run the Populate Reimbursable Activity Report Definitions Process:

1. Navigate to the Submit Request window

2. In the Name field, select Populate Reimbursable Activity Report Definitions.

3. To send the request to the concurrent manager, click Submit.

4. Perform the Reimbursable Activity Report Definitions setup procedure to verify the populated data and to make modifications if required.

Related Topics

To perform the Reimbursable Activity Report Definitions setup procedure, see Federal Report Definitions Setup.