Search Results jtf_rs_groups

Overview

The table JTF.JTF_RS_ACTIVE_GRP_MBRS is a Resource Manager (JTF_RS) transactional table within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments that stores active resource group membership records. It belongs to the JTF (Common Technology Foundation — Customer Relationship Management and resource scheduling infrastructure) schema and resides in the APPS_TS_TX_DATA tablespace. The object carries a status of VALID and an FND Design Data registration of JTF.JTF_RS_ACTIVE_GRP_MBRS, confirming it is a supported, dictionary-registered table within the application's data model.

The table acts as the runtime, "currently effective" counterpart to the full membership history held in JTF_RS_GROUP_MEMBERS. Where the parent membership tables may retain inactive or historical assignments, this table is scoped to only those memberships that are presently active, making it the preferred access path for resource-group resolution logic (for example, determining which resources belong to a given group at the current point in time).

From a Data Vault modeling perspective, the mined relationship structure suggests this table functions as a link, connecting resource groups to individual resources and persons. The surrogate access key is GROUP_MEMBER_ID, which also serves as the primary key through JTF_RS_ACTIVE_GRP_MBRS_PK and the unique index JTF_RS_ACTIVE_GRP_MBRS_U1.

Key Information Stored

The table contains eleven documented columns, of which the following are the most significant for functional and query purposes:

• GROUP_MEMBER_ID (NUMBER) — The surrogate identifier for a resource group membership. It is the primary key column, enforced by unique index JTF_RS_ACTIVE_GRP_MBRS_U1 in the APPS_TS_TX_IDX tablespace, and is also the business-key candidate for this object.
• GROUP_ID (NUMBER) — The resource group identifier, forming a foreign key to JTF_RS_GROUPS_B. Indexed non-uniquely via JTF_RS_ACTIVE_GRP_MBRS_N1 together with RESOURCE_ID.
• RESOURCE_ID (NUMBER) — The resource identifier, referencing JTF_RS_RESOURCE_EXTNS. Together with GROUP_ID it drives group-membership lookups.
• PERSON_ID (NUMBER) — The employee identifier associated with the resource, used to correlate memberships back to HR persons.
• OBJECT_VERSION_NUMBER (NUMBER) — A sequential value used for optimistic database locking and concurrency control.
• LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — Standard "Who" columns recording when, by whom, and through which login the row was last changed.
• CREATION_DATE / CREATED_BY — Standard audit columns capturing the creation event.
• SECURITY_GROUP_ID (NUMBER) — Supports multi-tenant / Applications Hosting deployments and references FND_SECURITY_GROUPS.

Common Use Cases and Queries

The most frequent use case is resolving the set of active resources within a resource group. A typical query joins this table to JTF_RS_GROUPS_B and JTF_RS_RESOURCE_EXTNS:

• Active members by group: SELECT m.RESOURCE_ID, m.PERSON_ID FROM JTF.JTF_RS_ACTIVE_GRP_MBRS m WHERE m.GROUP_ID = :group_id;
• Groups for a resource: SELECT m.GROUP_ID FROM JTF.JTF_RS_ACTIVE_GRP_MBRS m WHERE m.RESOURCE_ID = :resource_id;
• Membership with resource detail: Join RESOURCE_ID to JTF_RS_RESOURCE_EXTNS to retrieve resource names and attributes for reporting.
• Audit / change tracking: Filter on LAST_UPDATE_DATE to identify memberships added or modified in a period.

Because the table is limited to active memberships, reporting queries generally avoid additional status filtering, though the underlying group record should still be validated to confirm the group itself is enabled.

Related Objects

The following objects are the most significant relationships for JTF_RS_ACTIVE_GRP_MBRS, drawn from the documented foreign keys and dependencies:

• JTF_RS_GROUP_MEMBERS — Referenced via GROUP_MEMBER_ID; the full membership record from which the active row is derived.
• JTF_RS_GROUPS_B — Joined on GROUP_ID for group header and definition details.
• JTF_RS_RESOURCE_EXTNS — Joined on RESOURCE_ID for resource attribute resolution.
• FND_SECURITY_GROUPS — Joined on SECURITY_GROUP_ID for security-group (hosting) context.
• APPS.JTF_RS_ACTIVE_GRP_MBRS — The APPS-layer synonym/view exposing the base JTF table to application code.

These joins cover the core group-to-resource resolution path and the audit/security context required for most EBS reporting and integration scenarios.