Search Results pon_price_elements




Overview
Explore in AI Chat

Overview

The PON_PRICE_ELEMENTS table is a core data structure within the Oracle E-Business Suite (EBS) Purchasing (PON) Sourcing module. It functions as the transactional repository for all price element details associated with lines in a sourcing document, such as a Request for Quotation (RFQ) or a reverse auction. Its primary role is to enable the complex pricing models that go beyond simple unit prices, allowing buyers to define and suppliers to respond with cost components like freight, taxes, discounts, or custom surcharges. This table is essential for capturing the full, decomposed cost of an item or service during the sourcing event and for subsequent award and purchase order creation.

Key Information Stored

The table's structure is designed to link price elements to specific lines within a sourcing header. Its composite primary key, PON_PRICE_ELEMENTS_U1, consists of AUCTION_HEADER_ID, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, and LIST_ID. This uniquely identifies a price element instance. Key columns include AUCTION_HEADER_ID, which links to the parent sourcing event (PON_AUCTION_HEADERS), and LINE_NUMBER, which links to the specific item line (PON_AUCTION_ITEM_PRICES_ALL). The PRICE_ELEMENT_TYPE_ID is a foreign key to PON_PRICE_ELEMENT_TYPES, defining the element's nature (e.g., 'FREIGHT', 'TAX'). The LIST_ID foreign key references PON_PRICE_ELEMENT_LISTS or PON_AUCTION_TEMPLATES, connecting the element to a predefined list or template. Other critical columns typically store the element's value, sequence for display, and whether it is mandatory or modifiable by the supplier.

Common Use Cases and Queries

This table is central to pricing analysis and reporting within Sourcing. A common use case is generating a detailed cost breakdown for an auction line item to compare supplier quotes beyond the base price. For example, a report summarizing all price elements for a specific auction would join to related descriptive tables. Sample SQL to retrieve price element details for an auction might resemble:

  • SELECT pe.line_number, pet.display_name, pe.value
  • FROM pon_price_elements pe,
  • pon_price_element_types pet
  • WHERE pe.auction_header_id = :p_auction_id
  • AND pe.price_element_type_id = pet.price_element_type_id
  • ORDER BY pe.line_number, pe.sequence_num;

Another critical scenario is data validation or migration, where scripts might query this table to ensure all mandatory price elements for awarded lines are populated before integrating data with downstream purchasing or financial systems.

Related Objects

PON_PRICE_ELEMENTS has integral relationships with several key Sourcing tables, as defined by its foreign keys. It is a child table of PON_AUCTION_ITEM_PRICES_ALL, which holds the main line item information. The definition of each price element type is stored in PON_PRICE_ELEMENT_TYPES. The element's membership in a reusable grouping is managed via PON_PRICE_ELEMENT_LISTS. The table also relates to PON_AUCTION_TEMPLATES, allowing price element lists to be part of sourcing templates. For comprehensive reporting, views such as PON_AUCTION_PRICE_ELEMENTS_V may provide easier access to joined data. Business logic for creating and validating price elements is typically encapsulated within PL/SQL packages in the PON schema.