Search Results pon_pf_supplier_formula




Overview
Explore in AI Chat

Overview

PON_PF_SUPPLIER_FORMULA is a table in the PON (Sourcing) schema of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. Its documented purpose is to store aggregated price factor values for a given supplier within the context of an auction. The "PF" prefix denotes Price Factors, the Sourcing feature that allows buyers to apply structured cost adjustments — fixed amounts, percentage markups or discounts, and unit price overrides — to supplier responses. Where individual supplier line-level responses are captured elsewhere, PON_PF_SUPPLIER_FORMULA holds the rolled-up or formula-derived price factor result per supplier, per auction, per line.

From a Data Vault modeling perspective, the metadata's heuristic classification is standalone. This suggests the table can be modeled as an independent structure rather than a strict hub, link, or satellite. While it does carry a foreign key to the auction header, it is not positioned as a pure intersection or dependent child in the mined relationship graph, so treating it as a self-contained fact-like entity is a reasonable modeling suggestion.

Key Information Stored

The table contains 13 documented columns. The most significant are:

  • AUCTION_HEADER_ID — Identifies the auction to which the supplier formula belongs. This is the only documented foreign key, referencing PON_AUCTION_HEADERS_ALL.
  • LINE_NUMBER — The auction line the formula applies to, enabling line-level granularity within a single auction.
  • TRADING_PARTNER_ID — The supplier (trading partner) whose aggregated price factor is stored.
  • REQUESTED_SUPPLIER_ID — Distinguishes the supplier who was invited or requested from the trading partner recorded, useful in multi-round or reassignment scenarios.
  • VENDOR_SITE_ID — The specific supplier site, allowing site-level differentiation of price factors.
  • UNIT_PRICE — The unit price component of the formula.
  • FIXED_AMOUNT — A flat monetary adjustment applied in the formula.
  • PERCENTAGE — A percentage-based adjustment (markup or discount) applied to the supplier's price.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking who created and last modified each row and when.

No surrogate primary key or unique business-key index is documented in the provided metadata. In practice, the natural business key is the combination of AUCTION_HEADER_ID, LINE_NUMBER, TRADING_PARTNER_ID, and VENDOR_SITE_ID, which together identify a unique supplier-formula record per auction line.

Common Use Cases and Queries

Typical uses include auditing how price factors were aggregated per supplier during an auction, reconciling supplier-quoted prices against formula-adjusted prices, and building sourcing reports that compare fixed-amount versus percentage adjustments across bidders.

A representative query joins the formula to the auction header to retrieve auction context:

  • SELECT f.auction_header_id, f.line_number, f.trading_partner_id, f.unit_price, f.fixed_amount, f.percentage FROM pon.pon_pf_supplier_formula f WHERE f.auction_header_id = :auction_id;
  • Aggregate reporting by supplier: SELECT trading_partner_id, SUM(fixed_amount) total_fixed, AVG(percentage) avg_pct FROM pon.pon_pf_supplier_formula GROUP BY trading_partner_id;
  • Audit trending on last-updated rows to detect late formula changes before award.

Related Objects

The principal related objects, grounded in the documented FK and the PON Sourcing data model, are:

These joins support end-to-end tracing from auction setup through supplier formula aggregation to final award analysis.