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.