Search Results pv_enty_attr_values_pk

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:

• ENTITY_ID and ENTITY — the owning record and its entity type discriminator; ENTITY_ID is polymorphic, referencing either HZ_PARTIES or AS_LEADS_ALL.
• ATTRIBUTE_ID — foreign key to PV_ATTRIBUTES_B, identifying which partner attribute is being populated.
• PARTY_ID — the associated trading party, where applicable.
• ATTR_VALUE and ATTR_VALUE_EXTN — the stored value and its extended (typically longer or CLOB-backed) representation.
• SCORE — a numeric rating or weighting assigned to the attribute value, frequently used in partner scoring and ranking.
• VALIDATION_ID — foreign key to PV_ENTY_ATTR_VALIDATIONS, recording which validation rule governed the value.
• ENABLED_FLAG and LATEST_FLAG — status indicators controlling whether the row is active and whether it is the current version of the value.
• VERSION and OBJECT_VERSION_NUMBER — versioning and optimistic locking columns supporting the Oracle Applications concurrency model.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-tenant data segregation.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

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.