Flexfield View Generator for Extra Person Information Descriptive Flexfield Errors with: ORA-00904: Invalid Identifier do_array_ddl(APPLSYS, PER, 2, 1, 490, PER_PEOPLE_EXTRA_INFO1_DFV)
(Doc ID 1282319.1)
Last updated on MARCH 20, 2025
Applies to:
Oracle Human Resources - Version 11.5.10.2 and laterInformation in this document applies to any platform.
Symptoms
When compiling Extra Person Information descriptive flexfield, the following error occurs:
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, 490, PER_PEOPLE_EXTRA_INFO1_DFV): private_do_array_ddl(APPS, APPLSYS, HR, 2, 1, 490, PER_PEOPLE_EXTRA_INFO1_DFV): do_array_c_view(0, APPS, PER_PEOPLE_EXTRA_INFO1_DFV, 1, 490): array_assign_and_execute(APPS, 1, 490, FALSE): : do_apps_array_ddl(APPS, 1, 490, 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'
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, 490, PER_PEOPLE_EXTRA_INFO1_DFV): private_do_array_ddl(APPS, APPLSYS, HR, 2, 1, 490, PER_PEOPLE_EXTRA_INFO1_DFV): do_array_c_view(0, APPS, PER_PEOPLE_EXTRA_INFO1_DFV, 1, 490): array_assign_and_execute(APPS, 1, 490, FALSE): : do_apps_array_ddl(APPS, 1, 490, 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'
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 |