My Oracle Support Banner

Audit Report ORA-00904 PER_ALL_PEOPLE_F_TT Invalid Identifier (Doc ID 1385575.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Running Audit Report, the log files shows

PAYAUDIT module: Audit Report
+---------------------------------------------------------------------------+

Current system time is 13-DEC-2011 14:30:58

+---------------------------------------------------------------------------+


+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
TABLE='PER_ALL_PEOPLE_F'
initialise='R'
P_TEMPLATE_NAME='Not Defined'
------------

APPLLCSP Environment Variable set to :

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
AMERICAN_AMERICA.UTF8

'.,'

Enter Password:
MSG-00001: tmp005:
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-06550: line 1, column 1005:
PL/SQL: ORA-00904: "PER_ALL_PEOPLE_F_TT": invalid identifier
ORA-06550: line 1, column 998:
PL/SQL: SQL Statement ignored
ORA-06550: line 1, column 9030:
PLS-00201: identifier 'PER_ALL_PEOPLE_F_VP' must be declared
ORA-06550: line 1, column 9030:
PL/SQL: Statement ignored
ORA-06550: line 1, column 9180:
PLS-00201: identifier 'PER_ALL_PEOPLE_F_VP' must be declared
ORA-06550: line 1, column 9180:
PL/SQL: Statement ignored

REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: MSG-00001: tmp005:
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-06550: line 1, column 1005:
PL/SQL: ORA-00904: "PER_ALL_PEOPLE_F_TT": invalid identifier
ORA-06550: line 1, column 998:
PL/SQL: SQL Statement ignored
ORA-06550: line 1, column 9030:
PLS-00201: identifier 'PER_ALL_PEOPLE_F_VP' must be declared
ORA-06550: line 1, column 9030:
PL/SQL: Statement ignored
ORA-06550: line 1, column 9180:
PLS

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
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.