Search Results pon_pricing_basis

Overview

PON.PON_PRICE_ELEMENTS is a transactional table in the Oracle E-Business Suite sourcing schema (PON) that stores the detailed price element definitions associated with auctions and RFQs. Each row captures a single price element — a cost factor, adjustment, or pricing component — applied to a specific auction line or to a reusable price element list. The table is populated during sourcing document authoring in Oracle Sourcing and is referenced throughout the negotiation lifecycle, from buyer setup through supplier response and final award analysis.

From a Data Vault modeling perspective, the metadata's heuristic classification identifies this object as a link. This is consistent with its structure: PON_PRICE_ELEMENTS resolves relationships between sourcing documents (auction headers, lines), price element type definitions, and price element lists, rather than serving as a standalone hub of business entities. It carries descriptive and target-value attributes alongside its foreign key relationships, giving it limited satellite-like characteristics, but the dominant modeling role is connective.

Key Information Stored

The table's unique primary key is PON_PRICE_ELEMENTS_U1, defined across AUCTION_HEADER_ID, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, and LIST_ID. This composite key reflects the need to distinguish price elements that may apply at line level, list level, or both. The most significant columns include:

• AUCTION_HEADER_ID — The sourcing document identifier; the primary anchor for all rows.
• LINE_NUMBER — The auction line to which the price element applies.
• LIST_ID — Populated for list-level element rows, linking to reusable price element lists.
• PRICE_ELEMENT_TYPE_ID — Foreign key to PON_PRICE_ELEMENT_TYPES, defining the nature of the element.
• PRICING_BASIS — Drives how the element value is interpreted. Valid values come from the PON_PRICING_BASIS lookup: PER_UNIT, FIXED_AMOUNT, and PERCENTAGE.
• VALUE — The target value of the price element.
• DISPLAY_TARGET_FLAG — Controls whether the target value is visible to suppliers.
• SEQUENCE_NUMBER — Determines the order in which elements are applied or displayed.
• PF_TYPE — Indicates whether the price factor is buyer-defined or supplier-entered.
• DISPLAY_TO_SUPPLIERS_FLAG — Governs visibility of buyer price factors to suppliers.
• NEGATIVE_COST_FACTOR_FLAG — Flags cost factors that reduce rather than add to price.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID — Concurrent program audit columns.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — Standard Who audit columns.

Business-key candidates are effectively the primary key columns, since no separate unique index beyond PON_PRICE_ELEMENTS_U1 is documented. Two non-unique indexes support access paths: PON_PRICE_ELEMENTS_N1 on AUCTION_HEADER_ID, LINE_NUMBER, and PRICE_ELEMENT_TYPE_ID; and PON_PRICE_ELEMENTS_N2 on LIST_ID and PRICE_ELEMENT_TYPE_ID.

Common Use Cases and Queries

Typical reporting scenarios include extracting all price elements for a sourcing document, comparing target values against supplier responses, and auditing visibility settings. A basic query retrieves buyer-defined elements for a given auction:

• SELECT line_number, price_element_type_id, pricing_basis, value, pf_type FROM pon_price_elements WHERE auction_header_id = :p_auction_id ORDER BY line_number, sequence_number;
• Filter by pricing_basis to isolate percentage-based versus per-unit adjustments.
• Use display_to_suppliers_flag = 'Y' to audit which cost factors are externally visible.
• Join to PON_PRICE_ELEMENT_TYPES to resolve element names for reporting.
• Join to PON_AUCTION_TEMPLATES via LIST_ID to trace template-driven pricing structures.

Because the table sits between document headers and element type definitions, it is frequently used in sourcing analytics, cost breakdown reports, and award-scoring extracts.

Related Objects

The following objects are most significant in relation to PON_PRICE_ELEMENTS:

• PON.PON_PRICE_ELEMENT_TYPES — Referenced via PRICE_ELEMENT_TYPE_ID; defines element semantics.
• PON.PON_PRICE_ELEMENT_LISTS — Referenced via LIST_ID; holds reusable element groupings.
• PON.PON_AUCTION_TEMPLATES — Also referenced via LIST_ID; templates that seed price elements.
• PON.PON_AUCTION_ITEM_PRICES_ALL — Linked via LINE_NUMBER; stores line-level pricing details.
• PON.PON_AUCTIONS_ALL / PON_AUCTION_HEADERS_ALL — Parent sourcing documents keyed by AUCTION_HEADER_ID.
• FND Lookups (PON_PRICING_BASIS) — Validates the PRICING_BASIS column values.