My Oracle Support Banner

Unable To Create Audit Trail Shadow Table After Running The Submit Request (Doc ID 560156.1)

Last updated on JULY 13, 2020

Applies to:

Oracle Customers Online - Version 11.5.10 to 11.5.10.3 [Release 11.5]
Information in this document applies to any platform.

Symptoms

On 11.5.10 in Production:
When attempting to audit HZ_PERSON_PROFILES table, the following error occurs.

ERROR
the shadow table HZ_PERSON_PROFILES_A is not created.

EXPECTED BEHAVIOR
Expect to create the shadow table HZ_PERSON_PROFILES_A

STEPS
The issue can be reproduced at will with the following steps:
1. System profile option "AuditTrail:Activate" is set to "Yes" at Site level.

2. In Security-> Audit Trail ->Groups
Application Name-Customers Online
Audit Group- Test_Group
Group State- Enabled
User Table Name- HZ_PERSON_PROFILES

3. In Security-> Audit Trail ->Installation
Oracle Username- APPS
Description- APPS #1 Account

4. In Security-> Audit Trail ->Tables
User Table Name-HZ_PERSON_PROFILES
Table Name-HZ_PERSON_PROFILES
Application - Receivables
Description-Detailed information about people
and the Column name that we want to audit.

5. Navigation: Requests-> Run->Select a single request
In Submit Request form,Name-AuditTrail Update Tables
Then submit the request.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.