Search Results pv_search_attr_values




Overview
Explore in AI Chat

Overview

The PV_SEARCH_ATTR_VALUES table is a core data object within the Oracle E-Business Suite Partner Management (PV) module. It functions as the primary repository for storing descriptive, textual attribute values associated with business partners. This table enables the extension of the standard partner profile by allowing organizations to capture and manage custom, searchable partner characteristics. Its role is integral to creating detailed partner classifications and facilitating advanced partner segmentation and reporting based on these custom-defined attributes.

Key Information Stored

The table's primary function is to link a partner, a specific attribute definition, and its corresponding text value. The critical columns that establish these relationships and store the data include:

  • SEARCH_ATTR_VALUES_ID: The primary key identifier for each unique attribute value record.
  • PARTY_ID: The foreign key linking to the HZ_PARTIES table, uniquely identifying the partner (organization or person) to whom the attribute value belongs.
  • ATTRIBUTE_ID: The foreign key linking to the PV_ATTRIBUTES_B table, identifying the specific custom attribute definition for which a value is being stored.
  • ATTRIBUTE_VALUE: The actual textual data value assigned to the specified attribute for the given partner.
This structure allows for a flexible many-to-one relationship where a single partner can have multiple custom attribute values, each tied to a distinct attribute definition.

Common Use Cases and Queries

A primary use case is generating reports on partner populations based on custom criteria, such as listing all partners with a specific certification or identifying partners in a particular geographic tier. Common SQL queries involve joining to the partner and attribute definition tables. For example, to retrieve all attribute values for a specific partner, one might use: 

SELECT pvab.attribute_name, psav.attribute_value
FROM pv_search_attr_values psav,
     pv_attributes_b pvab,
     hz_parties hp
WHERE psav.party_id = hp.party_id
  AND psav.attribute_id = pvab.attribute_id
  AND hp.party_name = '&PARTNER_NAME';
Another frequent pattern is searching for partners based on a specific attribute value, which supports operational screens and targeted communication lists within the Partner Management module.

Related Objects

The PV_SEARCH_ATTR_VALUES table sits at the intersection of partner master data and attribute definitions. Its documented foreign key relationships are fundamental:

  • HZ_PARTIES: The table is linked via PV_SEARCH_ATTR_VALUES.PARTY_ID = HZ_PARTIES.PARTY_ID. This relationship anchors the custom attribute data to the Trading Community Architecture (TCA) foundation, ensuring referential integrity with the master partner record.
  • PV_ATTRIBUTES_B: The table is linked via PV_SEARCH_ATTR_VALUES.ATTRIBUTE_ID = PV_ATTRIBUTES_B.ATTRIBUTE_ID. This relationship ensures that every stored value corresponds to a valid, predefined attribute within the Partner Management setup, governing the attribute's name, data type, and validation rules.
These relationships mean that any integration, data load, or extension involving custom partner attributes must consistently maintain these links to preserve data integrity.