Search Results pon_bid_headers




Overview
Explore in AI Chat

Overview

The PON_BID_HEADERS table is a core data object within the Oracle E-Business Suite Sourcing (PON) module, specifically for versions 12.1.1 and 12.2.2. It serves as the primary repository for header-level information pertaining to a supplier's response, or bid, to a negotiation (auction). Each record in this table represents a single, complete bid submission from a trading partner. Its fundamental role is to anchor the bid within the system, linking it to the parent negotiation, the supplier, and the supplier's contact, while also acting as the parent entity for all detailed line-level bid data. The integrity of the sourcing process is maintained through its defined primary and foreign key relationships, ensuring data consistency across the bid lifecycle from submission through award.

Key Information Stored

The table's structure is designed to capture the essential metadata of a bid. The primary key, BID_NUMBER, uniquely identifies each bid submission. Critical foreign key columns establish core relationships: AUCTION_HEADER_ID links the bid to its parent negotiation in PON_AUCTION_HEADERS_ALL, VENDOR_ID references the supplier from PO_VENDORS, and TRADING_PARTNER_CONTACT_ID ties to the specific contact person in HZ_PARTIES. Other significant columns typically include BID_STATUS to track the state of the bid (e.g., DRAFT, SUBMITTED, AWARDED), CREATION_DATE, LAST_UPDATE_DATE, and CREATED_BY for audit purposes. The table also stores overall bid attributes such as currency, payment terms, and scoring information that apply at the header level.

Common Use Cases and Queries

This table is central to reporting and process flows in Sourcing. Common use cases include generating bid participation reports for a specific auction, tracking the status of all bids from a particular supplier, and extracting data for bid analysis and award decisions. A typical query would join PON_BID_HEADERS with PON_AUCTION_HEADERS_ALL to list all bids for an auction, including supplier details. For example:

SELECT bh.BID_NUMBER, bh.BID_STATUS, v.VENDOR_NAME, ah.AUCTION_TITLE
FROM PON.PON_BID_HEADERS bh,
    PON.PON_AUCTION_HEADERS_ALL ah,
    PO.PO_VENDORS v
WHERE bh.AUCTION_HEADER_ID = ah.AUCTION_HEADER_ID
AND bh.VENDOR_ID = v.VENDOR_ID
AND ah.AUCTION_HEADER_ID = :p_auction_id;

Another common pattern is querying the table to find all awarded bids for a vendor to analyze historical performance.

Related Objects

