Search Results pon_auction_headers_ext_b




Overview
Explore in AI Chat

Overview

PON_AUCTION_HEADERS_EXT_B is a key flexfield-style extension table in the Oracle Purchasing (PO) module, owned by the PO schema. It stores the descriptive flexfield (DFF) attribute values that users attach to sourcing auction headers created through Oracle Sourcing. Because the base auction header record resides in PON_AUCTION_HEADERS_ALL, this extension table isolates the configurable attribute segments so that the core auction definition remains independent of deployment-specific attribute configurations.

Each row in this table corresponds to a specific attribute group (ATTR_GROUP_ID) associated with a particular auction header (AUCTION_HEADER_ID), providing a normalized container for context-sensitive segments. Under the ETRM heuristic Data Vault classification, this table is modeled as a satellite. The classification reflects its role: it carries descriptive, change-tracked attributes that are wholly dependent on the auction header entity, with the AUCTION_HEADER_ID foreign key acting as the natural link back to the parent hub. It is not a standalone hub because its identity is derived from the parent auction, and it is not a link because it holds descriptive rather than relationship data.

Key Information Stored

The table contains 105 documented columns, structured around identity, foreign key linkage, and typed attribute value slots. The most significant columns are:

The separation of attribute slots by datatype (C_/N_/D_/UOM_) is a distinguishing feature that allows Oracle Sourcing to present the correct editor widget for each segment while storing values efficiently in a single extension row.

Common Use Cases and Queries

Typical scenarios include reporting on auction-specific custom attributes, extracting DFF values into downstream analytics or data warehouses, and auditing changes to auction headers. Because AUCTION_HEADER_ID is the join key to the parent table, most queries combine both objects:

  • Retrieving attribute values for a specific auction: SELECT e.EXTENSION_ID, e.C_EXT_ATTR1, e.C_EXT_ATTR2 FROM po.pon_auction_headers_ext_b e WHERE e.AUCTION_HEADER_ID = :auction_id;
  • Joining to the header for contextual reporting: SELECT h.AUCTION_HEADER_ID, h.AUCTION_TITLE, e.D_EXT_ATTR1 FROM po.pon_auction_headers_all h, po.pon_auction_headers_ext_b e WHERE h.AUCTION_HEADER_ID = e.AUCTION_HEADER_ID AND e.ATTR_GROUP_ID = :group_id;
  • Auditing recent changes: querying LAST_UPDATE_DATE and LAST_UPDATED_BY to identify who modified auction attributes and when.
  • Bulk extraction for migration or data conversion projects that need to preserve custom attribute values alongside the auction definition.

Because the table stores one row per attribute group per header, reports must group or filter by ATTR_GROUP_ID to avoid duplicating values across contexts.

Related Objects

The following objects are most significant when working with this table:

  • PON_AUCTION_HEADERS_ALL — The parent table of auction headers. Its AUCTION_HEADER_ID is referenced by this table's AUCTION_HEADER_ID foreign key; virtually every join starts here.
  • PON_AUCTION_HEADERS_EXT_TL — Translation table for extension attribute labels/descriptions, used to display segment names in the correct language.
  • FND_DESCR_FLEX_COL_USAGE and FND_DESCR_FLEX_CONTEXTS — Metadata tables describing which segments belong to each context and their prompt, used to interpret ATTR_GROUP_ID and the C_/N_/D_/UOM_ attribute slots.
  • FND_FLEX_VALUES / FND_FLEX_VALUES_TL — Value sets used by DFF segments to resolve lookup codes stored in C_EXT_ATTR columns.
  • FND_USER — Joined via CREATED_BY / LAST_UPDATED_BY to resolve user names in audit reports.
  • PON_AUCTION_HEADERS_EXT_B_PK index — The unique constraint enforcing EXTENSION_ID integrity and driving lookups by extension.

Reporting efforts typically join PON_AUCTION_HEADERS_ALL to this table on AUCTION_HEADER_ID, optionally resolving segment meanings through the FND_DESCR_FLEX tables to translate stored values into business-friendly labels.