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 I Trial Balance Report

FACTS I Trial Balance Report

Use the FACTS I Trial Balance Report to review Standard General Ledger (SGL) account balances at the attribute level. The report only captures attributes for accounts reported on FACTS I.

The FACTS I reports provide information on SGL account balances and associated attributes affected by FACTS I requirements. The FACTS I attributes have been effective for agency financial statements since the release of the Office of Management and Budget (OMB) Bulletin 97-01, Form and Content of Agency Financial Statements, dated October 16, 1996. However, attributes collected in FACTS I are used in preparation of the Financial Report of the United States Government and do not include all of the attributes used to prepare agency financial statements required by OMB Bulletin 97-01.

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

www.fms.treas.gov/cfs/dev/index.html

The FACTS I Trial Balance report 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.

Use the Standard Request Submission windows to submit the FACTS I Trial Balance report.

Prerequisites

Before you can run the FACTS I Trial Balance report, you must:

Report Parameters

Ledger

Select the ledger for the report.

Fund Low/High

Enter the fund value range for the report.

Currency Code

Enter the currency code to use for the report.

Period

Enter the reporting period.

Attribute Set

Enter the attribute set to use for the report.

Output Format

Enter the output format to use for the report.

Report Headings for the Default Attribute Set

The following table describes the heading section of the FACTS I Trial Balance report.

Heading Description
Ledger Name The ledger name
Date and Time The date and time of the report
Currency The report currency
Accounting Period The report accounting period
Fund Range The report fund range
Treasury Symbol The report treasury symbol
Fund The report fund
Fiscal Year Values in segment assigned by the default attribute set.

Note: If the segment assigned in the default attribute set does not reflect fiscal year, the default attribute set would need to be copied and modified to assign the appropriate segment for fiscal year.

Organization Values in segment assigned by the default attribute set.

Note: If the segment assigned in the default attribute set does not reflect organization, the default attribute set would need to be copied and modified to assign the appropriate segment for organization.

Program Values in segment assigned by the default attribute set.

Note: If the segment assigned in the default attribute set does not reflect program, the default attribute set would need to be copied and modified to assign the appropriate segment for program.

Project Values in segment assigned by the default attribute set.

Note: If the segment assigned in the default attribute set does not reflect project, the default attribute set would need to be copied and modified to assign the appropriate segment for project.

Column Headings for the Default Attribute Set

The following table describes the FACTS I Trial Balance report.

Heading Description
Acct No The natural account segment
FNF The attribute values for federal (F) and non-federal (N) if FNF attribute is Federal (F).
TPC The descriptive flexfield value for trading partner
ENE The attribute values for exchange (X) or non-exchange (T)
BSF The budget subfunction lookup code defined in the Appropriation Parameters window associated to the fund
CNC The quickcode values for custodial (S) or non-custodial (A)

Related Topics

Using Standard Request Submission, Oracle Applications User Guide

Oracle Financials RXi Reports Administration Tool, Oracle Financials RXi Reports Administration Tool User Guide