Skip Headers

Oracle U.S. Federal Financials User Guide
Release 12.1
Part Number E13551-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

FACTS II Report Procedures

Overview

The FACTS II reports provide information on Standard General Ledger (SGL) account balances and associated attributes affected by FACTS II requirements.

Features

The FACTS II Trial Balance Report is used by federal agencies to review SGL account balances at the attribute level. Only attributes for accounts reported on FACTS II are captured.

The FACTS II Trial Balance is an RXi report. The Default Attribute set groups the data by treasury symbol, fund, fiscal year, organization, program, and project. This attribute set can be copied in order to customize the layout to suit the reporting needs of the agency. In the Default Attribute set, the fiscal year, organization, program, and project segments were assigned default segment columns. To maintain this level of detail, the agency must create a customized attribute set to map the segment of the Accounting Flexfield to the appropriate column headings.

See: RXi attribute sets, see Oracle Financials RXi Reports Administration Tool, Oracle Financials RXi Reports Administration Tool User’s Guide.

Requirements

Agencies' financial systems are required to comply with the US SGL at the transaction level for FACTS II reporting in accordance with the Federal Financial Management Improvement Act and section 7(c) of the Office of Management Budget (OMB) Circular No. A-127.

For information on reporting requirements, see the Department of Treasury’s Financial Management Service (FMS) FACTS II information at the following website:

www.fms.treas.gov/ussgl/factsii

Prerequisites

The prerequisites for generating the FACTS II bulk file are also applicable to generating the FACTS II Report.

Generating the FACTS II Trial Balance Report Procedure

To run the FACTS II Trial Balance Report, do the following:

  1. Navigate to the Submit Request window.

  2. In the Name field, select FACTS II Trial Balance.

  3. In the Ledger field, select a ledger.

  4. In the Fund Low field, select a fund value designating where to start report generation. .

  5. In the Fund High field, select a fund value designating where to end report generation.

  6. In the Currency Code field, select a currency type.

  7. In the Period field, select a period.

  8. In the Attribute Set field, select the attribute set.

  9. In the Output Format field, select the output format for the report.

The following table describes the FACTS II Trial Balance Report Description for the Default Attribute Set.

FACTS II Trial Balance Report Description for the Default Attribute Set
Column Description
Header Section Ledger name, report date and time, currency, accounting period, fund range, treasury symbol, fund, fiscal year, organization, program, and project
Acct No Natural account segment
AUT Authority type
DEF Definite (D) or Indefinite (I) flag.
PL Public law code
CAT Apportionment category
PRC Program Reporting Category for Category A
CBS Apportionment Category B Code
RIF Reimbursable flag: Direct (D) or Reimbursable (R)
AVT Period of availability: Available in current period (A) or Available in a subsequent period (S)
TRP Transaction partner code: Federal (F), Non-federal (X), Non-federal exception (E)
BOR Borrowing Source
BEA Budget Enforcement Agency (BEA) category: Discretionary (D) or Mandatory (M)
YRB US SGL attribute that distinguishes between outlays from new budget authority versus outlays from balances carried forward from a prior year; used for noncredit financing No-year appropriations only; NEW or BAL
TAG Department identifier of the agency involved in the transfer
TAC Main account code of the agency involved in the transfer
ADF Indicates that a portion of the appropriation is advanced from a future year (F) or made available in a prior year (P)
FUN Classifies data according to major purpose served: Defense (DEF) or Non-Defense (NND)
CYR Cohort year; two-digit year
PYA Adjustments to prior year reporting
Beginning Balance Beginning balance of period
Current Period Debits Debits for the period
Current Period Credits Credits for the period
Ending Balance Ending balance of period