Search Results pv_attrib_resp_mappings




Overview
Explore in AI Chat

Overview

The PV_ATTRIB_RESP_MAPPINGS table is a core data object within the Oracle E-Business Suite Partner Management (PV) module, versions 12.1.1 and 12.2.2. It functions as a mapping or junction table that establishes relationships between partner attributes and their corresponding responsibilities. Its primary role is to govern data access and visibility within the complex partner hierarchy, ensuring that specific partner attributes are managed and viewed only by the appropriate partner responsibilities. This table is essential for implementing attribute-level security and data partitioning in a multi-tiered partner ecosystem.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships reveal the critical data elements. The central column is ATTRIB_RESP_MAP_ID, which serves as the unique primary key for each mapping record. The table stores two fundamental foreign key references: the ATTRIBUTE_ID, which links to the PV_ATTRIBUTES_B table to identify the specific partner attribute, and the REF_ATTRIB_RESP_MAP_ID, which creates a recursive relationship within the same table. This self-referencing foreign key is a key architectural feature, indicating the table can model hierarchical or dependent relationships between different attribute-responsibility mappings, such as for inherited or default settings.

Common Use Cases and Queries

A primary use case is auditing and reporting on which responsibilities have access to specific partner attributes. Administrators may query this table to understand the security model or troubleshoot data visibility issues for a partner user. Another critical scenario is during the setup or modification of partner profiles, where the system references these mappings to determine which attribute fields to display or enable for a given responsibility. A sample query to list all mappings would be:

  • SELECT attrib_resp_map_id, attribute_id, ref_attrib_resp_map_id FROM pv.pv_attrib_resp_mappings ORDER BY attribute_id;

For a more detailed report joining to the attribute definitions, a query would join on PV_ATTRIBUTES_B. The recursive relationship can be explored using a self-join to find parent-child mapping dependencies.

Related Objects

The table maintains defined relationships with several other objects in the Partner Management schema, as per the provided metadata.

  • PV_ATTRIBUTES_B: This is the master table for partner attribute definitions. The PV_ATTRIB_RESP_MAPPINGS.ATTRIBUTE_ID column is a foreign key to this table, linking each mapping to a specific attribute.
  • PV_ATTRIB_RESP_MAPPINGS (Self-Reference): The table has a recursive foreign key relationship with itself. The column REF_ATTRIB_RESP_MAP_ID references the ATTRIB_RESP_MAP_ID primary key of another record within the same table. This structure allows for the creation of hierarchical chains or default mapping relationships between different attribute-responsibility combinations.