Search Results pon_price_differentials




Overview
Explore in AI Chat

Overview

The PON_PRICE_DIFFERENTIALS table is a core data object within the Oracle E-Business Suite (EBS) Purchasing (PON) module, specifically supporting the Sourcing (eSourcing) functionality. It is designed to store price differentials defined within a negotiation (auction or RFQ). A price differential is a mechanism to adjust the base price of an item based on specific, predefined criteria associated with a bid line and its shipment schedule. This table is essential for enabling complex, multi-variable pricing models where the final cost can vary depending on factors like shipment location, quantity breaks, or other negotiated terms, allowing buyers to evaluate bids holistically.

Key Information Stored

The table's structure is intrinsically linked to the hierarchy of a negotiation document. Its primary key is a composite of four columns, precisely anchoring each differential record to a specific point in the negotiation: AUCTION_HEADER_ID (the negotiation identifier), LINE_NUMBER (the specific item line), SHIPMENT_NUMBER (the specific shipment schedule for that line), and PRICE_DIFFERENTIAL_NUMBER (a sequence identifying multiple differentials on the same shipment). While the provided metadata does not list all columns, typical data stored includes the differential type (e.g., fixed amount, percentage), the differential value, and the attribute or basis for the price adjustment (such as a particular shipping destination or quality rating). This granular storage allows the system to calculate a precise total adjusted price for each line shipment across all received bids.

Common Use Cases and Queries

The primary use case is the calculation and reporting of total evaluated bid prices during and after a sourcing event. Procurement analysts run queries to compare supplier bids after applying all relevant differentials. A common reporting pattern involves joining this table with the auction headers, item prices, and shipment tables. For example, to extract all differentials applied within a specific negotiation for analysis, one might use a query such as:

  • SELECT ppd.* FROM pon_price_differentials ppd JOIN pon_auction_headers_all pah ON ppd.auction_header_id = pah.auction_header_id WHERE pah.auction_header_id = <ID> ORDER BY ppd.line_number, ppd.shipment_number;

This data is critical for the system's built-in award recommendation and scenario analysis features, enabling buyers to model "what-if" scenarios by adjusting differential values.

Related Objects

As indicated by its foreign keys, PON_PRICE_DIFFERENTIALS has strong referential integrity with three primary negotiation tables. It is a child table of PON_AUCTION_HEADERS_ALL, which stores the negotiation header. It is also a child of PON_AUCTION_ITEM_PRICES_ALL, which holds the base price and line information, and PON_AUCTION_SHIPMENTS_ALL, which defines the shipment schedules. Any process or interface that creates or updates price differentials, such as the negotiation creation UI or the Open Interface API for Sourcing (PON_OPEN_INTERFACE_PVT), will ultimately populate this table. Reporting views and standard Sourcing reports will join to this table to present total evaluated price information.