Search Results federal_apportionment_category

Overview

APPS.FV_XLA_AR_REF_V is a reporting and integration view in Oracle E-Business Suite that exposes Federal financial attribute data originating from the Subledger Accounting (XLA) extraction process for Oracle Receivables. The view presents one row per accounting event line, joined against federal fund-accounting descriptors such as fund time frame, fund expiration status, and fund category. Its primary role is to supply downstream Federal accounting and reporting processes with a normalized, decode-adjusted representation of Receivables extract data, mapping internal single-character fund category codes to their Federal apportionment and fund category equivalents.

The "AR" token in the view name indicates the Receivables application context, while the "XLA" token reflects its dependency on Subledger Accounting event data. The view is filtered to a single application context, restricting output to APPLICATION_ID = 222, which corresponds to Oracle Receivables.

Underlying Base Objects

The view is defined exclusively over the table FV_EXTRACT_DETAIL_GT, which is the documented referenced base object. FV_EXTRACT_DETAIL_GT functions as a global temporary table that holds extract detail rows produced during federal fund-accounting extract processing. Because the view reads directly from this table without additional joins, its contents are entirely dependent on rows currently populated in the global temporary table for the active session and the Receivables application context. All column transformations are performed inline through SELECT list expressions and DECODE functions rather than through joins to reference tables.

Key Columns

The view exposes the following columns, each aliased with a FEDERAL_ prefix to denote its federal reporting semantics:

• FEDERAL_EVENT_ID — Sourced from EVENT_ID; identifies the Subledger Accounting event.
• FEDERAL_LINE_NUMBER — Sourced from LINE_NUMBER; identifies the line within the event.
• FEDERAL_FUND_TIME_FRAME — Sourced from FUND_TIME_FRAME; indicates the applicable fund time period.
• FEDERAL_FUND_EXPIRED_STATUS — Sourced from FUND_EXPIRED_STATUS; indicates whether the fund is expired.
• FEDERAL_APPORTIONMENT_CATEGORY — Derived via DECODE on FUND_CATEGORY, mapping A/B/C to A/B/C and R/S/T to A/B/C respectively.
• FEDERAL_FUND_CATEGORY — Derived via DECODE on FUND_CATEGORY, mapping A/B/C to Direct and R/S/T to Reimbursable.
• FEDERAL_PRIOR_YEAR_FLAG — Sourced from PRIOR_YEAR_FLAG.
• FEDERAL_ACCOUNT_VALID_FLAG — Sourced from ACCOUNT_VALID_FLAG.
• FEDERAL_ACCOUNT_RULE — Sourced from ACCOUNT_RULE.
• FED_RECEIVABLE_WITH_ADVANCE — Sourced from RECEIVABLE_WITH_ADVANCE.

Common Use Cases and Queries

The view is typically queried during federal fund-accounting extract validation, reconciliation of Receivables events to federal fund attributes, and preparation of federal apportionment reporting. A common query retrieves all federal attributes for a given event:

• SELECT federal_event_id, federal_line_number, federal_apportionment_category, federal_fund_category FROM apps.fv_xla_ar_ref_v WHERE federal_event_id = :event_id;
• SELECT federal_fund_category, COUNT(*) FROM apps.fv_xla_ar_ref_v GROUP BY federal_fund_category;
• SELECT * FROM apps.fv_xla_ar_ref_v WHERE federal_fund_expired_status = 'Y';

Because the underlying object is a global temporary table, queries return data only within the session that populated FV_EXTRACT_DETAIL_GT. This constraint makes the view suitable for in-process extract validation rather than persistent historical reporting.