Search Results fv_facts_attributes_pk




Overview
Explore in AI Chat

Overview

FV_FACTS_ATTRIBUTES is a Federal Financials (FV) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 data model. It stores the USSGL (United States Standard General Ledger) accounts required for FACTS II report generation together with all corresponding attributes related to them. The FACTS II (Federal Agencies' Centralized Trial-Balance System, version II) reporting process depends on USSGL account-level attributes such as balance type, authority type, transaction partner, and apportionment category to produce the required federal trial-balance submission. FV_FACTS_ATTRIBUTES provides the master repository that maps each FACTS account number to its USSGL account and to the descriptive attributes that drive report line generation.

With respect to the heuristic Data Vault classification mined from the foreign-key structure, the metadata indicates that FV_FACTS_ATTRIBUTES is standalone, meaning it is not identified as a link table through documented FK relationships. In a Data Vault modeling suggestion, a standalone reference table of this kind — keyed by a surrogate identifier and carrying descriptive, time-stamped attributes — is most naturally treated as a hub with satellite characteristics rather than a link. The table is owned by the FV schema and is documented as VALID, with a physical schema of 45 columns in ETRM 12.2.2.

Key Information Stored

The primary key of the table is FV_FACTS_ATTRIBUTES_PK, defined on the SGL_ATTRIBUTES_ID column. This surrogate identifier uniquely identifies each FACTS attribute record and is independent of the business meaning of the row. Two unique indexes are documented as business-key candidates:

The most significant columns include the business-key components SET_OF_BOOKS_ID, which ties the record to a specific ledger, and FACTS_ACCT_NUMBER, the FACTS reporting account. USSGL_ACCT_NUMBER holds the corresponding USSGL account. BALANCE_TYPE identifies whether the account is debit or credit in nature. PUBLIC_LAW_CODE, REIMBURSEABLE_FLAG, AVAILABILITY_TIME, BEA_CATEGORY, APPORTIONMENT_CATEGORY, TRANSACTION_PARTNER, and BORROWING_SOURCE carry the federal budgetary and proprietary attributes that FACTS II reporting requires. DEFINITE_INDEFINITE_FLAG, LEGISLATIVE_INDICATOR, AUTHORITY_TYPE, and DEFICIENCY_FLAG describe budgetary authority characteristics, while GOVT_NON_GOVT, EXCH_NON_EXCH, and CUST_NON_CUST classify the counterparty and nature of the transaction. Standard Oracle audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — track record maintenance. The ATTRIBUTE1 through ATTRIBUTE15 and ATTRIBUTE_CATEGORY columns provide the customary Oracle EBS descriptive flexfield extension points. Additional flags such as ADVANCE_FLAG, TRANSFER_FLAG, and PYA_FLAG support specialized reporting treatment.

Common Use Cases and Queries

Typical use cases center on FACTS II report generation and the reconciliation of USSGL accounts to FACTS reporting lines. A common query pattern retrieves all attributes for a set of books to drive report mapping:

  • Selecting FACTS_ACCT_NUMBER, USSGL_ACCT_NUMBER, BALANCE_TYPE, and the reporting attribute columns for a given SET_OF_BOOKS_ID.
  • Joining to the general ledger to reconcile FACTS_ACCT_NUMBER against USSGL_ACCT_NUMBER balances.
  • Auditing configuration by filtering on U1 (SET_OF_BOOKS_ID, FACTS_ACCT_NUMBER) to detect duplicate or missing FACTS account definitions.
  • Extracting balances by BEA_CATEGORY, APPORTIONMENT_CATEGORY, or AUTHORITY_TYPE for federal budget execution reporting.
  • Reporting on TRANSACTION_PARTNER and GOVT_NON_GOVT to support intra-governmental and public eliminations.

Because the table is essentially static reference data once configured, most queries are read-only extracts rather than transactional operations. Reporting against this table should always be constrained by SET_OF_BOOKS_ID to respect the business key defined by FV_FACTS_ATTRIBUTES_U1.

Related Objects

The documented metadata classifies FV_FACTS_ATTRIBUTES as standalone, so no foreign-key relationships to parent or child tables are provided. In practice, the table is referenced by the FACTS II reporting components within the Federal Financials module and relates to the following areas of the EBS data model:

  • GL_JE_LINES / GL_BALANCES — reconciled to FACTS_ACCT_NUMBER and USSGL_ACCT_NUMBER for trial-balance reporting.
  • FV_FACTS_ACCOUNTS or equivalent FACTS configuration objects — consume the attribute definitions defined here.
  • GL_SETS_OF_BOOKS — joined via SET_OF_BOOKS_ID to establish the ledger context.
  • FND_FLEX_VALUES / FND_ID_FLEX_STRUCTURES — related through USSGL_ACCT_NUMBER value set definitions.
  • FV reporting concurrent programs — read this table to generate FACTS II outputs.

Because the ETRM relationship data identifies the table as standalone, integrators should validate any assumed join paths against the actual foreign-key constraints present in the FV schema before relying on them in custom reporting.