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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms