ORA-00904 When Compiling Flexfield "Extra Assignment Information" (Doc ID 2028917.1)

Last updated on DECEMBER 11, 2023

Applies to:

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

Symptoms

Problem Statement:

When attempting to compile the flexfield, the following error occurs.

Sample error message:

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, 717, PER_ASSIGNMENT_EXTRA_INFO1_DFV): private_do_array_ddl(APPS, APPLSYS, HR, 2, 1, 717, PER_ASSIGNMENT_EXTRA_INFO1_DFV): do_array_c_view(0, APPS, PER_ASSIGNMENT_EXTRA_INFO1_DFV, 1, 717): array_assign_and_execute(APPS, 1, 717, FALSE): : do_apps_array_ddl(APPS, 1, 717, FALSE): : substr($statement$,1,255)='CREATE OR REPLACE VIEW PER_ASSIGNMENT_EXTRA_INFO1_DFV
(ROW_ID, "CONTEXT", Pay_Basis, Rate, Annual_Salary, Gross_Pay_YTD, Tax_Free_Threshold, HELP, SFSS, Tax_Variation_Type, Tax_Variation_Amount, Termination_Date, Termination_Type, Death_Benefit_Type, R'
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

Steps to Reproduce:

The issue can be reproduced at will with the following steps: