Search Results start_date_fk




Overview
Explore in AI Chat

Overview

The view APPS.POA_EDW_AGREEMENT_LINES_FCV is a Purchasing (PO) module database object that serves as the Contract Agreement Lines Fact Collection View for the Oracle E-Business Suite Enterprise Data Warehouse (EDW). It is classified as a fact collection view, meaning it is designed to expose transactional fact data at the agreement line level in a format suitable for extraction, transformation, and load into an analytical or data warehousing environment. In Oracle EBS 12.1.1 and 12.2.2, this view is registered in the APPS schema with a status of VALID and is owned by APPS.

Its role is not operational in the sense of transactional processing; rather, it is a reporting and integration artifact. It provides a denormalized, foreign-key-oriented projection of contract agreement line data so that downstream EDW processes can consolidate purchasing contract information with dimension tables. The naming convention—"FCV" for Fact Collection View—confirms its purpose as a source for fact table population within the ETRM/EDW framework.

Underlying Base Objects

The documented ETRM metadata for this object does not enumerate referenced base tables. What is documented is the view text, which reveals a substantial column list encompassing identifiers, foreign keys, dates, flags, and numeric measures. Because the view is defined in the APPS schema and draws on contract agreement line concepts, it is understood to select from the Purchasing contract and agreement line base objects—principally the PO agreement/contract headers and lines (such as PO_HEADERS_ALL and PO_LINES_ALL, along with the associated agreement and contract tables) and their supporting lookups. The presence of columns such as PO_HEADER_ID, PO_LINE_ID, ITEM_ID, and ITEM_DESCRIPTION is consistent with this interpretation.

The view does not expose the full denormalized descriptive attributes of its sources. Instead it projects a curated set of keys and measures, which is characteristic of fact collection views that rely on separate dimension views to supply descriptive context during the ETL process.

Key Columns

The columns fall into several functional categories:

Common Use Cases and Queries

This view is typically queried during EDW extraction runs to populate contract agreement line fact tables. A representative query selects measures and keys for a date range:

  • SELECT AGREE_LN_INST_PK, PO_HEADER_ID, PO_LINE_ID, BUYER_FK, OPERATING_UNIT_FK, AMT_AGREED_T, QTY_AGREED_T FROM APPS.POA_EDW_AGREEMENT_LINES_FCV WHERE LAST_UPDATE_DATE >= :last_run_date;
  • Joins against dimension views for supplier, buyer, and item to enrich the fact records.
  • Aggregation of agreed versus released amounts and quantities for contract consumption analysis.

Because it is a read-only view with no documented base objects exposed to the caller, direct ad hoc querying should be limited to reporting contexts, and any schema changes should be validated against the ETRM documentation before use in 12.1.1 or 12.2.2 environments.