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

Last updated on JULY 09, 2015

Applies to:

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


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'
AS SELECT 'View generation has failed. Check log file for error messages' VIEW_HAS_FAILED_CHECK_LOG_FILE


Steps to Reproduce:

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

  1. Compile DFF "Extra Assignment Information".
  2. "Flexfield View Generator" prints the error.


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