Search Results jtf_rs_active_grp_mbrs




Overview
Explore in AI Chat

Overview

The JTF_RS_ACTIVE_GRP_MBRS table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module, specifically for Release 12.1.1 and 12.2.2. It serves as a specialized, performance-optimized repository for active group membership records. Unlike its parent table, JTF_RS_GROUP_MEMBERS, which may contain the full history of memberships, this table is designed to provide rapid access to current, valid relationships between resources and groups. Its primary role is to support real-time operations, security models, and reporting that depend on knowing which resources are presently active members of which groups, a fundamental concept for structuring sales teams, service teams, and other organizational hierarchies within the CRM suite.

Key Information Stored

The table's structure is focused on the essential identifiers for an active membership. The primary key, GROUP_MEMBER_ID, uniquely identifies each active membership record. This column is a foreign key to the JTF_RS_GROUP_MEMBERS table, linking the active snapshot to the master membership definition. The GROUP_ID column identifies the specific group (from JTF_RS_GROUPS_B) to which the resource belongs. The RESOURCE_ID column identifies the individual member, linking to the JTF_RS_RESOURCE_EXTNS table which holds extended resource information. By design, the table contains only current records, implying an effective date mechanism or status flag is managed in the parent table, with this table acting as a filtered subset.

Common Use Cases and Queries

A primary use case is determining all active members of a particular group for task assignment or reporting. For example, to list all active members of a sales team (GROUP_ID = 1000), a query would join to resource tables: SELECT r.resource_name, m.* FROM jtf_rs_active_grp_mbrs m, jtf_rs_resource_extns r WHERE m.resource_id = r.resource_id AND m.group_id = 1000;. Conversely, to find all groups a specific resource actively belongs to: SELECT g.group_name, m.* FROM jtf_rs_active_grp_mbrs m, jtf_rs_groups_b g WHERE m.group_id = g.group_id AND m.resource_id = 500;. This table is critical for security and function-based menus that filter data access based on a user's active group affiliations, ensuring users only see data relevant to their current team assignments.

Related Objects

The table maintains strict referential integrity through documented foreign key relationships, making it a central hub for group membership data. The key related objects are:

  • JTF_RS_GROUP_MEMBERS: The master table for group membership. The foreign key on GROUP_MEMBER_ID establishes that every active record must have a corresponding master definition.
  • JTF_RS_GROUPS_B: The base definition table for groups. The foreign key on GROUP_ID ensures every active membership references a valid group.
  • JTF_RS_RESOURCE_EXTNS: The table for resource details. The foreign key on RESOURCE_ID ensures every active membership is for a valid resource entity.
These relationships are essential for constructing accurate joins in reports and for maintaining data consistency when groups or resources are inactivated.