Search Results jtf_rs_groups_audit_s

Overview

JTF_RS_GROUPS_AUD_PVT is a private (PVT-classified) PL/SQL package body in the APPS schema that implements the audit-trail logic for the Resource Manager group entity within Oracle E-Business Suite's CRM Foundation (JTF) module. Its name follows the standard EBS audit naming convention: JTF_RS identifies the Resource Manager group object family, GROUPS identifies the specific entity, and AUD denotes the auditing variant. The package body provides the internal implementation that records and maintains historical snapshots of resource group definitions whenever those definitions are created, modified, or removed. In EBS 12.1.1 and 12.2.2, this audit mechanism supports compliance, troubleshooting, and reporting requirements by preserving a chronological record of changes made to resource groups, which are used to organize sales, service, and field personnel across the CRM application stack.

Key Procedures and Functions

The documented API exposes three procedures, consistent with the standard insert/update/delete triad used across EBS audit packages:

• INSERT_GROUP — Records a new audit entry when a resource group is initially created, capturing the effective attributes of the group at its point of origin.
• UPDATE_GROUP — Writes a new audit row reflecting the revised state of a group after a change is applied, enabling before-and-after comparison across the audit history.
• DELETE_GROUP — Logs the removal of a group so that historical records survive the logical or physical deletion of the base row.

As the package is classified PVT, these procedures are intended for invocation by the companion public package JTF_RS_GROUPS_AUD_PKG rather than directly by external consumers. No parameter lists are documented, and callers should consult the public wrapper signature.

Tables Accessed

The package body references four tables through APPS synonyms:

• JTF_RS_GROUPS_AUDIT_S — The audit sequence, supplying surrogate keys for each historical audit record. The user's search term "jtf_rs_groups_audit_s" corresponds directly to this sequence.
• JTF_RS_GROUPS_AUD_B — The base audit table holding the historical snapshot records written by the INSERT, UPDATE, and DELETE procedures.
• JTF_RS_GROUPS_B — The base transactional table for resource groups, read to obtain current attribute values for auditing and to validate the group being processed.
• DUAL — Used for singleton SQL evaluations, typically to retrieve sequence values or profile settings.

Additional dependencies include FND_API, FND_MESSAGE, FND_MSG_PUB, and FND_PROFILE for error handling, message stack management, and profile-option-driven behavior, plus JTF_RS_GROUPS_VL for the translated view of group definitions.

Usage Notes

Because JTF_RS_GROUPS_AUD_PVT is a private package and is not referenced by any other database object, it is not designed as a standalone integration point. It is invoked indirectly through JTF_RS_GROUPS_AUD_PKG, which itself is driven by the Resource Manager group maintenance forms and related business logic in the CRM Foundation. Administrators and developers should not call the PVT procedures directly; doing so bypasses the public wrapper's validation and message handling. Typical invocation paths include the Resource Manager administrative UI when users create or modify groups, and any concurrent or custom program that legitimately routes group changes through the public audit package. Since the private body is marked VALID, it is available for dependency review via the data dictionary, but customization is discouraged. Organizations auditing group changes for compliance should query JTF_RS_GROUPS_AUD_B directly for reporting, joining to JTF_RS_GROUPS_B and JTF_RS_GROUPS_VL as needed.