Search Results jtf_rs_role_relate_aud




Overview
Explore in AI Chat

Overview

The JTF_RS_ROLE_RELATE_AUD table is a core audit trail object within the Oracle E-Business Suite (EBS) CRM Foundation module (JTF). It functions as a historical log, capturing all changes made to role relationship assignments in the system. In EBS 12.1.1 and 12.2.2, role relationships define hierarchical or associative links between different resource roles, which are fundamental for managing organizational structures, security, and responsibility assignments. This audit table is essential for compliance, troubleshooting, and maintaining a complete record of how role relationships have evolved over time, providing a critical audit trail for any modifications.

Key Information Stored

The table stores a snapshot of a role relationship record at the moment of an audited event. While the full column list is not detailed in the provided metadata, the structure of such audit tables typically includes key identifiers and change-tracking columns. The documented primary key is ROLE_RELATE_AUDIT_ID, a unique sequence identifier for each audit record. A critical foreign key column is ROLE_RELATE_ID, which links back to the specific role relationship record that was modified in the JTF_RS_ROLE_RELATIONS table. Standard audit columns expected in this context include the OPERATION type (INSERT, UPDATE, DELETE), the DATE of the change, and the USER_ID or equivalent identifier of who performed the action. The table likely also holds copies of the key data columns from the source relationship record at the time of the audit event.

Common Use Cases and Queries

The primary use case is generating audit reports for security and compliance reviews, tracing the history of specific role relationship configurations. Support personnel query this table to diagnose issues related to unexpected access or missing responsibilities by understanding what changes were made and when. A common query pattern involves joining to the JTF_RS_ROLE_RELATIONS table to get descriptive context for the audited relationship ID.

Sample Query Pattern:
SELECT aud.role_relate_audit_id, aud.role_relate_id, rel.role_id, rel.related_role_id, aud.last_update_date, aud.last_updated_by
FROM jtf.jtf_rs_role_relate_aud aud,
     jtf.jtf_rs_role_relations rel
WHERE aud.role_relate_id = rel.role_relate_id
AND aud.last_update_date BETWEEN :p_start_date AND :p_end_date
ORDER BY aud.last_update_date DESC;

Related Objects

The table has a direct and documented foreign key relationship with the core role relationship definition table. This relationship is fundamental to its purpose.

  • JTF_RS_ROLE_RELATIONS: This is the primary table for storing active role relationship definitions. The JTF_RS_ROLE_RELATE_AUD table references it via the foreign key constraint on the column JTF_RS_ROLE_RELATE_AUD.ROLE_RELATE_ID. This links each audit record to the specific master relationship record that was altered.

As a base audit table, it may also be referenced by standard or custom audit reports and interfaces within the CRM Foundation module, but such dependencies are not explicitly listed in the provided metadata.

  • Table: JTF_RS_ROLE_RELATE_AUD 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_RS_ROLE_RELATE_AUD,  object_name:JTF_RS_ROLE_RELATE_AUD,  status:VALID,  product: JTF - CRM Foundation ,  description: Base Table which stores audit information for a Role Relation. ,  implementation_dba_data: JTF.JTF_RS_ROLE_RELATE_AUD , 

  • Table: JTF_RS_ROLE_RELATE_AUD 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_RS_ROLE_RELATE_AUD,  object_name:JTF_RS_ROLE_RELATE_AUD,  status:VALID,  product: JTF - CRM Foundation ,  description: Base Table which stores audit information for a Role Relation. ,  implementation_dba_data: JTF.JTF_RS_ROLE_RELATE_AUD , 

  • Table: JTF_RS_ROLE_RELATIONS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_RS_ROLE_RELATIONS,  object_name:JTF_RS_ROLE_RELATIONS,  status:VALID,  product: JTF - CRM Foundation ,  description: This table stores the association between resources and roles. Primary key is Resource_id and Role_id. Each resource can be assigned to multiple roles. ,  implementation_dba_data: JTF.JTF_RS_ROLE_RELATIONS , 

  • Table: JTF_RS_ROLE_RELATIONS 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_RS_ROLE_RELATIONS,  object_name:JTF_RS_ROLE_RELATIONS,  status:VALID,  product: JTF - CRM Foundation ,  description: This table stores the association between resources and roles. Primary key is Resource_id and Role_id. Each resource can be assigned to multiple roles. ,  implementation_dba_data: JTF.JTF_RS_ROLE_RELATIONS ,