Search Results budget_subfunction




Overview
Explore in AI Chat

Overview

FV_FACTS_PERIOD_BALANCES_TB_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Federal Financials (FV) product family. It exposes period-level fund balance data that has been staged for federal financial statement reporting and Treasury/agency-level distribution. The "TB" suffix denotes its association with trial-balance style output, and the view consolidates reported period attributes with both ending and differential balance facts so that downstream federal reports can consume a single, uniform result set.

The view is a UNION ALL construct. The first branch reads period attribute and balance information from FV_FACTS1_PERIOD_ATTRIBUTES for records whose REPORTED_GROUP falls in the values '1' and 'E'. The second branch joins the same attributes to detail- and difference-level fact data, enriching each row with eliminations department logic, federal/non-federal (G_NG_INDICATOR) derivation, and party classification handling. This structure supports the federal requirement to separate intra-governmental (federal) activity from public (non-federal) activity, and to compute eliminations between trading partners.

The user search term "fund_value" maps directly to the FUND_VALUE column, which is one of the primary fund accounting identifiers surfaced by the view and is central to fund-level balance reporting.

Underlying Base Objects

According to the documented ETRM metadata for 12.2.2, the view is defined over the following referenced base objects, all exposed in the APPS schema as synonyms:

The join between the period attribute source and the fact sources is keyed on the common accounting and period dimensions, producing one consolidated balance row per fund/account/period combination. The UNION ALL second branch contributes additional rows for reported groups requiring elimination and party-based classification.

Key Columns

The view exposes the following significant columns:

  • CCID — the code combination identifier linking to the accounting flexfield (GL_CODE_COMBINATIONS).
  • SET_OF_BOOKS_ID — the ledger/set of books to which the balance belongs.
  • PERIOD_YEAR, PERIOD_NUM, PERIOD_NAME — period identifiers for the reporting fiscal year and accounting period.
  • FUND_GROUP, FUND_VALUE — fund classification and the specific fund value used in federal fund accounting; FUND_VALUE is the primary fund identifier in this view.
  • ACCOUNT_NUMBER, USSGL_ACCOUNT — the natural account and the USSGL (United States Standard General Ledger) account mapping.
  • DEPT_ID, BUREAU_ID — organizational/agency identifiers.
  • G_NG_INDICATOR — governmental/non-governmental (federal/non-federal) indicator.
  • ELIMINATIONS_DEPT — trading partner department used for intra-governmental eliminations.
  • END_BAL_IND, REPORTED_STATUS, BALANCE_TYPE — reporting control flags (REPORTED_STATUS is hardcoded to 'R'; BALANCE_TYPE to 'G').
  • AMOUNT, BEGINNING_BALANCE, PERIOD_DR, PERIOD_CR, PERIOD_BEGIN_BAL — the balance measures.
  • D_C_INDICATOR — derived debit/credit indicator computed via DECODE(SIGN(...)).
  • RECIPIENT_NAME — populated as NULL in the first branch, reserved for recipient-level reporting.

Common Use Cases and Queries

Typical usage centers on extracting fund-level balances for federal reporting and Treasury reconciliation, filtering by the FUND_VALUE column, and pivoting by period.

  • Fund-level balance extraction for a given ledger and period.
  • Intra-governmental elimination reporting using G_NG_INDICATOR and ELIMINATIONS_DEPT.
  • USSGL account rollups for financial statement line items.
  • Fed/non-fed reconciliation across trading partners.

A representative query filtering on the primary search term is shown below:

SELECT ccid, set_of_books_id, period_year, period_num, fund_value, ussgl_account, g_ng_indicator, amount, beginning_balance, d_c_indicator FROM apps.fv_facts_period_balances_tb_v WHERE fund_value = :p_fund_value AND set_of_books_id = :p_sob AND period_year = :p_year AND period_num = :p_period ORDER BY ussgl_account;

Because the view is a UNION ALL of attribute-derived rows and fact-derived rows, callers should be aware that amounts in the second branch default BEGINNING_BALANCE, PERIOD_DR, PERIOD_CR, and PERIOD_BEGIN_BAL to zero, and that consumers should filter REPORTED_STATUS or PERIOD_NAME to avoid double counting when combining both branches.