Search Results pon_auction_headers_all
Overview
The PON_AUCTION_HEADERS_ALL table is the central repository for header-level information for all negotiations within Oracle E-Business Suite Sourcing (PON). It serves as the master record for each sourcing event, such as a Request for Quotation (RFQ) or Reverse Auction, storing the defining attributes and metadata that govern the entire negotiation lifecycle. As a multi-org enabled table, the `ALL` suffix indicates it contains data for all operating units, making it the primary table for enterprise-wide reporting and integration. Its primary key, AUCTION_HEADER_ID, is the fundamental identifier propagated to numerous related transactional tables, establishing the core data model for the Sourcing module.
Key Information Stored
The table's columns capture the comprehensive business context of a negotiation. The primary identifier is AUCTION_HEADER_ID. Critical business columns include AUCTION_TITLE, DOCTYPE_ID (linking to PON_AUC_DOCTYPES), and the CURRENCY_CODE. It stores key participant information via BUYER_ID (linked to FND_USER) and TRADING_PARTNER_ID (linked to HZ_PARTIES). The table also holds negotiation rules and dates, such as BID_VISIBILITY_CODE, BID_OPENING_DATE, and CLOSE_DATE. Financial and logistical details are recorded through PROJECT_ID (linked to PA_PROJECTS_ALL), BILL_TO_LOCATION_ID, SHIP_TO_LOCATION_ID, and RATE_TYPE (linked to GL_DAILY_CONVERSION_TYPES). The EVENT_ID column links to the PON_AUCTION_EVENTS table for workflow tracking.
Common Use Cases and Queries
This table is essential for operational reporting, audit trails, and data extracts. Common analytical queries involve summarizing negotiation activity by buyer, trading partner, or date range. A typical report to list active negotiations would join to related lookup tables:
SELECT pah.AUCTION_TITLE, pah.AUCTION_HEADER_ID, fu.USER_NAME AS BUYER, hp.PARTY_NAME AS SUPPLIER, pah.CREATION_DATE, pah.CLOSE_DATE FROM PON_AUCTION_HEADERS_ALL pah, FND_USER fu, HZ_PARTIES hp WHERE pah.BUYER_ID = fu.USER_ID AND pah.TRADING_PARTNER_ID = hp.PARTY_ID AND pah.CLOSE_DATE > SYSDATE;
Technical integrations often query this table to retrieve the header context before processing related lines, shipments, or bids. It is also central for deriving the status and lifecycle phase of a sourcing event for dashboard metrics.
Related Objects
As the cornerstone table, PON_AUCTION_HEADERS_ALL has extensive relationships. Its primary key, AUCTION_HEADER_ID, is referenced as a foreign key by nearly all major Sourcing transactional tables, including:
- PON_BID_HEADERS and PON_BIDDING_PARTIES for supplier bid data.
- PON_AUCTION_ITEM_PRICES_ALL for negotiation line items.
- PON_AUCTION_SHIPMENTS_ALL and PON_AUC_PAYMENTS_SHIPMENTS for delivery and payment schedules.
- PON_AUCTION_CURRENCY_RATES for multi-currency details.
- PON_AWARD_ALLOCATIONS for award decisions.
It also references key foundational tables via foreign keys, such as HZ_PARTIES (Trading Partner), FND_USER (Buyer), HR_LOCATIONS_ALL (Ship/Bill To), FND_CURRENCIES, and PA_PROJECTS_ALL.
-
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 ,
-
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 ,
-
Table: PON_SUPPLIER_ACCESS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_SUPPLIER_ACCESS, object_name:PON_SUPPLIER_ACCESS, status:VALID, product: PON - Sourcing , description: This table will record the lock status for a supplier. As the negotiation proceeds the user might lock a supplier out of the negotiation from the 'Manage Supplier Activities' screen. At that point in time we will flag the supplier as 'Lo , implementation_dba_data: PON.PON_SUPPLIER_ACCESS ,
-
Table: PON_SUPPLIER_ACTIVITIES
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_SUPPLIER_ACTIVITIES, object_name:PON_SUPPLIER_ACTIVITIES, status:VALID, product: PON - Sourcing , description: This table will contain a row for each distinct activity performed by a Supplier User on the Negotiation as he/she navigates through the bidding flow. The latest activity will be indicated as such by the last_action_flag. , implementation_dba_data: PON.PON_SUPPLIER_ACTIVITIES ,
-
Table: PON_SUPPLIER_ACTIVITIES
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_SUPPLIER_ACTIVITIES, object_name:PON_SUPPLIER_ACTIVITIES, status:VALID, product: PON - Sourcing , description: This table will contain a row for each distinct activity performed by a Supplier User on the Negotiation as he/she navigates through the bidding flow. The latest activity will be indicated as such by the last_action_flag. , implementation_dba_data: PON.PON_SUPPLIER_ACTIVITIES ,
-
Table: PON_SUPPLIER_ACCESS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_SUPPLIER_ACCESS, object_name:PON_SUPPLIER_ACCESS, status:VALID, product: PON - Sourcing , description: This table will record the lock status for a supplier. As the negotiation proceeds the user might lock a supplier out of the negotiation from the 'Manage Supplier Activities' screen. At that point in time we will flag the supplier as 'Lo , implementation_dba_data: PON.PON_SUPPLIER_ACCESS ,
-
View: PON_MI_AUC_OFFERTOBUY_V
12.1.1
product: PON - Sourcing , description: This view is used by the Buyer's Activity Summary report. It contains data for all Committed Offers. , implementation_dba_data: Not implemented in this database ,
-
View: PON_MI_AUC_OFFERTOBUY_V
12.2.2
product: PON - Sourcing , description: This view is used by the Buyer's Activity Summary report. It contains data for all Committed Offers. , implementation_dba_data: Not implemented in this database ,
-
Table: PON_EMD_TRANSACTIONS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_EMD_TRANSACTIONS, object_name:PON_EMD_TRANSACTIONS, status:VALID, product: PON - Sourcing , implementation_dba_data: PON.PON_EMD_TRANSACTIONS ,
-
Table: PON_OPTIMIZE_SCENARIOS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_OPTIMIZE_SCENARIOS, object_name:PON_OPTIMIZE_SCENARIOS, status:VALID, product: PON - Sourcing , description: This table stores information about the award optimization scenarios , implementation_dba_data: PON.PON_OPTIMIZE_SCENARIOS ,
-
Table: PON_PARTY_LINE_EXCLUSIONS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_PARTY_LINE_EXCLUSIONS, object_name:PON_PARTY_LINE_EXCLUSIONS, status:VALID, product: PON - Sourcing , description: Table stores negotiation line restrictions for a particular supplier/line combination , implementation_dba_data: PON.PON_PARTY_LINE_EXCLUSIONS ,
-
Table: PON_PRICE_DIFFERENTIALS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_PRICE_DIFFERENTIALS, object_name:PON_PRICE_DIFFERENTIALS, status:VALID, product: PON - Sourcing , description: Negotiation price differentials table , implementation_dba_data: PON.PON_PRICE_DIFFERENTIALS ,
-
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_AUCTION_EVENTS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUCTION_EVENTS, object_name:PON_AUCTION_EVENTS, status:VALID, product: PON - Sourcing , description: Stores the event details of a group of negotiations. , implementation_dba_data: PON.PON_AUCTION_EVENTS ,
-
Table: PON_BIDDING_PARTIES
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BIDDING_PARTIES, object_name:PON_BIDDING_PARTIES, status:VALID, product: PON - Sourcing , description: Stores the parties participating in a negotiation. , implementation_dba_data: PON.PON_BIDDING_PARTIES ,
-
Table: PON_AUCTION_CURRENCY_RATES
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUCTION_CURRENCY_RATES, object_name:PON_AUCTION_CURRENCY_RATES, status:VALID, product: PON - Sourcing , description: Stores the currency conversion rate between the negotiation currency and the response currency , implementation_dba_data: PON.PON_AUCTION_CURRENCY_RATES ,
-
Table: PON_PARTY_LINE_EXCLUSIONS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_PARTY_LINE_EXCLUSIONS, object_name:PON_PARTY_LINE_EXCLUSIONS, status:VALID, product: PON - Sourcing , description: Table stores negotiation line restrictions for a particular supplier/line combination , implementation_dba_data: PON.PON_PARTY_LINE_EXCLUSIONS ,
-
Table: PON_NEG_TEAM_MEMBERS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_NEG_TEAM_MEMBERS, object_name:PON_NEG_TEAM_MEMBERS, status:VALID, product: PON - Sourcing , description: Stores Collaboration Team member details included in a negotiation or template. , implementation_dba_data: PON.PON_NEG_TEAM_MEMBERS ,
-
Table: PON_OPTIMIZE_CONSTRAINTS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_OPTIMIZE_CONSTRAINTS, object_name:PON_OPTIMIZE_CONSTRAINTS, status:VALID, product: PON - Sourcing , description: This table stores information about the user created constraints , implementation_dba_data: PON.PON_OPTIMIZE_CONSTRAINTS ,
-
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_AUCTION_CURRENCY_RATES
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUCTION_CURRENCY_RATES, object_name:PON_AUCTION_CURRENCY_RATES, status:VALID, product: PON - Sourcing , description: Stores the currency conversion rate between the negotiation currency and the response currency , implementation_dba_data: PON.PON_AUCTION_CURRENCY_RATES ,
-
Table: PON_BIDDING_PARTIES
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BIDDING_PARTIES, object_name:PON_BIDDING_PARTIES, status:VALID, product: PON - Sourcing , description: Stores the parties participating in a negotiation. , implementation_dba_data: PON.PON_BIDDING_PARTIES ,
-
Table: PON_AUCTION_SHIPMENTS_ALL
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUCTION_SHIPMENTS_ALL, object_name:PON_AUCTION_SHIPMENTS_ALL, status:VALID, product: PON - Sourcing , description: Stores the negotiation shipment details , implementation_dba_data: PON.PON_AUCTION_SHIPMENTS_ALL ,
-
Table: PON_AUC_PAYMENTS_INTERFACE
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUC_PAYMENTS_INTERFACE, object_name:PON_AUC_PAYMENTS_INTERFACE, status:VALID, product: PON - Sourcing , description: Interface table to store imported information of the payments that are defined on a negotiation for complex services. , implementation_dba_data: PON.PON_AUC_PAYMENTS_INTERFACE ,
-
Table: PON_AUCTION_EVENTS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUCTION_EVENTS, object_name:PON_AUCTION_EVENTS, status:VALID, product: PON - Sourcing , description: Stores the event details of a group of negotiations. , implementation_dba_data: PON.PON_AUCTION_EVENTS ,
-
Table: PON_PRICE_DIFFERENTIALS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_PRICE_DIFFERENTIALS, object_name:PON_PRICE_DIFFERENTIALS, status:VALID, product: PON - Sourcing , description: Negotiation price differentials table , implementation_dba_data: PON.PON_PRICE_DIFFERENTIALS ,
-
Table: PON_AUC_DOCTYPES
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUC_DOCTYPES, object_name:PON_AUC_DOCTYPES, status:VALID, product: PON - Sourcing , description: Stores the negotiation document type , implementation_dba_data: PON.PON_AUC_DOCTYPES ,
-
Table: PON_AUC_PAYMENTS_INTERFACE
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUC_PAYMENTS_INTERFACE, object_name:PON_AUC_PAYMENTS_INTERFACE, status:VALID, product: PON - Sourcing , description: Interface table to store imported information of the payments that are defined on a negotiation for complex services. , implementation_dba_data: PON.PON_AUC_PAYMENTS_INTERFACE ,
-
Table: PON_AUCTION_SHIPMENTS_ALL
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUCTION_SHIPMENTS_ALL, object_name:PON_AUCTION_SHIPMENTS_ALL, status:VALID, product: PON - Sourcing , description: Stores the negotiation shipment details , implementation_dba_data: PON.PON_AUCTION_SHIPMENTS_ALL ,
-
Table: PON_OPTIMIZE_CONSTRAINTS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_OPTIMIZE_CONSTRAINTS, object_name:PON_OPTIMIZE_CONSTRAINTS, status:VALID, product: PON - Sourcing , description: This table stores information about the user created constraints , implementation_dba_data: PON.PON_OPTIMIZE_CONSTRAINTS ,
-
Table: PON_AUC_DOCTYPES
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUC_DOCTYPES, object_name:PON_AUC_DOCTYPES, status:VALID, product: PON - Sourcing , description: Stores the negotiation document type , implementation_dba_data: PON.PON_AUC_DOCTYPES ,
-
Table: PON_ITEM_PRICES_INTERFACE
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_ITEM_PRICES_INTERFACE, object_name:PON_ITEM_PRICES_INTERFACE, status:VALID, product: PON - Sourcing , description: Temporary table contains the item price details that have been imported or exported to to excel. , implementation_dba_data: PON.PON_ITEM_PRICES_INTERFACE ,
-
Table: PON_ITEM_PRICES_INTERFACE
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_ITEM_PRICES_INTERFACE, object_name:PON_ITEM_PRICES_INTERFACE, status:VALID, product: PON - Sourcing , description: Temporary table contains the item price details that have been imported or exported to to excel. , implementation_dba_data: PON.PON_ITEM_PRICES_INTERFACE ,
-
Table: PON_NEG_TEAM_MEMBERS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_NEG_TEAM_MEMBERS, object_name:PON_NEG_TEAM_MEMBERS, status:VALID, product: PON - Sourcing , description: Stores Collaboration Team member details included in a negotiation or template. , implementation_dba_data: PON.PON_NEG_TEAM_MEMBERS ,
-
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_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_OPTIMIZE_SCENARIOS
12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_OPTIMIZE_SCENARIOS, object_name:PON_OPTIMIZE_SCENARIOS, status:VALID, product: PON - Sourcing , description: This table stores information about the award optimization scenarios , implementation_dba_data: PON.PON_OPTIMIZE_SCENARIOS ,
-
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 ,
-
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 ,
-
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_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_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_SCORING_TEAM_MEMBERS
12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_SCORING_TEAM_MEMBERS, object_name:PON_SCORING_TEAM_MEMBERS, status:VALID, product: PON - Sourcing , description: PON_SCORING_TEAM_MEMBERS is a logical intersection entity between PON_NEG_TEAM_MEMBERS and PON_SCORING_TEAMS. It lists the members for each scoring team for a given negotiation. Typically this will be a subset of those collaboration team me , implementation_dba_data: PON.PON_SCORING_TEAM_MEMBERS ,
-
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.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_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 ,
-
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_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 ,