Results for “fvfv_treasury_symbols”

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

Overview

FVFV_TREASURY_SYMBOLS is a read-only reporting view in the Oracle E-Business Suite Federal Financials (FV) module. It presents Treasury Symbol information — the account symbols used by federal agencies to identify and report on funds held at the U.S. Treasury — in a denormalized, human-readable form suitable for reporting and integration. The view joins federal account data to Treasury symbol records and to the General Ledger sets of books, resolving several coded values through Oracle EBS descriptive flexfield and lookup mechanisms at query time.

The view is defined WITH READ ONLY, meaning it cannot be used as the target of DML; it is intended strictly for query and extract purposes. In Oracle EBS 12.1.1 and 12.2.2, the object is documented in the ETRM repository but the implementation note states it is not implemented in the reference database. When present, it is used primarily for extracting Treasury Symbol attributes in support of federal reporting such as the SF-224 (Statement of Transactions) and Treasury Account Symbol (TAS) reporting, and for reconciliation between federal account symbols and their Treasury counterparts.

Underlying Base Objects

The view is defined over three documented base objects:

• FV_FACTS_FEDERAL_ACCOUNTS (FFA) — the federal accounts table, supplying the federal account symbol name.
• FV_TREASURY_SYMBOLS (FTS) — the Treasury symbol table, supplying the Treasury symbol, TAS attributes, SF-224 outlay figures, and audit columns.
• GL.GL_SETS_OF_BOOKS (GSB) — the General Ledger sets of books, supplying the set of books name.

The join conditions are: FFA.FEDERAL_ACCT_SYMBOL_ID = FTS.FEDERAL_ACCT_SYMBOL_ID and GSB.SET_OF_BOOKS_ID = FTS.SET_OF_BOOKS_ID. Because Oracle EBS views frequently resolve flexfield and lookup segments through virtual columns and label expressions, the SELECT list contains descriptive flexfield (_DF) and lookup (_LA) expressions that are expanded at execution time. No additional referenced base objects beyond these three are documented in the ETRM metadata.

Key Columns

• FEDERAL_ACCT_SYMBOL_NAME — the descriptive name of the federal account symbol associated with the Treasury symbol.
• TREASURY_SYMBOL / TREASURY_SYMBOL_ID — the Treasury account symbol itself and its surrogate primary key.
• _LA:TIME_FRAME — a lookup-decoded value (FUND_TIME_FRAME) describing the fund's time frame.
• YEARS_AVAILABLE — the period over which the appropriation remains available for obligation.
• ESTABLISHED_FISCAL_YR — the fiscal year in which the Treasury symbol was established. This is the column most directly relevant to the user's search term "established_fiscal_yr," and it is sourced directly from FV_TREASURY_SYMBOLS.ESTABLISHED_FISCAL_YR.
• EXPIRATION_DATE / CANCELLATION_DATE — the dates on which the fund expires and is ultimately cancelled.
• TAFS_SUB_ACCT / TAFS_SPLIT_CODE / TAFS_SPLIT_NAME — Treasury Account Fund Symbol sub-account and split attributes.
• _LA:RESOURCE_TYPE, _LA:SF224_TYPE_CODE — lookup-decoded resource type and SF-224 transaction type.
• DEF_INDEF_FLAG — decoded to "DEFINITE" or "INDEFINITE" based on the underlying flag.
• DEPARTMENT_ID, BUREAU_ID, BUSINESS_LINE — organizational identifiers associated with the Treasury symbol.
• SET_OF_BOOKS_ID / GL_SETS_OF_BOOKS_NAME — the ledger context for the symbol.
• SF224_QTR1_OUTLAY through SF224_QTR4_OUTLAY — quarterly outlay amounts reported on the SF-224.
• PRECLOSING_UNEXPENDED_AMT, CLOSE_REQUISITIONS — year-end closing attributes.
• _DF — the expanded descriptive flexfield segment for the Treasury symbol (FV_TREAS_SYM_DESC_FLEX).
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY.

Common Use Cases and Queries

Typical uses include identifying Treasury symbols established in a given fiscal year, reviewing funds approaching expiration or cancellation, and extracting SF-224 outlay data for federal reporting. A sample query filtered by the searched attribute:

SELECT treasury_symbol,
       federal_acct_symbol_name,
       established_fiscal_yr,
       expiration_date,
       years_available
  FROM fvfv_treasury_symbols
 WHERE established_fiscal_yr = :p_fiscal_year
 ORDER BY treasury_symbol;

A second scenario lists symbols nearing expiration for a specific ledger:

SELECT treasury_symbol, gl_sets_of_books_name,
       expiration_date, cancellation_date
  FROM fvfv_treasury_symbols
 WHERE expiration_date <= :p_cutoff_date
   AND gl_sets_of_books_name = :p_sob_name;

Because the view resolves flexfields and lookups dynamically and is read-only, it is well suited to ad hoc reporting tools and extracts rather than to transactional processing. Where the object is not implemented in a given environment, equivalent results can be obtained by joining FV_FACTS_FEDERAL_ACCOUNTS, FV_TREASURY_SYMBOLS, and GL_SETS_OF_BOOKS directly using the documented join conditions.