Search Results jtf_rs_group_members_aud




Overview
Explore in AI Chat

Overview

The JTF_RS_GROUP_MEMBERS_AUD table is a core audit trail object within the Oracle E-Business Suite CRM Foundation (JTF) module. It serves the critical function of tracking and storing historical changes made to group membership assignments. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is essential for maintaining data integrity, supporting compliance, and enabling historical analysis of how resource group compositions have evolved over time. Its existence allows the system to record a complete audit log for every insert, update, or delete operation performed on records in the base transactional table, JTF_RS_GROUP_MEMBERS.

Key Information Stored

The table's primary purpose is to capture the state of a group member record before and after a change. While the full column list is not detailed in the provided metadata, the structure of an audit table in Oracle EBS typically includes several key categories of data. The primary identifier is the GROUP_MEMBER_AUDIT_ID column, which forms the table's primary key. Crucially, the table stores the GROUP_MEMBER_ID, which is a foreign key linking back to the original record (or its last state) in the JTF_RS_GROUP_MEMBERS table. Standard audit table columns would also include the old and new values for relevant changed columns (e.g., RESOURCE_ID, GROUP_ID, ROLE_CODE), the type of DML operation performed (INSERT, UPDATE, DELETE), the date and time of the change (CREATION_DATE), and the identifier of the user or concurrent request that initiated the modification (CREATED_BY).

Common Use Cases and Queries

This table is primarily used for forensic reporting and compliance audits. Common scenarios include analyzing the history of a specific resource's group assignments, identifying who modified a group's membership and when, and reconstructing the state of a group at a specific point in time for reporting or troubleshooting. A typical query would join this audit table to the base JTF_RS_GROUP_MEMBERS table and resource tables to generate a human-readable audit trail.

  • Audit Trail for a Specific Group Member: SELECT aud.* FROM jtf_rs_group_members_aud aud WHERE aud.group_member_id = :p_member_id ORDER BY aud.creation_date DESC;
  • Recent Membership Changes for a Group: SELECT aud.creation_date, aud.resource_id, aud.operation FROM jtf_rs_group_members_aud aud WHERE aud.group_id = :p_group_id AND aud.creation_date > SYSDATE - 30;

Related Objects

The table has a direct and documented dependency on the core transactional table for group members. As per the provided relationship data, the foreign key relationship is fundamental to its operation.

  • JTF_RS_GROUP_MEMBERS: This is the primary transactional table for group member assignments. The JTF_RS_GROUP_MEMBERS_AUD table references it via the foreign key constraint on the column JTF_RS_GROUP_MEMBERS_AUD.GROUP_MEMBER_ID. This link ensures every audit record is tied to a specific member record, allowing for a complete historical lineage.