Search Results cs_party_role_group_maps_pk

Overview

CS_PARTY_ROLE_GROUP_MAPS is a Service (CS) module reference table in Oracle E-Business Suite 12.1.1 and 12.2.2, owned by the CS schema. It stores the mappings between Party Role Groups and Party Roles, allowing the application to associate a defined group of roles with individual role codes. In the Service product family, party roles describe the function a party plays in a service relationship (for example, customer contact, resource, or vendor contact), and role groups provide a logical bundling of those roles for assignment, access, and configuration purposes. This table is the association layer that binds the two.

From a data modeling perspective, the documented foreign key structure suggests a Data Vault classification of link. The table does not hold descriptive attributes of a role or a group; rather, it resolves a many-to-many association between two business entities, which is the defining characteristic of a link table in heuristic Data Vault modeling.

Key Information Stored

Each row represents one mapping between a party role group and a party role. The most significant columns are:

• PARTY_ROLE_GROUP_MAPPING_ID — the surrogate primary key, enforced by CS_PARTY_ROLE_GROUP_MAPS_PK and also present in the CS_PARTY_ROLE_GROUP_MAPS_U1 unique index.
• PARTY_ROLE_GROUP_CODE — the foreign key to CS_PARTY_ROLE_GROUPS_B identifying the role group in the mapping; part of unique index CS_PARTY_ROLE_GROUP_MAPS_U2.
• PARTY_ROLE_CODE — the foreign key to CS_PARTY_ROLES_B identifying the individual role in the mapping; also part of unique index CS_PARTY_ROLE_GROUP_MAPS_U2.
• START_DATE_ACTIVE and END_DATE_ACTIVE — effective dating that controls whether a mapping is currently valid.
• SEEDED_FLAG — indicates whether the mapping was delivered as seed data by Oracle or created by the customer.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF framework.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Who columns capturing audit history.
• ZD_EDITION_NAME — the editioning column supporting Oracle EBS 12.2 online patching (Edition-Based Redefinition).

The combination of PARTY_ROLE_GROUP_CODE, PARTY_ROLE_CODE, and ZD_EDITION_NAME (CS_PARTY_ROLE_GROUP_MAPS_U2) is the effective business key candidate, ensuring that no role is mapped twice to the same group within an edition.

Common Use Cases and Queries

The primary use case is resolving which roles belong to a given group, and conversely which groups a role participates in. Application code and extension developers query this table when building role-based assignment pages, validation logic, or Service request routing that depends on role grouping.

A representative query to list all active roles in a group:

• SELECT m.PARTY_ROLE_CODE, m.START_DATE_ACTIVE, m.END_DATE_ACTIVE FROM CS_PARTY_ROLE_GROUP_MAPS m WHERE m.PARTY_ROLE_GROUP_CODE = :group_code AND SYSDATE BETWEEN NVL(m.START_DATE_ACTIVE, SYSDATE-1) AND NVL(m.END_DATE_ACTIVE, SYSDATE+1);

A reporting query joining to the role group and role base tables to produce readable descriptions uses the two FK columns against CS_PARTY_ROLE_GROUPS_B and CS_PARTY_ROLES_B respectively. Because the table is edition-enabled, any query executed in a 12.2.2 environment should respect ZD_EDITION_NAME filtering implicitly through the editioning view, or explicitly when reading the base table directly.

Related Objects

The following objects are most significant in relation to CS_PARTY_ROLE_GROUP_MAPS:

• CS_PARTY_ROLES_B — referenced via PARTY_ROLE_CODE; holds the role definitions being mapped.
• CS_PARTY_ROLE_GROUPS_B — referenced via PARTY_ROLE_GROUP_CODE; holds the role group definitions.
• CS_PARTY_ROLES_TL and CS_PARTY_ROLE_GROUPS_TL — translation tables supplying language-specific role and group names for reporting joins.
• The editioning views over CS_PARTY_ROLE_GROUP_MAPS, CS_PARTY_ROLES_B, and CS_PARTY_ROLE_GROUPS_B, which are the normal access path in 12.2.x online-patching environments.
• Service module UI and API components that resolve role group membership at runtime, consuming the mapping rows created and maintained through this table.