Search Results fv_context




Overview
Explore in AI Chat

Overview

FV_TBAL_BY_TS_V is a Federal Financials (FV) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is defined to list the treasury symbols processed by the FACTS II Trial Balance process. FACTS II (Federal Agencies' Centralized Trial-Balance System II) is the U.S. Treasury mechanism through which federal agencies report pre-closing trial-balance data in the standard general ledger (SGL) format. The view therefore serves as a reporting and integration surface that consolidates treasury symbol attributes, ledger currency, SGL account descriptions, and period activity amounts into a single queryable structure.

The view is particularly relevant to the acct_segment search term because its definition is dynamically driven by the accounting segment identifier of the chart of accounts. The join to FND_ID_FLEX_SEGMENTS is constrained by APPLICATION_COLUMN_NAME = SYS_CONTEXT('FV_CONTEXT', 'ACCT_SEGMENT'), meaning the view resolves the correct SGL account segment at runtime from the Federal Financials context. This makes the view sensitive to how the accounting flexfield is configured for the ledger being processed.

Underlying Base Objects

The documented metadata identifies the following referenced base objects: FND_FLEX_VALUES, FND_FLEX_VALUES_TL, FND_ID_FLEX_SEGMENTS, FND_PROFILE, FND_SEGMENT_ATTRIBUTE_VALUES, FV_FACTS_TEMP, FV_TREASURY_SYMBOLS, GL_ACCESS_SET_LEDGERS, and GL_LEDGERS. The view text joins FV_TREASURY_SYMBOLS (FTS), FV_FACTS_TEMP (FFT), GL_SETS_OF_BOOKS (GSB), FND_FLEX_VALUES_TL (FFV), FND_ID_FLEX_SEGMENTS (FFIS), and FND_FLEX_VALUES (FFVL). The driving filter is FFT.FCT_INT_RECORD_CATEGORY = 'STBAL', restricting output to trial-balance staged records.

The join path links each staged FACTS II record to its treasury symbol through TREASURY_SYMBOL_ID, to the set of books through SET_OF_BOOKS_ID, and to the SGL account's value set and translated description through FLEX_VALUE_SET_ID, FLEX_VALUE_ID, and language. FND_PROFILE and the GL access-set objects support the surrounding security and context resolution used by the Federal Financials reporting layer.

Key Columns

  • TREASURY_SYMBOL – the Treasury accounting symbol under which balances are reported.
  • CURRENCY_CODE – ledger currency from GL_SETS_OF_BOOKS.
  • DESCRIPTION – translated SGL account description from FND_FLEX_VALUES_TL.
  • SGL_ACCT_NUMBER – the standard general ledger account number mapped from the source data.
  • BEGINNING_BALANCE, PERIOD_DR, PERIOD_CR – opening balance and period debit/credit activity sourced from FV_FACTS_TEMP amounts.
  • ENDING_BALANCE – computed as AMOUNT + AMOUNT1 − AMOUNT2 (beginning balance plus period debits less period credits).
  • SEGMENT1 through SEGMENT30 – the accounting flexfield segment values carried from the FACTS II staging table, enabling account-level drill-down.

Common Use Cases and Queries

Typical usage includes validating FACTS II trial-balance extracts, reconciling beginning and ending balances by treasury symbol, and confirming that SGL account descriptions resolve correctly for the active chart of accounts.

SELECT treasury_symbol, currency_code, sgl_acct_number,
       beginning_balance, period_dr, period_credit, ending_balance
FROM   apps.fv_tbal_by_ts_v
WHERE  treasury_symbol = :p_treasury_symbol;

SELECT sgl_acct_number, description,
       SUM(period_dr) AS total_dr, SUM(period_cr) AS total_cr
FROM   apps.fv_tbal_by_ts_v
GROUP  BY sgl_acct_number, description
ORDER  BY sgl_acct_number;

Because the view depends on SYS_CONTEXT values set by the Federal Financials context, queries should be executed from within the application or after the FV_CONTEXT chart-of-accounts and accounting-segment values have been initialized; otherwise the FND_ID_FLEX_SEGMENTS join returns no rows.