Results for “jtf_rs_chgd_grp_relations”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JTF_RS_CHGD_GRP_RELATIONS is a CRM Foundation (JTF) table in the Oracle E-Business Suite resource management model. It stores the relationships that exist between resource groups, most notably the hierarchical association expressed by the RELATION_TYPE value 'PARENT_GROUP'. The table is described in the ETRM metadata as functionally similar to JTF_RS_GRP_RELATIONS, with the distinguishing addition of an OPERATION_FLAG column that supports change-tracking or staged update semantics. The primary key is GROUP_RELATE_ID, enforced by the constraint JTF_RS_CHGD_GRP_RELATIONS_PK.

In Oracle EBS 12.1.1 and 12.2.2, this object belongs to the resource manager (JTF_RS) schema family, which underpins group membership, group hierarchies, and access control for CRM applications such as TeleSales, Service, and Field Service. Because group hierarchies drive role-based visibility, the parent-child relationships recorded here directly influence which users can see which customers, leads, opportunities, and service requests. Heuristically, the mined foreign-key structure classifies the object as standalone. From a Data Vault modeling perspective, it is best treated as a link candidate: a relationship table whose natural grain is the pairing of a group and a related group within a typed association, carrying descriptive change attributes rather than serving as a pure hub or satellite.

Key Information Stored

The documented physical schema contains thirteen columns in the JTF schema. The most operationally significant are listed below.

• GROUP_RELATE_ID — Surrogate primary key, enforced by JTF_RS_CHGD_GRP_RELATIONS_PK. No business-key unique index is documented beyond this constraint in the supplied metadata.
• GROUP_ID — The owning or subject group in the relationship; a business-key candidate when combined with RELATED_GROUP_ID and RELATION_TYPE.
• RELATED_GROUP_ID — The counterpart group. For RELATION_TYPE = 'PARENT_GROUP', the direction of this pairing determines which group is the parent and which is the subordinate.
• RELATION_TYPE — The discriminator for the association. The documented example is 'PARENT_GROUP'.
• OPERATION_FLAG — The column that differentiates this table from JTF_RS_GRP_RELATIONS; it records the change operation applied to the relation.
• START_DATE_ACTIVE and END_DATE_ACTIVE — Effective-dating columns that bound the validity of the relationship without deleting the row.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-tenant or security-group partitioning of the row.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO-column audit trail identifying who created and last modified the relationship and through which login.

Common Use Cases and Queries

Typical applications resolve a group's parent for hierarchy traversal, audit changes captured through OPERATION_FLAG, and reconstruct effective-dated hierarchies for reporting. A representative query returns the immediate parent of a group:

• SELECT RELATED_GROUP_ID FROM JTF.JTF_RS_CHGD_GRP_RELATIONS WHERE GROUP_ID = :group_id AND RELATION_TYPE = 'PARENT_GROUP' AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE);
• Audit reporting: SELECT GROUP_ID, RELATED_GROUP_ID, OPERATION_FLAG, LAST_UPDATE_DATE FROM JTF.JTF_RS_CHGD_GRP_RELATIONS WHERE LAST_UPDATE_DATE >= :since ORDER BY LAST_UPDATE_DATE;
• Hierarchy reporting joins GROUP_ID to the group master to resolve names and walks RELATED_GROUP_ID recursively to build an organizational tree for responsibility-based access diagnostics.

Related Objects

The documented foreign key links SECURITY_GROUP_ID to FND_SECURITY_GROUPS. Functionally, the table is closely tied to its sibling JTF_RS_GRP_RELATIONS and to the group master objects that supply both sides of each relation. Practitioners commonly join the following.

• JTF_RS_GROUPS_VL / JTF_RS_GROUPS_B — Group master; join on GROUP_ID and RELATED_GROUP_ID to resolve group names and attributes.
• JTF_RS_GRP_RELATIONS — The base relations table without OPERATION_FLAG; useful for comparing committed versus changed relations.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID for security-group filtering.
• JTF_RS_GROUP_MEMBERS — Group membership, joined through GROUP_ID to relate hierarchy to membership.
• JTF_RS_RESOURCE_EXTNS — Resource extension data for members of the related groups.