Search Results qty_ontime_aftdue_b




Overview
Explore in AI Chat

Overview

The view POA_EDW_SUP_PERF_F_IV is a Purchasing Intelligence (POA) object within Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as a supplier performance fact view designed to expose transactional and summarized purchasing metrics to the Enterprise Data Warehouse (EDW) reporting layer. The suffix "F_IV" indicates that this is a fact-based informational view that surfaces supplier performance measures aggregated or recorded at the receipt, purchase order, and invoice level. Because it is categorized as a view rather than a base table, it is not implemented as a physical database object in the traditional sense; the ETRM metadata records it as "Not implemented in this database," confirming it exists as a reporting abstraction extracted from the EDW layer rather than a directly maintained transactional entity.

The view supports supplier scorecarding, on-time delivery analysis, price variance reporting, and quality measurement by exposing purchase quantities, receipt timing, invoice amounts, and price comparisons.

Underlying Base Objects

The documented ETRM metadata does not list any referenced base objects in the "Documented view metadata" section. However, the view text embedded in the object definition reveals its source explicitly: the SELECT statement derives all columns FROM POA_EDW_SUP_PERF_F. This indicates a direct, single-source dependency on the POA_EDW_SUP_PERF_F fact table.

The view acts as a projection over that base object, adding a literal placeholder column, ' ' OPERATION_CODE, and preserving the ROWID of the underlying table as ROW_ID. No joins to dimension tables are embedded in the view text; instead, foreign key surrogate columns (denoted by the _FK_KEY suffix) are exposed for downstream joining to EDW dimension objects such as date, buyer, item, supplier site, and currency dimensions.

Key Columns

The view exposes a broad set of measures and foreign keys. Notable columns include:

Common Use Cases and Queries

This view is typically queried to build supplier performance dashboards, on-time delivery reports, and contract compliance analyses. A common query filters on contract number to evaluate supplier delivery against a specific agreement:

  • Query by contract: SELECT contract_num, po_number, qty_ordered_b, qty_received_b, qty_ontime_ondue_b, qty_late_receipt_b FROM POA_EDW_SUP_PERF_F_IV WHERE contract_num = :contract_num;
  • On-time delivery summary by supplier site: aggregate NUM_ONTIME_ONDUE, NUM_LATE_RECEIPT, and NUM_RECEIPT_LINES grouped by SUPPLIER_SITE_FK_KEY.
  • Price variance analysis: select IPV_G_B, PRICE_G_B, LIST_PRICE_G_B, and TARGET_PRICE_G_B to measure negotiated versus actual pricing.
  • Cycle-time reporting: use NUM_DAYS_TO_INVOICE, DAYS_EARLY_REC, and DAYS_LATE_REC to assess process efficiency.

Because foreign keys are exposed as surrogates, queries are commonly joined to EDW date, item, buyer, and supplier dimensions to produce business-friendly labels alongside these measures.