Search Results pon_fpk_deleted_price_elements




Overview
Explore in AI Chat

Overview

PON_FPK_DELETED_PRICE_ELEMENTS is a table owned by the PON schema within the Oracle E-Business Suite Sourcing module. Its documented purpose is to store information about deleted unit price elements associated with FPK (Flexible Price Components) constructs in the Sourcing application. In practical terms, whenever a buyer or an automated sourcing process removes a unit price element from an auction pricing structure, the pre-deletion record is captured here rather than being physically discarded, providing a persistent audit trail of pricing changes across the negotiation lifecycle.

From a dimensional modeling perspective, the metadata's heuristic Data Vault classification identifies this object as standalone. This suggests that the table functions primarily as a standalone satellite-like store rather than a true hub or link, since it captures transactional change history (deletion events) keyed to an auction context rather than representing an integration point between multiple business entities. Modelers should treat it as an event/history satellite for pricing element deletions rather than a core master-data hub.

Key Information Stored

The documented physical schema contains six columns. The most significant are:

  • AUCTION_HEADER_ID — Identifies the sourcing auction (negotiation) to which the deleted price element belonged; this is a foreign key into PON_AUCTION_HEADERS_ALL and is the primary business join key.
  • LINE_NUMBER — The auction line number against which the price element was originally applied, allowing reconstruction of the line-level pricing context at the time of deletion.
  • PRICE_ELEMENT_TYPE_ID — References PON_PRICE_ELEMENT_TYPES and identifies the specific kind of unit price element that was deleted (for example, a discount, surcharge, or conversion charge component).
  • PRICING_BASIS — Records the basis upon which the deleted element's value was calculated or applied.
  • VALUE — The numeric value attributed to the deleted price element prior to its removal.
  • DISPLAY_TARGET_FLAG — Indicates whether the element was flagged for display to targeted suppliers or intended as a target/display attribute.

The metadata does not document an explicit surrogate primary key column or named unique index; consequently, the composite of AUCTION_HEADER_ID, LINE_NUMBER, and PRICE_ELEMENT_TYPE_ID acts as the practical business-key candidate for uniquely identifying a deleted price element. No single-column surrogate key is evident from the ETRM schema.

Common Use Cases and Queries

Because this table is a deletion audit store, its principal use cases center on change analysis, dispute investigation, and pricing integrity reporting.

  • Audit of pricing removals: Retrieve all price elements deleted for a given auction to determine what pricing components were stripped and when.
  • Reconstruction of final pricing: Compare current live price elements against those recorded here to explain net price deltas.
  • Supplier dispute resolution: Provide evidence of price element values that existed before deletion.

A representative query pattern joins the deletion table to its parent auction and price element type lookup:

SELECT d.AUCTION_HEADER_ID,
       d.LINE_NUMBER,
       t.TYPE_NAME,
       d.VALUE,
       d.PRICING_BASIS
FROM   PON.PON_FPK_DELETED_PRICE_ELEMENTS d,
       PON.PON_PRICE_ELEMENT_TYPES t
WHERE  d.PRICE_ELEMENT_TYPE_ID = t.PRICE_ELEMENT_TYPE_ID
AND    d.AUCTION_HEADER_ID    = :auction_header_id;

Reporting use cases typically aggregate deletion counts by auction header or by price element type to surface negotiations with unusually volatile pricing structures.

Related Objects

  • PON_AUCTION_HEADERS_ALL — Parent auction header table; join via AUCTION_HEADER_ID.
  • PON_PRICE_ELEMENT_TYPES — Lookup defining valid price element categories; join via PRICE_ELEMENT_TYPE_ID.
  • PON_AUCTION_LINES_ALL — Auction line detail; correlates through AUCTION_HEADER_ID and LINE_NUMBER.
  • PON_PRICE_ELEMENTS (and related FPK pricing element tables) — Holds live, non-deleted price elements for comparison.
  • PON_FPK_* tables — Companion FPK structures sharing the same auction and price element dimensions.

Together these objects form the FPK pricing component ecosystem, in which PON_FPK_DELETED_PRICE_ELEMENTS serves as the historical deletion record complementing the live pricing tables.