Results for “pon_auction_attributes”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PON_AUCTION_ATTRIBUTES is a transactional table in the Oracle E-Business Suite Sourcing module (product code PON). It stores the negotiation item attributes that define and describe the individual attributes applied to auction and negotiation lines. Each row captures the configuration, display, and scoring behavior of a single attribute attached to a specific auction header and line, along with the attribute list from which it originated.

The table functions as a child of the auction header and works in close association with the auction item pricing structures and the attribute list and template definitions that drive negotiation setup. It is central to how Sourcing presents, evaluates, and scores supplier responses during a negotiation event.

From a dimensional modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is a link. This suggests the table is best modeled as an associative entity resolving relationships between auctions, lines, attribute lists, and templates, rather than as an independent hub or descriptive satellite.

Key Information Stored

PON_AUCTION_ATTRIBUTES contains 38 documented columns. The most significant are described below.

  • AUCTION_HEADER_ID — Identifier of the parent auction header to which the attribute belongs; a component of the primary key and a business-key candidate.
  • LINE_NUMBER — The negotiation line to which the attribute applies; joins to the item pricing structure.
  • ATTRIBUTE_LIST_ID — The attribute list supplying the attribute definition; a foreign key to the attribute list and template tables.
  • ATTRIBUTE_NAME — The name of the attribute as presented on the negotiation.
  • DATATYPE — The data type governing how the attribute value is entered and validated.
  • VALUE — The stored value for the attribute on the negotiation.
  • MANDATORY_FLAG — Indicates whether the supplier must provide a value.
  • DISPLAY_TARGET_FLAG and DISPLAY_ONLY_FLAG — Control attribute visibility and whether it is display-only versus editable.
  • SEQUENCE_NUMBER — Orders attributes within a line; a component of the alternate unique index.
  • WEIGHT, SCORING_TYPE, SCORING_METHOD, ATTR_MAX_SCORE, and KNOCKOUT_SCORE — Define how the attribute is scored and weighted during evaluation, including knockout thresholds.
  • ATTR_LEVEL, ATTR_GROUP, ATTR_GROUP_SEQ_NUMBER, and ATTR_DISP_SEQ_NUMBER — Establish the level, grouping, and display sequencing of the attribute.

The documented surrogate/business key is the unique index PON_AUCTION_ATTRIBUTES_UK (LINE_NUMBER, ATTRIBUTE_LIST_ID, ATTRIBUTE_NAME, AUCTION_HEADER_ID). A second unique index, PON_AUCTION_ATTRIBUTES_U1 (AUCTION_HEADER_ID, LINE_NUMBER, SEQUENCE_NUMBER, ATTRIBUTE_LIST_ID), is documented as a business-key candidate. Standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) and concurrent-program columns (REQUEST_ID, PROGRAM_ID) are also present.

Common Use Cases and Queries

Typical uses include reporting the attributes defined for a negotiation, auditing scoring configuration, and tracing attribute lists into auctions.

  • List attributes for an auction: SELECT ATTRIBUTE_NAME, DATATYPE, VALUE, WEIGHT, SCORING_TYPE FROM PON_AUCTION_ATTRIBUTES WHERE AUCTION_HEADER_ID = :auction_id ORDER BY LINE_NUMBER, SEQUENCE_NUMBER;
  • Identify mandatory attributes: filter on MANDATORY_FLAG = 'Y' to confirm which attributes suppliers must satisfy.
  • Review scoring setup: select WEIGHT, SCORING_METHOD, ATTR_MAX_SCORE, and KNOCKOUT_SCORE to validate evaluation criteria.
  • Trace attribute list usage: join to PON_ATTRIBUTE_LISTS on ATTRIBUTE_LIST_ID to reconcile template-driven attributes against those actually applied.

Related Objects

The following objects are the most significant dependencies, based on the documented foreign keys and primary key relationships:

  • PON_AUCTION_ITEM_PRICES_ALL — joined via LINE_NUMBER and AUCTION_HEADER_ID, linking attributes to item pricing.
  • PON_ATTRIBUTE_LISTS — joined on ATTRIBUTE_LIST_ID, supplying the source attribute definitions.
  • PON_AUCTION_TEMPLATES — joined on ATTRIBUTE_LIST_ID, connecting attributes to the templates that seed the negotiation.
  • The auction header entity (referenced by AUCTION_HEADER_ID) is the parent record establishing negotiation context.

These relationships confirm the table's role as a link bridging negotiation headers, lines, attribute lists, and templates within the Sourcing data model.