Search Results jtf_rs_grp_relate_aud




Overview
Explore in AI Chat

Overview

JTF_RS_GRP_RELATE_AUD is an audit table in the JTF (CRM Foundation) schema of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores historical audit information for records held in the group relation entity, capturing before-and-after ("old" and "new") values whenever a group relation row is inserted, updated, or deleted. It is a child of JTF_RS_GRP_RELATIONS, joined through GROUP_RELATE_ID, and is owned by JTF with 20 documented columns.

Under a heuristic Data Vault classification mined from the foreign key structure, this table is satellite-leaning: it functions as an audit/descriptive satellite attached to a parent group-relation record (the implied hub or link), retaining the change history rather than serving as an integrating hub itself. This classification is a modeling suggestion, not a documented Oracle definition.

Key Information Stored

The surrogate primary key is GROUP_RELATE_AUDIT_ID, which is also documented as the unique index JTF_RS_GRP_RELATE_AUD_U1 (business-key candidate). The table's central grouping/business columns include:

The paired OLD_/NEW_ column pattern is the defining characteristic of this audit structure, enabling point-in-time reconstruction of changes.

Common Use Cases and Queries

Typical scenarios include change-history reporting, reconciliation, and compliance auditing of group relations. A representative query reconstructs the change set for a parent relation:

  • SELECT GROUP_RELATE_AUDIT_ID, GROUP_RELATE_ID, OLD_GROUP_ID, NEW_GROUP_ID, OLD_RELATED_GROUP_ID, NEW_RELATED_GROUP_ID, LAST_UPDATE_DATE FROM JTF_RS_GRP_RELATE_AUD WHERE GROUP_RELATE_ID = :p_relate_id ORDER BY CREATION_DATE;
  • Identifying relations whose effective dates or relation type changed, by comparing NEW_RELATION_TYPE against OLD_RELATION_TYPE.
  • Filtering audit rows by SECURITY_GROUP_ID to honor row-level security boundaries.
  • Joining back to JTF_RS_GRP_RELATIONS on GROUP_RELATE_ID to present current versus historical attributes in a single report.

Related Objects

  • JTF_RS_GRP_RELATIONS — parent table referenced via JTF_RS_GRP_RELATE_AUD.GROUP_RELATE_ID; the primary source of audited records.
  • FND_SECURITY_GROUPS — referenced via JTF_RS_GRP_RELATE_AUD.SECURITY_GROUP_ID, governing security group assignment.
  • Standard WHO/audit concurrency and security infrastructure objects (for example FND_USER) implicitly underpin the CREATED_BY, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN columns.

Together these relationships position JTF_RS_GRP_RELATE_AUD as the historical companion to the live group-relation data in the CRM Foundation module.