Search Results pon_bid_headers




The PON_BID_HEADERS table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical repository for storing header-level information related to supplier bids in the iSupplier Portal and Sourcing modules. This table serves as the foundation for managing the bidding process, capturing essential metadata about each bid submission, including bid identifiers, statuses, dates, and associated sourcing documents. Below is a detailed technical breakdown of its structure, purpose, and integration within Oracle EBS.

Table Purpose and Functional Context

The PON_BID_HEADERS table is part of Oracle's Sourcing and Procurement suite, specifically designed to support the reverse auction and bidding workflows. It stores header-level attributes of bids submitted by suppliers in response to RFQs (Request for Quotations), auctions, or other sourcing events. Key functionalities supported include bid lifecycle management, supplier collaboration, and integration with negotiation documents.

Key Columns and Data Structure

The table comprises columns that categorize bids and link them to related entities in Oracle EBS. Notable columns include:
  • BID_NUMBER: Unique identifier for the bid, often auto-generated by the system.
  • AUCTION_HEADER_ID: Foreign key linking to PON_AUCTION_HEADERS, associating the bid with a sourcing event.
  • SUPPLIER_ID: References PO_VENDORS, identifying the bidding supplier.
  • BID_STATUS: Tracks bid state (e.g., DRAFT, SUBMITTED, WITHDRAWN, AWARDED).
  • CREATION_DATE and LAST_UPDATE_DATE: Audit timestamps.
  • BID_CURRENCY_CODE: Currency used in the bid, linked to FND_CURRENCIES.
  • BID_RANK: Numerical rank assigned during bid evaluation.

Integration with Other Modules

The table integrates with several Oracle EBS components:
  • Sourcing (PON_AUCTION_HEADERS): Bids are tied to sourcing events via AUCTION_HEADER_ID.
  • iSupplier Portal: Suppliers submit bids through this interface, with data flowing into PON_BID_HEADERS.
  • Purchasing (PO_HEADERS): Awarded bids may generate purchase orders, creating a procurement trail.

Technical Considerations

  • Indexing: Indexes on BID_NUMBER, AUCTION_HEADER_ID, and SUPPLIER_ID optimize query performance.
  • Concurrency Control: Timestamp columns (LAST_UPDATE_DATE) enable optimistic locking during bid updates.
  • Data Integrity: Foreign key constraints enforce relationships with sourcing and supplier tables.

Customization and Extensions

In implementations, the table may be extended via descriptive flexfields (DFFs) to capture industry-specific bid attributes. Custom workflows or triggers might also leverage PON_BID_HEADERS to automate approvals or notifications.

Conclusion

The PON_BID_HEADERS table is a cornerstone of Oracle EBS Sourcing, enabling efficient bid management and supplier collaboration. Its design ensures traceability from bid submission to procurement, while integrations with other modules streamline end-to-end sourcing processes. Understanding its schema and relationships is essential for troubleshooting, reporting, or enhancing bidding workflows in Oracle EBS 12.1.1 or 12.2.2 environments.

  • 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_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_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_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 , 

  • 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 , 

  • 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.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_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_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.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 ,