Results for “fv_facts_bud_fed_accts”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FV_FACTS_BUD_FED_ACCTS is a Federal Financials (FV) product table in the Oracle E-Business Suite database, owned by the FV schema. It holds information about the federal account symbols associated with budget account codes, serving as the association layer between the budget accounting structure and the federal account symbol used in federal reporting and funds control. The table is documented as VALID in ETRM and is present in both EBS 12.1.1 and 12.2.2 reference environments, with the 12.2.2 physical schema exposing 26 columns.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as standalone (a heuristic classification). Because the table carries a surrogate primary key together with descriptive attributes and effective-dating style audit columns, it is best modeled as a link (or link-satellite hybrid) that resolves the many-to-many relationship between budget accounts and federal account symbols, rather than as a pure hub or satellite.

Key Information Stored

The table's primary key is FV_FACTS_BUD_FED_ACCTS_PK, defined on the surrogate column BUD_FED_ACCTS_ID. This artificial key is the row identifier; it is also protected by unique index FV_FACTS_BUD_FED_ACCTS_U3. Two additional unique indexes expose the business-key candidates:

• FV_FACTS_BUD_FED_ACCTS_U1 — unique on (BUDGET_ACCT_CODE_ID, FEDERAL_ACCT_SYMBOL_ID), forming the natural composite key that guarantees each budget-to-federal-account pairing appears only once.
• FV_FACTS_BUD_FED_ACCTS_U2 — unique on FEDERAL_ACCT_SYMBOL_ID alone, indicating that in this implementation a single federal account symbol is associated with at most one budget account code.

The most important operational columns are:

• BUD_FED_ACCTS_ID — surrogate primary key.
• BUDGET_ACCT_CODE_ID — foreign key to FV_FACTS_BUDGET_ACCOUNTS; identifies the budget account code side of the association.
• FEDERAL_ACCT_SYMBOL_ID — foreign key to FV_FACTS_FEDERAL_ACCOUNTS; identifies the federal account symbol side.
• SET_OF_BOOKS_ID — the ledger context within which the association is defined.
• MAIN_ACCOUNT_CODE — the primary account code used to distinguish the account segment relevant to the symbol mapping.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield (DFF) storage, available for agency-specific extensions.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Oracle EBS auditing (WHO) columns tracking insert and change history.

Common Use Cases and Queries

This table is referenced whenever federal reporting or funds distribution requires the budget account code to be resolved to its federal account symbol. Typical scenarios include federal account symbol validation, USSGL/federal account cross-reference reporting, and set-of-books-scoped population of downstream federal facts. A representative join pattern follows:

• Resolve mappings for a ledger: SELECT f.BUD_FED_ACCTS_ID, b.BUDGET_ACCT_CODE, f2.FEDERAL_ACCT_SYMBOL FROM FV_FACTS_BUD_FED_ACCTS f JOIN FV_FACTS_BUDGET_ACCOUNTS b ON f.BUDGET_ACCT_CODE_ID = b.BUDGET_ACCT_CODE_ID JOIN FV_FACTS_FEDERAL_ACCOUNTS f2 ON f.FEDERAL_ACCT_SYMBOL_ID = f2.FEDERAL_ACCT_SYMBOL_ID WHERE f.SET_OF_BOOKS_ID = :p_sob_id;
• Detect unassociated symbols: query FV_FACTS_FEDERAL_ACCOUNTS with an outer join to this table on FEDERAL_ACCT_SYMBOL_ID where BUD_FED_ACCTS_ID is null.
• Audit recent changes: filter on LAST_UPDATE_DATE and LAST_UPDATED_BY to trace modifications to the mapping.

Because the table is standalone from a vault perspective and contains DFF attributes, it is also a useful source for incremental extraction into federal data marts, with LAST_UPDATE_DATE as the high-water mark.

Related Objects

• FV_FACTS_BUDGET_ACCOUNTS — referenced via BUDGET_ACCT_CODE_ID; the parent budget account code definition.
• FV_FACTS_FEDERAL_ACCOUNTS — referenced via FEDERAL_ACCT_SYMBOL_ID; the parent federal account symbol definition.
• FV_FACTS_BUD_FED_ACCTS_PK / _U1 / _U2 / _U3 — the primary key and unique index constraints that enforce row identity and the business key.
• GL_SETS_OF_BOOKS — the ledger identified by SET_OF_BOOKS_ID, providing the accounting context for each association.
• FV reporting views and federal fact tables that consume the budget-account-to-federal-symbol mapping for federal account symbol reporting.