Standard Audit Report Ends With Error REP-0069: Internal error; (Doc ID 2281925.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

While setting up the Audit Report for PER_ALL_PEOPLE_F table we encounter and error while processing the shadow tables '_A'. We did the same procedures as for the PER_ALL_ASSIGNMENTS_F table and that is working correctly. The PER_ALL_PEOPLE_F is generating the same error and even when we are able to see the shadow tables being populated the Audit Report Process ends in failure.


ERROR
-----------------------
REP-0069: Internal error; REP-1401: 'beforereport': Fatal PL/SQL error occurred; PL/SQL: ORA-00904: "PER_ALL_ASSIGNMENTS_F_TT": invalid identifier; PLS-00201: identifier 'PER_ALL_ASSIGNMENTS_F_VP' must be declared;

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Audit Tables.
2. Set the Audit Groups.
3. Run the Audit Trail Update
4. Run The AuditTrail Process.
5. The error is generated.


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