Search Results pon_auction_attr_mapping_u1




Overview
Explore in AI Chat

Overview

PON.PON_AUCTION_ATTR_MAPPING_B is a transactional table in the Oracle E-Business Suite PON (Sourcing/Procurement) schema. It belongs to the Supplier Management product family and stores the mappings that associate auction attributes with user-defined attributes. In practice, the table defines how standard auction header and line constructs are linked to configurable attribute lists, attribute groups, and individual attributes, allowing buyers to extend sourcing auctions with customer-specific descriptive or operational fields.

Physically, the table resides in the APPS_TS_TX_DATA tablespace with a PCT_FREE of 10, and its indexes are stored in APPS_TS_TX_IDX. The object is marked VALID and is registered as FND Design Data. Based on the foreign key structure and the absence of downward references, the table can be characterized heuristically as a standalone construct; in Data Vault modeling terms it behaves most like a satellite attached to the auction header business key, capturing descriptive mapping context rather than acting as a pure hub or link.

Key Information Stored

The table contains 18 columns. The surrogate primary key is MAPPING_ID, which is enforced by the unique index PON_AUCTION_ATTR_MAPPING_U1. The business-key candidate is likewise MAPPING_ID; the composite non-unique index PON_AUCTION_ATTR_MAPPING_N1 covers AUCTION_HEADER_ID and ATTRIBUTE_LIST_ID, which together represent the primary business access path.

  • MAPPING_ID — surrogate primary key uniquely identifying each mapping row.
  • AUCTION_HEADER_ID — foreign key to PON_AUCTION_HEADERS_ALL, identifying the auction whose attributes are being mapped.
  • LINE_NUMBER — auction line to which the mapping applies, when the mapping is line-level.
  • ATTRIBUTE_LIST_ID — foreign key to PON_ATTRIBUTE_LISTS, identifying the attribute list involved in the mapping. This is the column referenced by the user's search term.
  • SECTION_ID — section context for the mapped attribute.
  • SEQUENCE_NUMBER — display or processing sequence for the mapping.
  • MAPPING_TYPE — the type of mapping being defined (VARCHAR2 25).
  • RESPONSE — response value or indicator associated with the mapping (VARCHAR2 25).
  • CLASS_SCHEME — the class scheme used to categorize the mapped attribute.
  • ATTR_GROUP_ID — attribute group to which the mapped attribute belongs.
  • ATTR_INT_NAME — internal name of the attribute being mapped (VARCHAR2 30).
  • DATA_LEVEL_ID — user-defined attribute data level identifier.
  • MULTI_ROW_CODE — flag indicating whether the attribute permits multiple rows.
  • WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE provide standard audit lineage.

Common Use Cases and Queries

This table is primarily used to resolve how auction attributes are presented and captured against user-defined attribute lists. Typical reporting scenarios include identifying all mappings for a given auction, listing attribute lists referenced by an auction header, and extracting the internal attribute names and groups for a specific mapping type.

A common query pattern joins the table to the auction header and attribute list:

  • Retrieve all mappings for an auction: SELECT MAPPING_ID, ATTRIBUTE_LIST_ID, ATTR_INT_NAME, MAPPING_TYPE FROM PON.PON_AUCTION_ATTR_MAPPING_B WHERE AUCTION_HEADER_ID = :header_id ORDER BY SEQUENCE_NUMBER;
  • Join to attribute lists: SELECT m.MAPPING_ID, a.ATTRIBUTE_LIST_ID, a.ATTRIBUTE_LIST_NAME FROM PON.PON_AUCTION_ATTR_MAPPING_B m, PON.PON_ATTRIBUTE_LISTS a WHERE m.ATTRIBUTE_LIST_ID = a.ATTRIBUTE_LIST_ID;
  • Filter by mapping type and group for a specific auction and line combination using AUCTION_HEADER_ID, LINE_NUMBER, and ATTR_GROUP_ID.

Related Objects

The table participates in the following documented foreign key relationships:

  • PON.PON_AUCTION_HEADERS_ALL — referenced through AUCTION_HEADER_ID; the parent auction header record.
  • PON.PON_ATTRIBUTE_LISTS — referenced through ATTRIBUTE_LIST_ID; the attribute list definition.
  • PON_AUCTION_ATTR_MAPPING_B# — the editioning or synonym variant referenced by the PON schema.

Additional indirect dependencies include the attribute group and data level definitions that supply the identifiers stored in ATTR_GROUP_ID and DATA_LEVEL_ID, as well as the standard WHO audit columns resolved through FND user references.