Unable To Enable Audit Trail On FND_USER_RESP_GROUPS (Doc ID 358058.1)

Last updated on JUNE 24, 2016

Applies to:

Oracle Application Object Library - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
EXECUTABLE:FNDATUPD - AuditTrail Update Tables
EXECUTABLE:FNDATRPT - AuditTrail Report for Audit Group Validation
FORM:FNDATDAG.FMB - Define Audit Groups
FORM:FNDATDAT.FMB - Define Audit Tables
Checked for relevance on 26-MAY-2010


Symptoms

It is not possible to enable auditing on the FND_USER_RESP_GROUPS table.

FND_USER_RESP_GROUPS is expected to information about the responsibilities assigned to an application user. Each row includes values that identify the user, the responsibility, and the security group. Each row also contains a description and a start date and end date for that responsibility assignment.

Being part of the security model of an Oracle E-Business Suite makes this table a perfect candidate to be including in the Audit Trail setup by performing the following steps:

  1. Login to the application as SYSADMIN
  2. Responsibility: System Administrator
  3. Function: Security --> AuditTrail --> Tables
  4. Query on FND_USER_RESP_GROUPS
  5. Select the required columns for auditing
  6. Save & Close the form
  7. Function: Security --> AuditTrail --> Groups
  8. Add the table to either a new or existing Audit Group
  9. Set the Group State to Enable Requested
  10. Save & Close the form
  11. Run the AuditTrail Update Tables concurrent program

The AuditTrail Update Tables (FNDATUPD) request did not enable auditing on the FND_USER_RESP_GROUPS as a result of these actions and no errors are seen in the request log file. In addition to that, the AuditTrail Report for Audit Group Validation (FNDATRPT) request confirms that the table has not been enabled for auditing.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms