Search Results federal_old_ccid

Overview

FV_XLA_PO_REF_V is an APPS-owned database view in Oracle E-Business Suite 12.1.1 and 12.2.2 that serves as a Federal financials reference layer for purchase order and Subledger Accounting (XLA) event data. The view projects a Federal-oriented set of aliased columns from a global temporary table, FV_EXTRACT_DETAIL_GT, filtering to a single application context: records where APPLICATION_ID equals 201. This filter restricts the result set to the Subledger Accounting application, aligning the view with XLA event extraction for Federal Government accounting.

The view's name — combining "FV" (the Federal financials schema prefix), "XLA" (Subledger Accounting), and "PO_REF" (purchase order reference) — indicates its role as a reporting and integration access point. It exposes Federal fund, prior-year adjustment (PYA), anticipation, and treasury-confirmation attributes mapped to Federal column names, allowing downstream reports and interfaces to consume Federal accounting attributes without directly querying the underlying temporary table. For users searching on "prior_year_flag," the view is directly relevant: it surfaces PRIOR_YEAR_FLAG as FEDERAL_PRIOR_YEAR_FLAG.

Underlying Base Objects

The view is defined over a single documented base object, FV_EXTRACT_DETAIL_GT, which is a global temporary table. Because it is a temporary table, the rows visible through FV_XLA_PO_REF_V are session-specific and populated only for the duration of the transaction or session that loads the extract data. The view performs no joins, aggregations, or grouping: it is a thin projection with column renaming and a constant predicate (APPLICATION_ID = 201). Consequently, its behavior is entirely dependent on the contents of FV_EXTRACT_DETAIL_GT at query time.

The absence of joins to permanent Federal or XLA tables means the view does not enrich data on its own; it merely re-labels extraction attributes. Consumers must therefore ensure the temporary table is populated before querying the view.

Key Columns

Every column in the view follows the pattern of a source column aliased with a FEDERAL_ prefix. Notable columns include:

• FEDERAL_EVENT_ID (from EVENT_ID) — identifier of the XLA accounting event.
• FEDERAL_LINE_NUMBER (from LINE_NUMBER) — line-level reference within the event.
• FEDERAL_FUND_VALUE (from FUND_VALUE) and FEDERAL_FUND_CATEGORY (from FUND_CATEGORY) — Treasury fund attributes.
• FEDERAL_FUND_EXPIRED_STATUS (from FUND_EXPIRED_STATUS) — indicates fund expiration state.
• FEDERAL_PRIOR_YEAR_FLAG (from PRIOR_YEAR_FLAG) — the key column matched by "prior_year_flag" searches; flags whether a transaction pertains to a prior year.
• FEDERAL_PYA_AMT (from ENTERED_PYA_AMT) and FEDERAL_PYA_DIFF_AMT (from ENTERED_PYA_DIFF_AMT) — entered prior-year adjustment amounts and differences.
• FEDERAL_ADJUSTMENT_TYPE (from ADJUSTMENT_TYPE) and FEDERAL_NET_PYA_ADJ_AMT (from NET_PYA_ADJ_AMT) — adjustment classification and net PYA adjustment amount.
• FEDERAL_ANTICIPATION (from ANTICIPATION), FEDERAL_ANTICIPATED_AMT (from ANTICIPATED_AMT), FEDERAL_UNANTICIPATED_AMT (from UNANTICIPATED_AMT) — anticipation indicator and amounts.
• FEDERAL_TCF_AMT (from TCF_AMT) — treasury confirmation amount.
• FEDERAL_OLD_CCID (from OLD_CCID) — the prior code combination identifier associated with the adjustment.

Common Use Cases and Queries

The view is typically used when Federal accounting logic must reference the renaming convention or isolate Subledger Accounting extraction rows. A common scenario is identifying prior-year transactions during period close or reporting.

• Retrieving prior-year flagged transactions:
  SELECT FEDERAL_EVENT_ID, FEDERAL_LINE_NUMBER, FEDERAL_FUND_VALUE, FEDERAL_PYA_AMT, FEDERAL_NET_PYA_ADJ_AMT FROM APPS.FV_XLA_PO_REF_V WHERE FEDERAL_PRIOR_YEAR_FLAG = 'Y';
• Selecting all Federal attributes for a given event:
  SELECT * FROM APPS.FV_XLA_PO_REF_V WHERE FEDERAL_EVENT_ID = :event_id;
• Reviewing anticipation versus unanticipated amounts:
  SELECT FEDERAL_EVENT_ID, FEDERAL_ANTICIPATED_AMT, FEDERAL_UNANTICIPATED_AMT FROM APPS.FV_XLA_PO_REF_V WHERE FEDERAL_ANTICIPATION = 'Y';

Because the underlying object is a global temporary table, correct results require that the extraction process has populated FV_EXTRACT_DETAIL_GT for APPLICATION_ID 201 in the current session. Queries issued outside that context may return no rows or incomplete data.