Results for “pon_auction_headers_all”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PON_AUCTION_HEADERS_ALL is the master header table for the Oracle Sourcing module (product code PON), owned by the PON schema. It stores the header-level definition of every negotiation — including RFQs, RFIs, reverse auctions, forward auctions, and sourcing templates — across Oracle E-Business Suite releases 12.1.1 and 12.2.2. Each row represents a single negotiation document and carries the commercial, scheduling, currency, approval, and workflow attributes that drive the entire sourcing lifecycle from draft through publish, bidding, evaluation, award, and amendment.
In Data Vault terms, the ETRM heuristic classifies this object as hub-leaning. This is a modeling suggestion rather than a physical design: AUCTION_HEADER_ID functions as a durable business key that anchors a wide fan-out of dependent detail and interface tables, which is characteristic of a hub surrounded by numerous satellite and link structures.
Key Information Stored
The surrogate primary key is AUCTION_HEADER_ID, enforced by PON_AUCTION_HEADERS_ALL_PK and reinforced by the unique index PON_AUCTION_HEADERS_ALL_U1. The remaining 310 documented columns hold the substantive business content. The most operationally significant columns include:
AUCTION_TITLEandDOCUMENT_NUMBER— the human-readable identity of the negotiation.AUCTION_STATUS/AUCTION_STATUS_NAME,AWARD_STATUS, andOUTCOME_STATUS— lifecycle state indicators.AUCTION_TYPE,DOCTYPE_ID,SOLICITATION_TYPE, andOFFER_TYPE— classify the document (RFQ, auction, RFI, template).ORG_IDandBUYER_ID— the operating unit and owning buyer (the latter referencingFND_USER).TRADING_PARTNER_IDandTRADING_PARTNER_CONTACT_ID— supplier identity, joined toHZ_PARTIES.CURRENCY_CODE,RATE_TYPE,RATE, andRATE_DATE— currency and conversion context.OPEN_BIDDING_DATE,CLOSE_BIDDING_DATE,ORIGINAL_CLOSE_BIDDING_DATE, andVIEW_BY_DATE— bidding schedule;AWARD_BY_DATEgoverns award timing.SHIP_TO_LOCATION_IDandBILL_TO_LOCATION_ID— referencingHR_LOCATIONS_ALL.PROJECT_ID— links the negotiation toPA_PROJECTS_ALLfor project-driven sourcing.EVENT_ID— associates the row withPON_AUCTION_EVENTS.APPROVAL_STATUS,AWARD_APPROVAL_STATUS, andWF_APPROVAL_ITEM_KEY— approval and workflow state.AMENDMENT_NUMBERandAUCTION_HEADER_ID_ORIG_AMEND— amendment lineage.
Common Use Cases and Queries
The table is the primary source for sourcing dashboards, procurement analytics, and award tracking. Typical SQL patterns filter by operating unit and status:
- Active negotiations by buyer:
SELECT AUCTION_HEADER_ID, AUCTION_TITLE, AUCTION_STATUS_NAME FROM PON_AUCTION_HEADERS_ALL WHERE ORG_ID = :org AND BUYER_ID = :buyer; - Closing-soon report: filter on
CLOSE_BIDDING_DATEbetweenSYSDATEandSYSDATE + 7. - Award tracking: join
PON_AWARD_ALLOCATIONSonAUCTION_HEADER_IDto reconcile awarded amounts. - Bid participation analysis: join
PON_BID_HEADERSonAUCTION_HEADER_IDalongsideNUMBER_OF_BIDS. - Amendment lineage: self-join on
AUCTION_HEADER_ID_ORIG_AMENDto trace negotiation revisions.
Because columns such as ATTRIBUTE1–ATTRIBUTE15 (both INT_ and EXT_ prefixed) and ORG_ID are present, client extensions and multi-org security are applied through standard DFF and VPD mechanisms.
Related Objects
A large number of dependent tables reference AUCTION_HEADER_ID. The most significant include:
PON_AUCTION_SHIPMENTS_ALLandPON_AUCTION_ITEM_PRICES_ALL— shipment and pricing detail at the line level.PON_BID_HEADERS— supplier bid responses tied to the negotiation.PON_AWARD_ALLOCATIONS— award split and assignment records.PON_AUC_PAYMENTS_INTERFACEandPON_AUC_PAYMENTS_SHIPMENTS— payments and progress-payment processing.PON_BIDDING_PARTIES— invited suppliers.PON_AUCTION_SECTIONSandPON_NEG_TEAM_MEMBERS— structural and evaluation team data.PO_LINES_ALLandPO_REQUISITION_LINES_ALL— downstream purchasing of awarded lines.PON_AUCTION_CURRENCY_RATES— exchange rate snapshots per negotiation.
Parent references resolve to HZ_PARTIES, FND_USER, HR_LOCATIONS_ALL, PA_PROJECTS_ALL, FND_CURRENCIES, GL_DAILY_CONVERSION_TYPES, FND_LANGUAGES, PON_AUCTION_EVENTS, PON_AUC_DOCTYPES, and HR_ADE_STYLES, indicating the breadth of cross-module integration that this header supports.
-
Stores the negotiations header level details.
-
Stores the negotiations header level details.