Search Results pon_price_element_types




Overview
Explore in AI Chat

Overview

The PON_PRICE_ELEMENT_TYPES table is a core reference table within the Oracle E-Business Suite Sourcing (PON) module. It functions as a master repository for defining the different categories or classifications of price elements that can be applied to sourcing documents, such as purchase agreements, RFQs, and auctions. Its primary role is to enforce data integrity and provide a controlled list of valid price element types, which are then referenced by transactional tables. This structure is fundamental to the flexible pricing models in Oracle Sourcing, enabling buyers to define complex cost structures beyond a simple unit price.

Key Information Stored

The table's central column is PRICE_ELEMENT_TYPE_ID, which serves as the unique identifier (primary key) for each price element type definition. While the provided ETRM metadata does not list all columns, the table's relationship to its translation table, PON_PRICE_ELEMENT_TYPES_TL, indicates that descriptive name and language information are stored separately to support multilingual implementations. The core table likely contains control columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY, standard in Oracle EBS. It may also include flags or columns to indicate the element's behavior, such as whether it is a charge or a discount, and its applicability to different document types.

Common Use Cases and Queries

This table is primarily used for setup, validation, and reporting. Administrators use it to maintain the list of available price element types during application configuration. Common operational queries involve joining this table to transactional data to generate detailed price breakdown reports. A typical reporting query would join PON_PRICE_ELEMENT_TYPES to the PON_PRICE_ELEMENTS table to retrieve all cost components for a specific sourcing document.

  • Sample Query: To list all price element types and their associated elements for a specific negotiation (header_id = 1000):
    SELECT pet.price_element_type_id, pe.price_element_name, pe.amount
    FROM pon_price_element_types pet, pon_price_elements pe
    WHERE pet.price_element_type_id = pe.price_element_type_id
    AND pe.auction_header_id = 1000;
  • Use Case: Validating that a price element being entered on a document references a valid, active type from this master table.

Related Objects

The PON_PRICE_ELEMENT_TYPES table has direct relationships with several key Sourcing module objects, as indicated by its foreign keys.

  • PON_PRICE_ELEMENTS: This is the primary transactional child table. It stores the actual price element instances (e.g., "Freight Charge: $500") applied to specific sourcing documents, each linked back to a type defined in PON_PRICE_ELEMENT_TYPES via PRICE_ELEMENT_TYPE_ID.
  • PON_PRICE_ELEMENT_TYPES_TL: The translation table that stores the language-specific names and descriptions for each PRICE_ELEMENT_TYPE_ID, enabling multilingual deployments of Oracle EBS.
  • The table is integral to the pricing engine within the Sourcing module, and its definitions are likely referenced by underlying PL/SQL APIs and public interfaces that create or update price elements on documents.