My Oracle Support Banner

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

Last updated on JUNE 16, 2022

Applies to:

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


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.

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;

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.


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

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