Search Results pon_bidders_lists




Overview
Explore in AI Chat

Overview

The PON_BIDDERS_LISTS table is a core data object within the Oracle E-Business Suite (EBS) Sourcing (PON) module. It functions as the master repository for the header-level information of invitation lists. In the context of strategic sourcing and supplier negotiations, an invitation list defines the set of suppliers (bidders) who are formally invited to participate in a sourcing event, such as a Request for Quotation (RFQ) or an auction. This table serves as the primary record for each distinct list, establishing a foundation for managing supplier engagements and tracking participation across the sourcing lifecycle.

Key Information Stored

The table's primary key, LIST_HEADER_ID, uniquely identifies each invitation list. Two critical foreign key relationships define the core entities associated with the list. The TRADING_PARTNER_ID column references HZ_PARTIES to link the list to the specific supplier organization. The TRADING_PARTNER_CONTACT_ID column, also referencing HZ_PARTIES, identifies the primary contact person at that supplier. While the provided metadata does not enumerate all columns, typical data stored at this header level would include creation dates, last update information, list status, and potentially a name or description for the list itself. The structure ensures a clear linkage between a sourcing event's invitation and the Trading Community Architecture (TCA) registry of trading partners.

Common Use Cases and Queries

This table is central to reporting and auditing which suppliers were invited to specific sourcing events. A common operational query involves joining this table with sourcing header tables to generate a master list of all invitations issued. For example, to analyze invitation patterns for a particular supplier, one might query:

  • SELECT pha.auction_header_id, pbl.list_header_id, pbl.creation_date FROM pon_auction_headers_all pha, pon_bidders_lists pbl WHERE pha.list_header_id = pbl.list_header_id AND pbl.trading_partner_id = &supplier_party_id;

Data from this table is also essential for compliance reporting, demonstrating a fair and open bidding process by providing an audit trail of invited suppliers. Furthermore, it supports the user interface where buyers manage and view the bidders associated with an RFQ or auction.

Related Objects

The PON_BIDDERS_LISTS table has defined relationships with several other key EBS objects. As documented, it holds a direct foreign key relationship to HZ_PARTIES (twice) for both the supplier organization and contact. Crucially, it is referenced by the PON_BIDDING_PARTIES table via the LIST_ID foreign key. Where PON_BIDDERS_LISTS stores header-level data for the invitation list, PON_BIDDING_PARTIES typically stores detailed, line-level information about each bidder's participation, such as responses to specific line items. In application logic, sourcing documents (e.g., PON_AUCTION_HEADERS_ALL) will often contain a LIST_HEADER_ID column to link the event to its master invitation list, forming a complete data model for the sourcing invitation process.