Results for “jtf_rs_groups_aud_tl”

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

Overview

JTF_RS_GROUPS_AUD_TL is a translation (TL) table within the JTF — CRM Foundation product, owned by the JTF schema. It stores multilingual, translated audit information for a resource group, capturing the before-and-after values of key descriptive attributes whenever a group record is changed. As a translation table, it holds one row per group audit event per installed language, which allows Oracle EBS to display audit history in the user's session language while retaining the original source-language text.

Under the heuristic Data Vault classification mined from its foreign key structure, this table leans toward a satellite. This is a modeling suggestion rather than a declared classification: the table carries a composite key that includes a language attribute, references a base audit table, and holds descriptive, time-stamped change data — all characteristics of a satellite surrounding a central hub or link. In practice, the base table JTF_RS_GROUPS_AUD_B serves as the anchor, and this TL table provides the language-dependent descriptive payload.

Key Information Stored

The table contains 13 documented columns. The most significant include:

• GROUP_AUDIT_ID — the surrogate identifier tying each translation row to its parent audit record; part of the composite primary key.
• LANGUAGE — the language code for the translated row; the second component of the composite primary key.
• NEW_GROUP_NAME and OLD_GROUP_NAME — the group name after and before the change, respectively.
• NEW_GROUP_DESC and OLD_GROUP_DESC — the group description after and before the change, respectively.
• SOURCE_LANG — the language in which the source text was originally entered, used by the translation framework.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns recording who created and last modified the row and when.
• SECURITY_GROUP_ID — the security group context under which the row is visible.

The surrogate primary key is JTF_RS_GROUPS_AUD_TL_PK (GROUP_AUDIT_ID, LANGUAGE). A unique index, JTF_RS_GROUPS_AUD_TL_U1 (GROUP_AUDIT_ID, LANGUAGE), mirrors this same column pair and represents the documented business-key candidate, enforcing one translation row per audit event per language.

Common Use Cases and Queries

Typical use cases center on audit reporting and change-history display for resource groups. An administrator may want to review the evolution of a group's name or description over time, or produce a multilingual audit extract for compliance. A representative query joins the translation table to its base table by audit ID and language:

• Retrieve audit history for a specific group: SELECT t.group_audit_id, t.language, t.old_group_name, t.new_group_name, t.last_update_date FROM jtf.jtf_rs_groups_aud_tl t WHERE t.group_audit_id = :audit_id ORDER BY t.last_update_date DESC;
• Filter by session language: add WHERE t.language = USERENV('LANG') to show only the translation matching the user's language.
• Detect name-only changes: compare NEW_GROUP_NAME against OLD_GROUP_NAME where the two differ.
• Feed downstream reporting or an audit dashboard by joining on GROUP_AUDIT_ID to the base audit table for the full audit context.

Related Objects

• JTF_RS_GROUPS_AUD_B — the base audit table; GROUP_AUDIT_ID is the foreign key column referencing it. This is the primary parent object.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID, governing row-level security visibility.
• JTF_RS_GROUPS_AUD_TL_PK — the composite primary key constraint/index on (GROUP_AUDIT_ID, LANGUAGE).
• JTF_RS_GROUPS_AUD_TL_U1 — the unique business-key index on (GROUP_AUDIT_ID, LANGUAGE).
• Related JTF resource-group base tables and translation tables (for example, group master and group translation objects) typically share the same GROUP_ID lineage and are commonly joined when reconciling audit history against live group definitions.