PON_BID_HEADERS has extensive relationships within the Sourcing schema, acting as a parent table for numerous child entities that store bid details. As documented in the ETRM, key foreign key relationships include:

  • Table: PON_BID_HEADERS 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_HEADERS,  object_name:PON_BID_HEADERS,  status:VALID,  product: PON - Sourcing ,  description: Contains header level data for a response to a negotiation ,  implementation_dba_data: PON.PON_BID_HEADERS , 

  • Table: PON_BID_HEADERS 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_HEADERS,  object_name:PON_BID_HEADERS,  status:VALID,  product: PON - Sourcing ,  description: Contains header level data for a response to a negotiation ,  implementation_dba_data: PON.PON_BID_HEADERS , 

  • Table: PON_OPTIMIZE_BID_CLASS 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_OPTIMIZE_BID_CLASS,  object_name:PON_OPTIMIZE_BID_CLASS,  status:VALID,  product: PON - Sourcing ,  description: This table stores the suppliers for a particular constraint ,  implementation_dba_data: PON.PON_OPTIMIZE_BID_CLASS , 

  • Table: PON_OPTIMIZE_BID_CLASS 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_OPTIMIZE_BID_CLASS,  object_name:PON_OPTIMIZE_BID_CLASS,  status:VALID,  product: PON - Sourcing ,  description: This table stores the suppliers for a particular constraint ,  implementation_dba_data: PON.PON_OPTIMIZE_BID_CLASS , 

  • Table: PON_BID_REBATES 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_REBATES,  object_name:PON_BID_REBATES,  status:VALID,  product: PON - Sourcing ,  description: This table is used to store rebates for a particular bid ,  implementation_dba_data: PON.PON_BID_REBATES , 

  • Table: PON_BID_ITEM_PRICES 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_ITEM_PRICES,  object_name:PON_BID_ITEM_PRICES,  status:VALID,  product: PON - Sourcing ,  description: Contains the response details for an item in a negotiation ,  implementation_dba_data: PON.PON_BID_ITEM_PRICES , 

  • Table: PON_BID_PRICE_DIFFERENTIALS 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_PRICE_DIFFERENTIALS,  object_name:PON_BID_PRICE_DIFFERENTIALS,  status:VALID,  product: PON - Sourcing ,  description: Response price differentials table ,  implementation_dba_data: PON.PON_BID_PRICE_DIFFERENTIALS , 

  • Table: PON_OPTIMIZE_RESULTS 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_OPTIMIZE_RESULTS,  object_name:PON_OPTIMIZE_RESULTS,  status:VALID,  product: PON - Sourcing ,  description: This table stores information about the results of award optimization scenarios ,  implementation_dba_data: PON.PON_OPTIMIZE_RESULTS , 

  • Table: PON_BID_PRICE_DIFFERENTIALS 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_PRICE_DIFFERENTIALS,  object_name:PON_BID_PRICE_DIFFERENTIALS,  status:VALID,  product: PON - Sourcing ,  description: Response price differentials table ,  implementation_dba_data: PON.PON_BID_PRICE_DIFFERENTIALS , 

  • Table: PON_BID_PAYMENTS_INTERFACE 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_PAYMENTS_INTERFACE,  object_name:PON_BID_PAYMENTS_INTERFACE,  status:VALID,  product: PON - Sourcing ,  description: Interface table to store imported information of the payments that are defined on a response to a negotiation for complex services. ,  implementation_dba_data: PON.PON_BID_PAYMENTS_INTERFACE , 

  • Table: PON_BID_PAYMENTS_INTERFACE 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_PAYMENTS_INTERFACE,  object_name:PON_BID_PAYMENTS_INTERFACE,  status:VALID,  product: PON - Sourcing ,  description: Interface table to store imported information of the payments that are defined on a response to a negotiation for complex services. ,  implementation_dba_data: PON.PON_BID_PAYMENTS_INTERFACE , 

  • Table: PON_AWARD_ALLOCATIONS 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_AWARD_ALLOCATIONS,  object_name:PON_AWARD_ALLOCATIONS,  status:VALID,  product: PON - Sourcing ,  description: Contains the allocation of each awarded response to the backing requisitions for a particular negotiation line. ,  implementation_dba_data: PON.PON_AWARD_ALLOCATIONS , 

  • Table: PON_BID_REBATES 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_REBATES,  object_name:PON_BID_REBATES,  status:VALID,  product: PON - Sourcing ,  description: This table is used to store rebates for a particular bid ,  implementation_dba_data: PON.PON_BID_REBATES , 

  • Table: PON_BID_ITEM_PRICES 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_ITEM_PRICES,  object_name:PON_BID_ITEM_PRICES,  status:VALID,  product: PON - Sourcing ,  description: Contains information regarding the responses submitted by a supplier on a negotiation. ,  implementation_dba_data: PON.PON_BID_ITEM_PRICES , 

  • Table: PON_AWARD_ALLOCATIONS 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_AWARD_ALLOCATIONS,  object_name:PON_AWARD_ALLOCATIONS,  status:VALID,  product: PON - Sourcing ,  description: Contains the allocation of each awarded response to the backing requisitions for a particular negotiation line. ,  implementation_dba_data: PON.PON_AWARD_ALLOCATIONS , 

  • Table: PON_BID_SHIPMENTS 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_SHIPMENTS,  object_name:PON_BID_SHIPMENTS,  status:VALID,  product: PON - Sourcing ,  description: Contains the response details for an shipment in a negotiation ,  implementation_dba_data: PON.PON_BID_SHIPMENTS , 

  • Table: PON_TEAM_MEMBER_ATTR_SCORES 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_TEAM_MEMBER_ATTR_SCORES,  object_name:PON_TEAM_MEMBER_ATTR_SCORES,  status:VALID,  product: PON - Sourcing ,  description: This table records scores for every scoring team member for a given attribute and a response. ,  implementation_dba_data: PON.PON_TEAM_MEMBER_ATTR_SCORES , 

  • Table: PON_OPTIMIZE_RESULTS 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_OPTIMIZE_RESULTS,  object_name:PON_OPTIMIZE_RESULTS,  status:VALID,  product: PON - Sourcing ,  description: This table stores information about the results of award optimization scenarios ,  implementation_dba_data: PON.PON_OPTIMIZE_RESULTS , 

  • View: PON_SUPPLIER_MANAGE_DELIV_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PON.PON_SUPPLIER_MANAGE_DELIV_V,  object_name:PON_SUPPLIER_MANAGE_DELIV_V,  status:VALID,  product: PON - Sourcing ,  description: This is the view of active bids and their suppliers' user id. ,  implementation_dba_data: APPS.PON_SUPPLIER_MANAGE_DELIV_V , 

  • Table: PON_TEAM_MEMBER_BID_SCORES 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_TEAM_MEMBER_BID_SCORES,  object_name:PON_TEAM_MEMBER_BID_SCORES,  status:VALID,  product: PON - Sourcing ,  description: For negotiations enabled for team scoring, this table stores the evaluation for the responses on this negotiation for each team member. The table also records the date the response was scored and current score statusFor negotiations enabled ,  implementation_dba_data: PON.PON_TEAM_MEMBER_BID_SCORES , 

  • Table: PON_TEAM_MEMBER_ATTR_SCORES 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_TEAM_MEMBER_ATTR_SCORES,  object_name:PON_TEAM_MEMBER_ATTR_SCORES,  status:VALID,  product: PON - Sourcing ,  description: This table records scores for every scoring team member for a given attribute and a response. ,  implementation_dba_data: PON.PON_TEAM_MEMBER_ATTR_SCORES , 

  • View: PON_AUC_NOTIF_DELIV_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PON.PON_AUC_NOTIF_DELIV_V,  object_name:PON_AUC_NOTIF_DELIV_V,  status:VALID,  product: PON - Sourcing ,  description: This is the view used by contract team about active bids and the associated auction information. ,  implementation_dba_data: APPS.PON_AUC_NOTIF_DELIV_V , 

  • View: PON_AUC_NOTIF_DELIV_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PON.PON_AUC_NOTIF_DELIV_V,  object_name:PON_AUC_NOTIF_DELIV_V,  status:VALID,  product: PON - Sourcing ,  description: This is the view used by contract team about active bids and the associated auction information. ,  implementation_dba_data: APPS.PON_AUC_NOTIF_DELIV_V , 

  • View: PON_SUPPLIER_MANAGE_DELIV_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PON.PON_SUPPLIER_MANAGE_DELIV_V,  object_name:PON_SUPPLIER_MANAGE_DELIV_V,  status:VALID,  product: PON - Sourcing ,  description: This is the view of active bids and their suppliers' user id. ,  implementation_dba_data: APPS.PON_SUPPLIER_MANAGE_DELIV_V , 

  • Table: PON_BID_SHIPMENTS 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_SHIPMENTS,  object_name:PON_BID_SHIPMENTS,  status:VALID,  product: PON - Sourcing ,  description: Contains the response details for an shipment in a negotiation ,  implementation_dba_data: PON.PON_BID_SHIPMENTS , 

  • Table: PON_BID_PAYMENTS_SHIPMENTS 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_PAYMENTS_SHIPMENTS,  object_name:PON_BID_PAYMENTS_SHIPMENTS,  status:VALID,  product: PON - Sourcing ,  description: This contains the details of the payments that are defined on a response with complex services. This corresponds to the PON_AUC_PAYMENTS_SHIPMENTS table which defines payments on a negotiation. ,  implementation_dba_data: PON.PON_BID_PAYMENTS_SHIPMENTS , 

  • Table: PON_TEAM_MEMBER_BID_SCORES 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_TEAM_MEMBER_BID_SCORES,  object_name:PON_TEAM_MEMBER_BID_SCORES,  status:VALID,  product: PON - Sourcing ,  description: For negotiations enabled for team scoring, this table stores the evaluation for the responses on this negotiation for each team member. The table also records the date the response was scored and current score statusFor negotiations enabled ,  implementation_dba_data: PON.PON_TEAM_MEMBER_BID_SCORES , 

  • Table: PON_BID_PAYMENTS_SHIPMENTS 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_BID_PAYMENTS_SHIPMENTS,  object_name:PON_BID_PAYMENTS_SHIPMENTS,  status:VALID,  product: PON - Sourcing ,  description: This contains the details of the payments that are defined on a response with complex services. This corresponds to the PON_AUC_PAYMENTS_SHIPMENTS table which defines payments on a negotiation. ,  implementation_dba_data: PON.PON_BID_PAYMENTS_SHIPMENTS , 

  • View: PON_MI_AUC_RFQ_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PON.PON_MI_AUC_RFQ_V,  object_name:PON_MI_AUC_RFQ_V,  status:VALID,  product: PON - Sourcing ,  description: This view is used by the Buyer's Activity Summary report. It contains data for all Accepted Quotations. ,  implementation_dba_data: APPS.PON_MI_AUC_RFQ_V , 

  • View: PON_MI_AUC_BUYERAUC_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PON.PON_MI_AUC_BUYERAUC_V,  object_name:PON_MI_AUC_BUYERAUC_V,  status:VALID,  product: PON - Sourcing ,  description: This view is used by the Buyer's Activity Summary report. It contains data for all Awarded Auctions. ,  implementation_dba_data: APPS.PON_MI_AUC_BUYERAUC_V , 

  • Table: PON_AUCTION_HEADERS_ALL 12.1.1

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_AUCTION_HEADERS_ALL,  object_name:PON_AUCTION_HEADERS_ALL,  status:VALID,  product: PON - Sourcing ,  description: Stores the negotiations header level details. ,  implementation_dba_data: PON.PON_AUCTION_HEADERS_ALL , 

  • View: PON_MI_AUC_RFQ_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PON.PON_MI_AUC_RFQ_V,  object_name:PON_MI_AUC_RFQ_V,  status:VALID,  product: PON - Sourcing ,  description: This view is used by the Buyer's Activity Summary report. It contains data for all Accepted Quotations. ,  implementation_dba_data: APPS.PON_MI_AUC_RFQ_V , 

  • View: PON_MI_AUC_BUYERAUC_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PON.PON_MI_AUC_BUYERAUC_V,  object_name:PON_MI_AUC_BUYERAUC_V,  status:VALID,  product: PON - Sourcing ,  description: This view is used by the Buyer's Activity Summary report. It contains data for all Awarded Auctions. ,  implementation_dba_data: APPS.PON_MI_AUC_BUYERAUC_V , 

  • Table: PON_AUCTION_HEADERS_ALL 12.2.2

    owner:PON,  object_type:TABLE,  fnd_design_data:PON.PON_AUCTION_HEADERS_ALL,  object_name:PON_AUCTION_HEADERS_ALL,  status:VALID,  product: PON - Sourcing ,  description: Stores the negotiations header level details. ,  implementation_dba_data: PON.PON_AUCTION_HEADERS_ALL , 

  • View: PON_MI_AUC_SAVINGS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PON.PON_MI_AUC_SAVINGS_V,  object_name:PON_MI_AUC_SAVINGS_V,  status:VALID,  product: PON - Sourcing ,  description: This view is used by the Buyer Auction Savings report. It contains data for all Awarded Auctions summarized by Category. ,  implementation_dba_data: APPS.PON_MI_AUC_SAVINGS_V , 

  • View: PON_BUYER_MANAGE_DELIV_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PON.PON_BUYER_MANAGE_DELIV_V,  object_name:PON_BUYER_MANAGE_DELIV_V,  status:VALID,  product: PON - Sourcing ,  implementation_dba_data: APPS.PON_BUYER_MANAGE_DELIV_V , 

  • View: PON_BUYER_MANAGE_DELIV_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PON.PON_BUYER_MANAGE_DELIV_V,  object_name:PON_BUYER_MANAGE_DELIV_V,  status:VALID,  product: PON - Sourcing ,  implementation_dba_data: APPS.PON_BUYER_MANAGE_DELIV_V , 

  • View: PON_MI_AUC_SAVINGS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PON.PON_MI_AUC_SAVINGS_V,  object_name:PON_MI_AUC_SAVINGS_V,  status:VALID,  product: PON - Sourcing ,  description: This view is used by the Buyer Auction Savings report. It contains data for all Awarded Auctions summarized by Category. ,  implementation_dba_data: APPS.PON_MI_AUC_SAVINGS_V ,