Extra Person Information EIT Compiles with Error: ORA-00904: invalid identifier (Doc ID 436145.1)

Last updated on JULY 19, 2016

Applies to:

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

Symptoms

On 11.5.10.2 in Production:
Add a new context to Extra Person Info% DFF and save for compilation. The DFF compilation gives error.

ERROR

Oracle error 904: ORA-00904: invalid identifier
ORA-06512: at "SYSTEM.AD_DDL", line 2397
ORA-06512: at line 1 has been detected in afuddl() [6_xad].
do_array_ddl(APPLSYS, PER, 2, 1, 376, PER_PEOPLE_EXTRA_INFO1_DFV): private_do_array_ddl(APPS,
APPLSYS, HR, 2, 1, 376, PER_PEOPLE_EXTRA_INFO1_DFV): do_array_c_view(0, APPS,
PER_PEOPLE_EXTRA_INFO1_DFV, 1, 376): array_assign_and_execute(APPS, 1, 376, FALSE): :
do_apps_array_ddl(APPS, 1, 376, FALSE): : substr($statement$,1,255)='CREATE OR REPLACE VIEW
PER_PEOPLE_EXTRA_INFO1_DFV (ROW_ID, "TYPE", GRE, Province, Employment_Code, Language,
Date_Of_Misdemeanour, Date_Of_Hearing, Type_Of_Misdemeanour, Disciplinary_Action,
Disciplinary_Body, Comments, Start_Date, End_Date,
Licence_Nu'
CREATE OR REPLACE VIEW PER_PEOPLE_EXTRA_INFO1_DFV
AS SELECT 'View generation has failed. Check log file for error messages'
VIEW_HAS_FAILED_CHECK_LOG_FILE
FROM SYS.DUAL



STEPS
Add a new context to Extra Person Info% DFF and save for compilation. The DFF compilation gives  error.

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