Search Results pv_selected_attr_values




Overview
Explore in AI Chat

Overview

The PV_SELECTED_ATTR_VALUES table is a core data structure within the Oracle E-Business Suite Partner Management (PV) module. It functions as a repository for storing specific attribute values that are used to define mapping and selection criteria for partner entities. In the context of partner management, this table enables the systematic categorization and segmentation of partners based on definable attributes, such as industry, region, or partner tier. Its primary role is to support the configuration of complex selection rules, which are essential for targeted partner communications, program eligibility, and automated partner scoring processes within the application.

Key Information Stored

The table's central purpose is to store discrete attribute values linked to a broader selection criterion. While the full column list is not detailed in the provided metadata, the documented primary and foreign keys reveal its critical structure. The ATTR_VALUE_ID column serves as the unique primary key for each record. The SELECTION_CRITERIA_ID column is a foreign key that establishes a direct relationship with the PV_ENTY_SELECT_CRITERIA table. This relationship indicates that each attribute value record is a child of a specific selection criterion entity. Additional columns, though not specified, would typically store the actual attribute value, a reference to the attribute definition itself, and potentially display sequence or effective date information.

Common Use Cases and Queries

This table is primarily accessed during the execution and reporting of partner selection rules. A common use case involves generating a list of all partners who meet a specific set of attribute-based criteria for a marketing campaign. For instance, an administrator might query for all partners mapped with a specific attribute value, such as "Gold Tier" or "North America Region." A typical reporting query would join this table to its parent criterion table and then to the main partner entity tables. A fundamental SQL pattern to audit the attribute values defined for a given selection criterion would be:

  • SELECT attr_value_id, selection_criteria_id, [attribute_value] FROM pv.pv_selected_attr_values WHERE selection_criteria_id = <CRITERIA_ID> ORDER BY attr_value_id;

Data in this table is typically managed through the Oracle EBS Partner Management application screens, not via direct DML, to maintain business logic integrity.

Related Objects

The PV_SELECTED_ATTR_VALUES table has a documented, dependent relationship with one other key object in the Partner Management schema, as defined by its foreign key constraint.

  • PV_ENTY_SELECT_CRITERIA: This is the primary parent table. The relationship is defined by the foreign key column PV_SELECTED_ATTR_VALUES.SELECTION_CRITERIA_ID, which references the PV_ENTY_SELECT_CRITERIA table. Every record in PV_SELECTED_ATTR_VALUES must correspond to a valid selection criteria record. This table hierarchy forms the foundation for building multi-attribute selection rules for partner entities.