Flexfield View Generator When Processing Extra Person Information Descriptive Flexfield Errors With: ORA-00904: : invalid identifier do_array_ddl(APPLSYS, PER, 2, 1, 517, PER_ASSIGNMENT_EXTRA_INFO1_DFV) (Doc ID 1526409.1)

Last updated on NOVEMBER 18, 2016

Applies to:

Oracle Human Resources - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to run the concurrent program Flexfield View Generator for Extra Person Information Descriptive Flexfield
the following error occurs:

Oracle error 904: ORA-00904: : invalid identifier
ORA-06512: at "SYSTEM.AD_DDL", line 2086
ORA-06512: at line 1 has been detected in afuddl() [6_xad].
do_array_ddl(APPLSYS, PER, 2, 1, 517, PER_ASSIGNMENT_EXTRA_INFO1_DFV): private_do_array_ddl(APPS, APPLSYS, HR, 2, 1, 517, PER_ASSIGNMENT_EXTRA_INFO1_DFV):
do_array_c_view(0, APPS, PER_ASSIGNMENT_EXTRA_INFO1_DFV, 1, 517): array_assign_and_execute(APPS, 1, 517, FALSE):
: do_apps_array_ddl(APPS, 1, 517, FALSE): : substr($statement$,1,255)='CREATE OR REPLACE VIEW PER_ASSIGNMENT_EXTRA_INFO1_DFV
(ROW_ID, "CONTEXT", Age, Adjusted_Service_Date, Original_Hire_Date, Payroll_Changed, Original_Payroll, Salary, Original_Person_Type, Termination_Date, Termination_Reason, Leave_Of_Absence_Date, Abse'
CREATE OR REPLACE VIEW PER_ASSIGNMENT_EXTRA_INFO1_DFV
AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE
FROM SYS.DUAL

 


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