Search Results fv_xla_ar_ref_v




Overview
Explore in AI Chat

Overview

The FV_XLA_AR_REF_V view is a Federal Financials (FV) reporting object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is classified in ETRM as a VALID database view with a defined status and is documented as part of the Subledger Accounting (XLA) integration for the Receivables (AR) application. The view presents federal-specific reference attributes that accompany accounting event data extracted from the Subledger Accounting engine, exposing them under a consistent set of FEDERAL_* aliases suitable for downstream federal reporting, treasury symbol derivation, and apportionment analysis.

Its principal role is to bridge standard Subledger Accounting event/line identifiers with federal fund attributes—such as fund category, apportionment category, time frame, expiry status, and prior-year indicator—so that federal agencies can reconcile AR subledger activity against budget execution and Treasury reporting requirements.

Underlying Base Objects

Per the ETRM metadata, the view is defined over a single documented base object: FV_EXTRACT_DETAIL_GT (a global temporary table used within the Federal Financials extraction process). The view text confirms this relationship:

  • Source: FV_EXTRACT_DETAIL_GT, restricted with WHERE APPLICATION_ID = 222. Application ID 222 corresponds to Oracle Receivables, indicating the view is scoped specifically to AR subledger extraction rows.
  • The global temporary table nature of the base object means data is session-scoped; the view is therefore typically consumed during or immediately after the federal extraction/accounting program runs.

Because the base is a GT table, the view inherits transient behavior—rows exist only for the duration of the extraction session and are not persisted across sessions.

Key Columns

The view exposes ten columns, all aliased to FEDERAL_* names. Notable derivations include:

Common Use Cases and Queries

Typical scenarios include federal AR subledger reporting, apportionment categorization, and reconciliation of direct versus reimbursable funds. A representative query:

  • SELECT federal_event_id, federal_line_number, federal_fund_category, federal_apportionment_category FROM fv_xla_ar_ref_v WHERE federal_prior_year_flag = 'Y'; — isolates prior-year AR activity.
  • SELECT federal_apportionment_category, COUNT(*) FROM fv_xla_ar_ref_v GROUP BY federal_apportionment_category; — summarizes activity by apportionment class.
  • Joining back to XLA_EVENTS on FEDERAL_EVENT_ID supports drill-down from federal attributes to the underlying accounting event.

Because the view depends on a global temporary table, queries must execute within the originating extraction session to return meaningful results.