Search Results pon_large_neg_pf_values




Overview
Explore in AI Chat

Overview

PON_LARGE_NEG_PF_VALUES is a transactional table in the PON (Sourcing) product family of Oracle E-Business Suite, owned by the PON schema. It stores the buyer price factor values applied to a given supplier within a large negotiation — typically a sourcing event or auction with a high volume of supplier line items. In Oracle Sourcing, price factors allow a buyer to normalize, weight, or adjust quoted prices so that offers with differing commercial terms can be compared on a common basis. For large negotiations, where the volume of supplier price factor combinations exceeds what the standard negotiation tables are sized to handle efficiently, Oracle segregates this data into a dedicated table so that buyers can define, retrieve, and score supplier responses without degrading the performance of core auction processing.

From a dimensional modeling perspective, the mined foreign-key structure classifies this object heuristically as a standalone construct rather than a classic hub, link, or satellite. The absence of an intersecting bridge relationship suggests it functions as an independent extension table keyed to negotiation and price element context; modelers may treat it as a satellite-like detail store hanging off the negotiation header if a Data Vault layer is being constructed.

Key Information Stored

The table contains 10 documented columns in the 12.2.2 physical schema, and the following are the most significant:

No dedicated surrogate primary key column is exposed in the documented metadata; the natural composite of negotiation header, supplier sequence, and price element type serves as the effective identifier.

Common Use Cases and Queries

Typical scenarios include validating that price factors were captured for every invited supplier in a large negotiation, reproducing buyer-adjusted scores, and auditing changes to price factor values across a sourcing cycle. A representative query joins the table to its parent negotiation header:

  • SELECT pf.AUCTION_HEADER_ID, pf.SUPPLIER_SEQ_NUMBER, pf.PRICE_ELEMENT_TYPE_ID, pf.PRICING_BASIS, pf.VALUE FROM PON.PON_LARGE_NEG_PF_VALUES pf WHERE pf.AUCTION_HEADER_ID = :auction_header_id ORDER BY pf.SUPPLIER_SEQ_NUMBER;
  • Joining to PON_PRICE_ELEMENT_TYPES to resolve the human-readable price element name for reporting.
  • Aggregating values by PRICING_BASIS to compare fixed versus percentage adjustments across suppliers.
  • Auditing recent changes using LAST_UPDATE_DATE and LAST_UPDATED_BY for compliance reporting.

Related Objects

  • PON_AUCTION_HEADERS_ALL — Parent negotiation; joined on AUCTION_HEADER_ID.
  • PON_PRICE_ELEMENT_TYPES — Defines the price factor; joined on PRICE_ELEMENT_TYPE_ID.
  • PON_AUCTION_HEADERS / negotiation summary views — commonly joined for header-level reporting.
  • PON_AUCTION_SUPPLIERS — Supplier participation context aligned to SUPPLIER_SEQ_NUMBER.
  • PON_BID_HEADERS and related bid tables — used when reconciling buyer price factors against supplier responses.