Search Results pon_bid_item_prices_pk

Overview

The PON_BID_ITEM_PRICES table is a core transactional data object within the Oracle E-Business Suite Sourcing module (PON). It serves as the primary repository for storing detailed pricing and quantity responses submitted by suppliers during a negotiation event, such as a reverse auction or a request for quotation (RFQ). Each record in this table represents a specific line item bid from a supplier, linking the supplier's response (BID_NUMBER) to the original auction line item (AUCTION_LINE_NUMBER, AUCTION_HEADER_ID). Its role is critical for capturing the competitive bidding data that drives the award and procurement processes in Oracle Sourcing.

Key Information Stored

The table's structure is designed to capture the supplier's proposed terms for each line item. The primary key is a composite of AUCTION_LINE_NUMBER and BID_NUMBER, ensuring uniqueness for each bid per line. Essential columns include BID_NUMBER, which links to the supplier's overall bid header in PON_BID_HEADERS, and AUCTION_HEADER_ID paired with LINE_NUMBER (or AUCTION_LINE_NUMBER), which link to the original solicitation line in PON_AUCTION_ITEM_PRICES_ALL. Other significant columns typically store the bid unit price (PRICE), bid quantity (BID_QUANTITY), and extended price. The table also frequently contains columns for tracking discounts, payment terms, and other line-level attributes offered by the supplier.

Common Use Cases and Queries

This table is central to analysis, reporting, and award creation. A common use case is evaluating all bids for a specific negotiation to determine the lowest responsive bidder per line. For reporting, it is frequently joined to supplier and item tables to create detailed bid comparison reports. Administrators may query it to audit supplier responses or troubleshoot award issues. A fundamental SQL pattern retrieves all line item bids for a specific auction:

• SELECT bip.bid_number, bip.auction_line_number, bip.price, bh.trading_partner_name FROM pon_bid_item_prices bip, pon_bid_headers bh WHERE bip.auction_header_id = :p_auction_id AND bip.bid_number = bh.bid_number ORDER BY bip.auction_line_number, bip.price;

Another critical use case is the population of the award staging table (PON_AWARD_ITEMS_INTERFACE) from this table during the award creation process.

Related Objects

PON_BID_ITEM_PRICES maintains key foreign key relationships with other central Sourcing tables, as documented in the ETRM metadata:

• PON_BID_HEADERS: Joined via BID_NUMBER. This relationship connects the line item details to the overarching supplier bid submission, including supplier and bid status information.
• PON_AUCTION_ITEM_PRICES_ALL: Joined via AUCTION_HEADER_ID and LINE_NUMBER/AUCTION_LINE_NUMBER. This links the supplier's response back to the original solicitation line item definition.
• PON_AWARD_ITEMS_INTERFACE: The award process references this table using AUCTION_LINE_NUMBER and BID_NUMBER to source the supplier and price data for creating purchase orders.

The table's primary key constraint is PON_BID_ITEM_PRICES_PK. These relationships solidify its position as the central hub for line-level bid data between the solicitation (auction), response (bid), and outcome (award) phases.