Search Results federal_fund_value




Overview
Explore in AI Chat

Overview

The FV_XLA_CST_REF_V view is a Federal Financials (FV) reporting object owned by the APPS schema. It exposes subledger cost reference and fund attributes extracted from the Subledger Accounting (XLA) extract process, presenting them with a federal-oriented naming convention. The view is defined as a restricted projection over the global temporary table FV_EXTRACT_DETAIL_GT, filtered to APPLICATION_ID = 707, which corresponds to the Federal Financials application within Oracle EBS. Because the object is a view, no data is physically stored; results are materialized at query time from the underlying extract data.

Its role is to supply downstream accounting and reporting components — particularly federal budgetary and fund accounting routines — with a stable, semantically named interface to the raw extract columns. This abstraction isolates consumers from the physical column names in the global temporary table and applies a business decode for fund category classification. The view is documented as VALID in the ETRM repository for both Oracle EBS 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over a single documented base object:

  • FV_EXTRACT_DETAIL_GT — a global temporary table holding extract-level detail rows for the federal subledger accounting process.

The defining query selects directly from FV_EXTRACT_DETAIL_GT and applies the predicate WHERE APPLICATION_ID = 707. This filter restricts rows to the Federal Financials application, ensuring that only federal subledger accounting extract records are surfaced. Because the source is a global temporary table, the row set visible through the view is session-scoped: rows are populated during the extract execution within the same session and are visible only to that session until the data is cleared or the session ends. Consumers must therefore query the view in the appropriate processing context rather than treating it as a persistent reporting source.

Key Columns

The view renames source columns into a FEDERAL_* convention. Notable columns include:

Common Use Cases and Queries

Typical uses include tracing federal accounting events back to their extract detail, validating fund category and fund status classification, and reconciling obligation and expenditure amounts during the subledger extract.

Retrieve all lines for a specific federal event:

  • SELECT federal_event_id, federal_line_number, federal_fund_value, federal_fund_category FROM fv_xla_cst_ref_v WHERE federal_event_id = :event_id;

Summarize net prior-year adjustment and unpaid open amounts by fund category:

  • SELECT federal_fund_category, SUM(federal_net_pya_adj_amt), SUM(federal_unpaid_open_amt) FROM fv_xla_cst_ref_v GROUP BY federal_fund_category;

Isolate reimbursable versus direct activity:

  • SELECT federal_event_id, federal_fund_value, federal_unexp_obg_amt FROM fv_xla_cst_ref_v WHERE federal_fund_category = 'REIMBURSABLE';

Because the view reads from a global temporary table, these queries are meaningful only while the federal extract session has populated FV_EXTRACT_DETAIL_GT. Outside that context, the view returns no rows.