Results for “fv_xla_ap_ref_v”

32 results




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

Overview

FV_XLA_AP_REF_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Federal Financials (FV) product. Its purpose is to expose, in a Federal-oriented naming convention, the Accounts Payable subledger accounting extract data that has been staged in the FV_EXTRACT_DETAIL_GT global temporary table. The view filters that staging table to APPLICATION_ID = 200, which is the Oracle Subledger Accounting application identifier corresponding to Payables (AP). In practice, FV_XLA_AP_REF_V acts as the AP-specific access point for Federal fund, obligation, and payment attributes that are consumed by Federal Financials reporting and by downstream extracts that feed Treasury, GTAS, or USSGL-oriented processes. Because it is a view rather than a stored table, it presents no persisted data of its own; every query reflects the current contents of the underlying staging table for the active session.

Underlying Base Objects

The view is defined over a single documented base object, the table FV_EXTRACT_DETAIL_GT, a global temporary table populated during the extract process. The definition is a straightforward projection that renames the technical staging columns into Federal-prefixed aliases, together with a hard-coded filter restricting the result set to the AP application. The column mapping is direct for the fund, obligation, and amount attributes, while FEDERAL_FUND_CAT_DESC is derived through a DECODE on FUND_CATEGORY, translating fund category codes A, B, and C to 'DIRECT' and codes R, S, and T to 'REIMBURSABLE'. This derivation applies no transformation to the monetary values themselves; amounts are surfaced exactly as staged. Because the source is a global temporary table, the view is meaningful only within a session that has already executed the FV extract that populates FV_EXTRACT_DETAIL_GT.

Key Columns

Common Use Cases and Queries

The view is typically queried after an AP extract has been run into FV_EXTRACT_DETAIL_GT, either interactively for validation or embedded within Federal Financials concurrent reports and PL/SQL logic. A diagnostic query focusing on the paid unexpended obligation amount would resemble:

SELECT federal_event_id, federal_line_number, federal_fund_value, federal_paid_unexp_obg_amt, federal_unpaid_unexp_obg_amt
FROM apps.fv_xla_ap_ref_v
WHERE federal_paid_unexp_obg_amt <> 0;

Typical scenarios include reconciling obligated versus expended balances for Treasury reporting, verifying fund category classification through FEDERAL_FUND_CAT_DESC, isolating prior-year adjustments using FEDERAL_PRIOR_YEAR_FLAG, and dividing activity between anticipated and unanticipated amounts. Because the underlying table is session-scoped, a query against the view outside the extract session, or before the extract has run, returns no rows. All columns referenced in the view are documented as available; the object is listed as VALID in the ETRM metadata for both 12.1.1 and 12.2.2.