Search Results purch_class_fk




Overview
Explore in AI Chat

Overview

The view POA_EDW_SUPPLIER_PERFORM_FCV is a Purchasing (PO) module object delivered as part of the Oracle E-Business Suite Enterprise Data Warehouse (EDW) content. It presents a flattened, denormalized record set describing supplier performance — pricing, quantities, receipt timeliness, and invoicing metrics — associated with purchasing documents such as purchase orders, contracts, and releases. As the "FCV" suffix (flex column view / fact collection view) implies, the object is designed to feed an Oracle Business Intelligence / EDW fact table load, exposing foreign key surrogate columns alongside additive and semi-additive measures.

In the ETRM metadata for release 12.2.2, the view is documented as not implemented in this database. Its column list and view text are therefore reproduced from the underlying definition rather than instantiated at runtime. This is typical of EDW collector objects that exist as installable templates but are only materialized in environments where the corresponding warehouse collection is configured.

Underlying Base Objects

The ETRM metadata documents no referenced base objects for the view in this database. The embedded view text states the source explicitly:

  • FROM POABV_EDW_SUPPLIER_PERFORM_FCV — the underlying Business View (BV) layer object that supplies all rows and columns. POA_EDW_SUPPLIER_PERFORM_FCV performs no additional joins, filters, or aggregation; it is a straight projection that renames and reshapes columns into the EDW fact convention (foreign keys, "_FK" dimensions, "_T"/"_G" transactional and global measures, "_B" base quantities).
  • The POABV_ prefix indicates an internal EDW-supplied wrapper over Purchasing base tables such as PO_HEADERS_ALL, PO_LINES_ALL, PO_DISTRIBUTIONS_ALL, RCV_SHIPMENT_LINES, and AP invoice distributions, though these are not enumerated in the ETRM record.

Because the dependency chain is undocumented in this release, DBAs should treat POABV_EDW_SUPPLIER_PERFORM_FCV as the authoritative upstream object to validate before relying on this view.

Key Columns

The projection exposes three broad groups. Identity and foreign-key columns include SEQ_ID, VIEW_ID, SUP_PERF_PK, SUPPLIER_ITEM_FK, SUPPLIER_SITE_FK, SHIP_TO_ORG_FK, ITEM_FK, BUYER_FK, and the classification keys PURCH_CLASS_FK, DUNS_FK, and UNSPSC_FK. The UNSPSC_FK column — the term the user searched — surfaces the United Nations Standard Products and Services Code dimension key, enabling supplier spend and performance analysis by commodity classification. Additional hierarchy keys include SIC_CODE_FK, AP_TERMS_FK, PRICE_TYPE_FK, and PO_LINE_TYPE_FK.

Date foreign keys (INVOICE_DATE_FK, PROMISED_DATE_FK, NEED_BY_DATE_FK, FIRST_REC_DATE_FK, LST_ACCPT_DATE_FK, APPROVAL_DATE_FK, and others) conform to the EDW DATE_DIM.

Measure columns include currency and unit-price values (IPV_T, PRICE_T, MARKET_PRICE_T, LIST_PRICE_T, TARGET_PRICE_T), amounts (AMT_PURCHASED_T/_G), and quantity and timeliness metrics such as QTY_ORDERED_B, QTY_RECEIVED_B, QTY_REJECTED_B, NUM_ONTIME_ONDUE, DAYS_EARLY_REC, DAYS_LATE_REC, and NUM_DAYS_TO_INVOICE. The descriptor columns PO_NUMBER, CONTRACT_NUM, and RELEASE_NUM provide human-readable document references.

Common Use Cases and Queries

Typical uses include supplier scorecarding, on-time delivery analysis, price-variance reporting, and EDW fact extraction. A sample query keying on the searched column:

  • SELECT sup_perf_pk, po_number, unspsc_fk, amt_purchased_t, qty_ordered_b, qty_received_b, num_ontime_ondue, days_late_rec FROM poa_edw_supplier_perform_fcv WHERE unspsc_fk IS NOT NULL;
  • Supplier timeliness: SELECT supplier_site_fk, SUM(num_ontime_ondue), SUM(num_late_receipt), SUM(qty_received_b) FROM poa_edw_supplier_perform_fcv GROUP BY supplier_site_fk;
  • Commodity spend: aggregate amt_purchased_t grouped by unspsc_fk and purch_class_fk.

Because the object is marked not implemented, queries should first confirm existence via ALL_VIEWS and verify that the upstream POABV_EDW_SUPPLIER_PERFORM_FCV is present in the target 12.1.1 or 12.2.2 instance.