Search Results fv_facts_authorizations




Overview
Explore in AI Chat

Overview

FV.FV_FACTS_AUTHORIZATIONS is a Federal Financials (FV) transaction table that stores authorization records associated with a Treasury symbol. In Oracle EBS Federal Financials, Treasury symbols (also known as Treasury Account Symbols or TAS) represent the appropriation, fund, and account codes used to identify federal funds. This table captures the authorization amounts and related attributes tied to those Treasury symbols, supporting federal budgetary accounting and reporting requirements such as SF-133 (Report on Budget Execution) and GTAS (Governmentwide Treasury Account Symbol) reporting.

The table resides in the FV schema and is marked VALID in ETRM 12.2.2. Based on the heuristic Data Vault classification derived from its foreign key structure, FV_FACTS_AUTHORIZATIONS is modeled as a standalone object — it does not serve as a hub with satellite/link dependencies from within the mined FK graph, though it references FV_FACTS_RT7_CODES via RT7_CODE_ID. This modeling suggestion reflects its role as a fact-like entity capturing authorization amounts rather than a pure master-data hub.

Key Information Stored

The table contains 26 documented columns. The most significant are:

  • AUTHORIZATION_ID — the surrogate primary key (PK FV_FACTS_AUTHORIZATIONS_PK). This is the internal unique identifier for each authorization record and also appears as the business-key candidate in unique index FV_FACTS_AUTHORIZATIONS_U1.
  • TREASURY_SYMBOL_ID — identifies the Treasury symbol (TAS) to which the authorization applies. Combined with RT7_CODE_ID, it forms the composite business-key candidate in unique index FV_FACTS_AUTHORIZATIONS_U2.
  • RT7_CODE_ID — foreign key to FV_FACTS_RT7_CODES, linking the authorization to a Report Type 7 code (a federal Treasury reporting classification/category).
  • SET_OF_BOOKS_ID — the ledger (set of books) context under which the authorization is recorded; essential for multi-ledger federal environments.
  • PRECLOSING_UNEXPENDED_AMT — the unexpended balance captured before year-end preclosing, a key figure for federal fund balance and appropriation reporting.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield (DFF) columns, used to store client-specific authorization attributes without schema changes.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard Oracle "who" audit columns, recording insertion and modification metadata.

The two unique indexes distinguish the surrogate key (AUTHORIZATION_ID) from the natural business key (TREASURY_SYMBOL_ID + RT7_CODE_ID).

Common Use Cases and Queries

Federal accounting users query this table to reconcile authorization amounts against a Treasury symbol, to prepare SF-133 and GTAS extracts, and to review preclosing unexpended balances. A typical lookup joins to the RT7 code table:

  • Authorization lookup by Treasury symbol: SELECT a.authorization_id, a.treasury_symbol_id, a.rt7_code_id, a.preclosing_unexpended_amt FROM fv.fv_facts_authorizations a WHERE a.treasury_symbol_id = :p_tas_id;
  • Joined reporting extract: SELECT a.treasury_symbol_id, r.rt7_code, a.preclosing_unexpended_amt FROM fv.fv_facts_authorizations a, fv.fv_facts_rt7_codes r WHERE a.rt7_code_id = r.rt7_code_id AND a.set_of_books_id = :p_sob;
  • Business-key validation: query the composite unique keys to confirm no duplicate authorizations exist per Treasury symbol and RT7 code.
  • DFF reporting: filter or group by ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 for client-specific analysis.

Related Objects

  • FV_FACTS_RT7_CODES — referenced by FV_FACTS_AUTHORIZATIONS.RT7_CODE_ID; the RT7 classification master providing the reporting category for each authorization.
  • FV_TREASURY_SYMBOLS (Treasury symbol/TAS definition) — source of TREASURY_SYMBOL_ID context, though the FK was not explicitly mined.
  • FV_FACTS_* fact tables in the same Federal Financials fact family, which share the Treasury symbol grain and are often queried together for federal reporting.
  • GL_SETS_OF_BOOKS — joined via SET_OF_BOOKS_ID to resolve ledger names and currency.
  • FND descriptive flexfield views for the ATTRIBUTE_CATEGORY/ATTRIBUTE1–15 columns, used to expose client-defined attributes.

Because the Data Vault classification is standalone, integration is driven primarily through the TREASURY_SYMBOL_ID business key rather than cascading hub/link relationships.