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.
Before you can run the FACTS I Trial Balance report, you must:
Define treasury account codes and optionally define FACTS I rollup values.
Define treasury symbols and associate fund values to them.
Run the US SGL accounts table setup procedure to populate the Define US SGL Accounts window.
If necessary, review and edit US SGL accounts, and account numbers and attributes.
Run the FACTS attributes table setup procedure to populate the Define FACTS Attributes window.
You should run the FACTS I Interface immediately prior to the FACTS I Trial Balance for the same period to ensure the FACTS I Trial Balance reports the proper balances.
Select the ledger for the report.
Enter the fund value range for the report.
Enter the currency code to use for the report.
Enter the reporting period.
Enter the attribute set to use for the report.
Enter the output format to use for the report.
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. |
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