Search Results pon_acceptances




Overview
Explore in AI Chat

Overview

The PON_ACCEPTANCES table is a core transactional data object within the Oracle E-Business Suite Sourcing (PON) module. It serves as the system of record for formally capturing and storing supplier acceptances of awarded lines during an online negotiation, such as a reverse auction or a request for quotation (RFQ). This table is fundamental to the sourcing award workflow, transitioning a negotiated response into a binding commitment. Its data is critical for generating purchase orders, tracking supplier performance, and maintaining a complete audit trail of the sourcing event lifecycle from solicitation through to award acceptance.

Key Information Stored

The table's primary function is to record the acceptance of a specific line item from a supplier's response. While a full column list is not provided in the excerpt, the documented foreign key relationships and primary key reveal its essential structure. The ACCEPTANCE_ID column serves as the unique primary key for each acceptance record. Each acceptance is intrinsically linked to a specific line in a specific negotiation via the composite foreign key columns AUCTION_HEADER_ID (identifying the sourcing event) and AUCTION_LINE_NUMBER (identifying the item within that event). Typical data stored would include identifiers for the accepting supplier, the accepted price and quantity, the acceptance date, and the user or interface that recorded the acceptance, providing a complete snapshot of the award agreement.

Common Use Cases and Queries

This table is central to post-award reporting and process automation. Common operational queries involve identifying all accepted lines for a given negotiation to proceed with purchase order generation, or checking the acceptance status of specific awarded lines. For reporting, it is used to analyze supplier acceptance rates and timelines. A typical SQL pattern joins PON_ACCEPTANCES to the PON_AUCTION_ITEM_PRICES_ALL table to retrieve the detailed price and item information for the accepted line.

SELECT paa.auction_header_id,
       paa.auction_line_number,
       paa.accepted_price,
       paa.accepted_quantity,
       paip.supplier_part_auxid
FROM pon_acceptances paa,
     pon_auction_item_prices_all paip
WHERE paa.auction_header_id = paip.auction_header_id
  AND paa.auction_line_number = paip.line_number
  AND paa.auction_header_id = :p_auction_id;

Related Objects

The PON_ACCEPTANCES table has a direct and documented foreign key relationship with the PON_AUCTION_ITEM_PRICES_ALL table. This relationship is defined on the composite key of (AUCTION_HEADER_ID, AUCTION_LINE_NUMBER). PON_AUCTION_ITEM_PRICES_ALL stores all the price lines submitted by suppliers during a negotiation. Therefore, each record in PON_ACCEPTANCES points to the specific awarded price line in PON_AUCTION_ITEM_PRICES_ALL that the supplier has accepted. This table is also a likely parent to other sourcing transactional tables and is accessed by standard Oracle APIs for award processing and downstream integration with the Purchasing (PO) module for purchase order creation.