Search Results req_creat_date_fk_key




Overview
Explore in AI Chat

Overview

POA_EDW_PO_DIST_F_IV is a database view delivered within the Oracle Purchasing Intelligence (POA) product family, the E-Business Suite operational data store that feeds the Purchasing and Procurement Analytics subject areas. The name follows the standard POA naming convention: "PO" for purchasing, "DIST" for the purchase order distribution level of granularity, "F" for fact, and "IV" denoting an interface or intermediate view used during the extract, transform, and load process into the enterprise data warehouse. In this position it functions as a flattened, denormalized presentation of purchasing distribution activity, exposing both measures (quantities and amounts) and dimensional foreign keys in a single row per distribution.

The view is not an end-user transactional object. It exists to support the ETL that populates the POA star schemas, and secondarily to allow reporting and integration queries to reconcile fact-level purchasing data without joining the many operational tables in the PO module. In Oracle EBS 12.1.1 and 12.2.2 the object is documented in ETRM as not implemented in the reference database, meaning the definition is shipped as part of the POA schema but is only materialized where Purchasing Intelligence is licensed and configured.

Underlying Base Objects

The documented ETRM metadata for this view records no referenced base objects, and the view text provided is a direct SELECT list rather than a join tree. In practice the view is defined over the POA staging and fact tables of the Purchasing Intelligence schema, drawing from PO distribution, line, and header extracts together with the associated EBS dimension key tables. The presence of a PO_DIST_INST_PK and PO_DIST_INST_PK_KEY pair indicates the row grain is the purchase order distribution instance. The view has no documented owner in the metadata, consistent with an object that is created by the POA schema installation rather than by the core PO module.

Key Columns

The columns exposed by the view fall into three groups:

The PO_COMMENTS column carries the free-text comment entered at the purchase order header or line level and is exposed at the distribution grain for comment analysis and drill-through reporting.

Common Use Cases and Queries

Typical uses include spend and savings analysis by buyer, supplier, or destination organization; price variance and contract-leakage reporting using the _G and _T measure pairs; and free-text review of purchasing comments and notes. A representative query retrieving purchasing activity with comments for a given period is:

  • SELECT PO_NUMBER, RELEASE_NUM, ITEM_DESCRIPTION, QTY_ORDERED_B, AMT_PURCHASED_G, PO_COMMENTS FROM POA_EDW_PO_DIST_F_IV WHERE PO_CREATE_DATE_FK_KEY BETWEEN :from_key AND :to_key;
  • SELECT BUYER_FK_KEY, SUM(AMT_PURCHASED_G), SUM(AMT_LEAKAGE_G) FROM POA_EDW_PO_DIST_F_IV GROUP BY BUYER_FK_KEY;

Because the dimensional columns are surrogate FK_KEY values, such queries are normally joined to the corresponding POA dimension views to resolve buyer, supplier, and date descriptions. Access should be granted through the POA reporting responsibility, and the view should be treated as read-only ETL infrastructure rather than a transactional interface.