Search Results fv_facts_attributes_u2

Overview

FV.FV_FACTS_ATTRIBUTES is a Federal Financials table in the Oracle E-Business Suite that stores the United States Standard General Ledger (USSGL) accounts used for FACTS II report generation, together with all associated reporting attributes. The FACTS II (Federal Agencies' Centralized Trial-Balance System II) submission requires agencies to report their trial balances using USSGL account attributes that describe budgetary and proprietary characteristics of each account. This table serves as the configuration and mapping repository that links a Set of Books to its FACTS account numbers and the corresponding USSGL attributes required by Treasury.

The table is owned by the FV schema, resides in the APPS_TS_TX_DATA tablespace, and is documented as VALID across EBS 12.1.1 and 12.2.2. Its primary key is FV_FACTS_ATTRIBUTES_PK, defined on SGL_ATTRIBUTES_ID. Under a heuristic Data Vault classification mined from the foreign-key and constraint structure, the object is assessed as standalone. This suggests a modeling approach in which FV_FACTS_ATTRIBUTES is treated as a reference or configuration entity rather than a classic hub, link, or satellite. In Data Vault terms, it would behave less like a transactional subject area hub and more like a reference table whose rows are keyed by a system-generated surrogate and distinguished by business keys.

Key Information Stored

The primary key of the table is the surrogate SGL_ATTRIBUTES_ID, a system-generated NUMBER(15) identifier that uniquely distinguishes every attribute row. Two unique indexes protect business-key candidates. FV_FACTS_ATTRIBUTES_U1 is a composite unique index over SET_OF_BOOKS_ID and FACTS_ACCT_NUMBER, meaning a given FACTS account number may appear only once per Set of Books. FV_FACTS_ATTRIBUTES_U2 is a unique index on SGL_ATTRIBUTES_ID itself, reinforcing the single-column surrogate key.

The most significant columns fall into three groups:

• Account mapping: SET_OF_BOOKS_ID (the accounting Set of Books identifier), FACTS_ACCT_NUMBER (the FACTS account number, VARCHAR2(30)), and USSGL_ACCT_NUMBER (the corresponding USSGL account number, VARCHAR2(30)).
• FACTS II reporting attributes: BALANCE_TYPE (valid values B for Beginning, E for Ending, and S for Both), PUBLIC_LAW_CODE, REIMBURSEABLE_FLAG, AVAILABILITY_TIME, BEA_CATEGORY, APPORTIONMENT_CATEGORY, TRANSACTION_PARTNER, BORROWING_SOURCE, DEFINITE_INDEFINITE_FLAG, LEGISLATIVE_INDICATOR, AUTHORITY_TYPE, DEFICIENCY_FLAG, and FUNCTION_FLAG.
• Additional classification flags: GOVT_NON_GOVT (government or nongovernment account indicator), EXCH_NON_EXCH, CUST_NON_CUST, BUDGET_SUBFUNCTION, ADVANCE_FLAG, TRANSFER_FLAG, and PYA_FLAG.
• Standard who columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN, plus the fifteen generic ATTRIBUTE1 through ATTRIBUTE15 and ATTRIBUTE_CATEGORY descriptor columns.

The documented physical schema contains 45 columns in total, though the most important for reporting and integration are the account identifiers, the balance type, and the flags that drive FACTS II categorization.

Common Use Cases and Queries

The principal use case is FACTS II report generation: the Federal Financials engine reads this table to determine how each accounting flexfield account maps to USSGL accounts and which Treasury reporting attributes apply. A second use case is configuration verification when an agency implements or migrates FACTS II reporting, confirming that every Set of Books and FACTS account number is uniquely defined.

Typical SQL patterns include retrieving all attributes for a Set of Books:

• SELECT facts_acct_number, ussgl_acct_number, balance_type, bea_category, authority_type FROM fv.fv_facts_attributes WHERE set_of_books_id = :p_sob_id;
• Audit reporting on balance type distribution: SELECT balance_type, COUNT(*) FROM fv.fv_facts_attributes GROUP BY balance_type;
• Detecting duplicate or orphaned mappings using the unique indexes: a query joining the composite keys in FV_FACTS_ATTRIBUTES_U1 against expected account ranges reveals gaps in setup.

Reporting consumers frequently join this table to the chart of accounts (GL_CODE_COMBINATIONS) and Set of Books definitions to produce reconciliation and audit reports. Because the table is a standalone reference store, most usage is read-oriented, with administrative maintenance through concurrent or forms-based setup.

Related Objects

The table has no documented foreign keys, consistent with its standalone Data Vault classification, but it participates in logical joins with several standard EBS objects:

• GL_SETS_OF_BOOKS — joined on SET_OF_BOOKS_ID to resolve the accounting book for each attribute row.
• GL_CODE_COMBINATIONS — joined indirectly through FACTS_ACCT_NUMBER to reconcile USSGL mappings against the chart of accounts.
• FV_FACTS_ATTRIBUTES_U1 and FV_FACTS_ATTRIBUTES_U2 — the unique indexes that enforce business-key integrity on (SET_OF_BOOKS_ID, FACTS_ACCT_NUMBER) and SGL_ATTRIBUTES_ID.
• FND_USER — referenced by the CREATED_BY and LAST_UPDATED_BY who columns.

Additional related objects are the FACTS II reporting concurrent programs and the FV USSGL and attribute configuration tables that drive Treasury submission. Administrators should treat FV_FACTS_ATTRIBUTES as the authoritative mapping layer between Oracle General Ledger accounts and the FACTS II reporting structure.