Search Results pon_attribute_lists




Overview
Explore in AI Chat

Overview

The PON_ATTRIBUTE_LISTS table is a core data repository within the Oracle E-Business Suite Sourcing (PON) module, specifically for versions 12.1.1 and 12.2.2. It functions as the master table for storing attribute lists that are associated with trading partners. In the context of strategic sourcing and negotiation processes, attribute lists define the non-price criteria—such as quality, delivery terms, or technical specifications—used to evaluate suppliers or line items. This table enables the assignment of standardized or customized evaluation criteria to specific suppliers (trading partners) and their contacts, thereby facilitating structured and comparative analysis during auctions, RFQs, and other sourcing events.

Key Information Stored

The table's primary purpose is to link a uniquely identified attribute list to a trading partner entity. Its key columns, as indicated by its constraints, include the ATTRIBUTE_LIST_ID, which serves as the primary key for each list. Crucially, the table establishes relationships with the Trading Community Architecture (TCA) registry through the TRADING_PARTNER_ID and TRADING_PARTNER_CONTACT_ID columns. These foreign keys reference the HZ_PARTIES table, tying each attribute list definitively to a specific supplier organization and, optionally, to a particular contact within that organization. Other typical columns, inferred from standard practice, would include creation and last update dates, the list name, and a status indicator, though these are not explicitly detailed in the provided metadata.

Common Use Cases and Queries

A primary use case is retrieving all attribute lists defined for a specific supplier to pre-populate or validate criteria in a new sourcing event. For reporting, administrators may analyze the adoption and assignment of attribute lists across the supplier base. Common SQL patterns include joining to HZ_PARTIES to resolve trading partner names. For instance, a query to find lists for a supplier by name would be:

  • SELECT pal.ATTRIBUTE_LIST_ID, hp.PARTY_NAME FROM PON.PON_ATTRIBUTE_LISTS pal, HZ_PARTIES hp WHERE pal.TRADING_PARTNER_ID = hp.PARTY_ID AND hp.PARTY_NAME = 'Supplier XYZ';

Another critical pattern involves identifying which sourcing auctions or sections utilize a particular list via joins to PON_AUCTION_ATTRIBUTES or PON_AUCTION_SECTIONS.

Related Objects

The PON_ATTRIBUTE_LISTS table is central to the Sourcing module's data model. As per the foreign key relationships, it is directly referenced by the PON_AUCTION_ATTRIBUTES and PON_AUCTION_SECTIONS tables. This means the attribute lists stored here are applied at either the overall auction level or within specific sections of a negotiation. The table is fundamentally dependent on the HZ_PARTIES table from the Trading Community Architecture for valid trading partner and contact information. Consequently, any data integrity or purge operation in HZ_PARTIES must consider these foreign key constraints. The table is also likely referenced by various Sourcing APIs and user interface forms that manage supplier profiles and negotiation templates.