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
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.
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:
Navigate to the Submit Request window.
In the Request Name field, select SF133 Table Set-up Procedure.
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.
Perform the SF 133 Report Definitions Setup procedure to verify the data and to make modifications if needed.
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:
Navigate to the Submit Request window.
In the Name field, select Funds Availability Table Setup.
Perform the Funds Availability Setup procedure to add the account assignments for each column.
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:
Navigate to the Submit Request window.
In the Name field, select US SGL Account Table Setup.
To populate the Define US SGL Accounts window with US SGL account information, click Submit.
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.
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:
Navigate to the Submit Request window.
In the Request Name field, select FACTS Attributes Table Setup.
In the US SGL Accounts Used field select Yes or No.
To populate the FACTS Attributes window with FACTS attributes information, click Submit.
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.
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:
Navigate to the Submit Request window.
In the Name field, select Financial Statements Table Setup.
To send the request to the concurrent manager, click Submit.
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.
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:
Navigate to the Submit Request window.
In the Request Name field, select Statement of Budgetary Resources Table Set-up Procedure.
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.
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.
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:
Navigate to the Submit Request window
In the Name field, select Populate Reimbursable Activity Report Definitions.
To send the request to the concurrent manager, click Submit.
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.