Search Results pv_enty_attr_values




Overview
Explore in AI Chat

Overview

PV_ENTY_ATTR_VALUES is a Partner Management (PV) transactional table that stores the individual attribute values captured against partners, prospective partners, and related entities within Oracle E-Business Suite Release 12.1.1 and 12.2.2. The table functions as the value repository for the configurable attribute framework defined in PV_ATTRIBUTES_B, allowing classifications, scores, and qualifiers to be assigned to a party or lead record without schema changes. Each row pairs an entity (identified by ENTITY_ID and an ENTITY discriminator) with a defined attribute and its corresponding value.

From a Data Vault modeling perspective, the metadata suggests a link classification: the table resolves many-to-many associations between entities, attribute definitions, and validation rules rather than acting as a pure descriptive satellite. This heuristic should be treated as a modeling suggestion only; in physical EBS terms it is a child detail table protected by the PV_ENTY_ATTR_VALUES_PK primary key.

Key Information Stored

The surrogate primary key ENTY_ATTR_VAL_ID uniquely identifies each attribute-value instance and is also exposed through the PV_ENTY_ATTR_VALUES_U1 unique index, making it the only documented business-key candidate. Other significant columns include:

Common Use Cases and Queries

Typical scenarios include retrieving all attribute values for a party, reporting scored partner classifications, and validating that required attributes are populated for a lead or party record.

  • Retrieve active attribute values for a party: 
    SELECT v.ENTY_ATTR_VAL_ID, v.ATTRIBUTE_ID, v.ATTR_VALUE, v.SCORE
FROM   PV.PV_ENTY_ATTR_VALUES v
WHERE  v.ENTITY_ID = :party_id
AND    v.ENABLED_FLAG = 'Y'
AND    v.LATEST_FLAG = 'Y';
  • Join to attribute definitions to obtain descriptive names: 
    SELECT a.ATTRIBUTE_NAME, v.ATTR_VALUE, v.SCORE
FROM   PV.PV_ENTY_ATTR_VALUES v,
       PV.PV_ATTRIBUTES_B     a
WHERE  v.ATTRIBUTE_ID = a.ATTRIBUTE_ID
AND    v.ENTITY_ID    = :party_id;
  • Score-based ranking of partners for a specific attribute, and audit-style reporting of validation outcomes by joining VALIDATION_ID to PV_ENTY_ATTR_VALIDATIONS.

Related Objects

The following objects are most significant to this table based on documented foreign key relationships:

  • PV_ATTRIBUTES_B — joined on ATTRIBUTE_ID; defines the attribute metadata (name, type, validation behavior).
  • HZ_PARTIES — joined on ENTITY_ID; the primary party master for partner records.
  • AS_LEADS_ALL — joined on ENTITY_ID; supports attribute capture against leads and opportunities.
  • PV_ENTY_ATTR_VALIDATIONS — joined on VALIDATION_ID; stores validation rule definitions applied to values.
  • FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID; governs row-level security and multi-org access.

Together these relationships position PV_ENTY_ATTR_VALUES as the central value store within the Partner Management attribute framework, with ENTITY_ID serving as a polymorphic discriminator across party and lead domains.