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 Transaction Register

FACTS Transaction Register

Use the FACTS Transaction Register to review and analyze SGL account balances and FACTS attribute information. The FACTS Transaction Register prints SGL account information by fund within a treasury symbol and associated attributes affected by FACTS I and FACTS II requirements.

The FACTS I Transaction Register is an RXi report. The Default Attribute set groups the data by treasury symbol, fund, organization, program, project, and budget object class. 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 organization, program, project, and budget class 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 Transaction Register.

Prerequisites

The prerequisites for generating the FACTS II bulk file and the FACTS I ATB are also applicable to generating the FACTS Transaction Register.

Note: To ensure that the FACTS I attributes are correct, the FACTS I ATB should be generated prior to submitting the FACTS Transaction Register for the period the FACTS Transaction Register End Period will be submitted.

Report Parameters

Ledger

Select the ledger to use for the report.

Currency

Enter the currency to use for the report.

Treasury Symbol Low/High

Enter the treasury symbol range for the report.

Start/End Period Name

Enter the General Ledger period range for the report.

Journal Source

Enter the General Ledger source to use for the report.

Journal Category

Enter the General Ledger category to use for the report.

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 Transaction Register report.

Heading Description
Ledger Name The ledger name
Report Date The report date
Currency The report currency
Treasury Symbol Range The report treasury symbol range
Accounting Period The report accounting period
Journal Source The report journal source
Journal Category The report journal category
Treasury Symbol The report treasury symbols
Fund The report fund
Organization Code Values in the segment assigned by the default attribute set.

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

Program Values in the 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 the 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.

BOC Values in the segment assigned by the default attribute set.

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

Column Headings for the Default Attribute Set

The following table describes the FACTS Transaction Register report.

Heading Description
Acct No Natural account segment.
Transaction Source Transaction journal source.
Transaction Number Transaction document number.
Transaction Date Transaction document date.
Creation Date/Time Date and time the transaction was created.
Entry User Name of the user who created the transaction.
FNF Federal (F) or Non-Federal (N).
TPC Descriptive flexfield value for Trading Partner if FNF attribute is Federal (F).
ENE Exchange (X) or Non-Exchange (T).
BSF Budget Subfunction lookup code associated to the fund, if required for this account.
CNC Custodial (S) or Non-Custodial (A).
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, in two-digit format.
PYA Adjustments to prior year reporting.
Debit Amount Transaction debit, if applicable.
Credit Amount Transaction credit, if applicable.