FDFVGN: Compile Flexfield Errors in Flexfield View Generator - Oracle error 905: ORA-00905: missing keyword (Doc ID 789358.1)

Last updated on MARCH 19, 2023

Applies to:

Symptoms

When attempting to Accounting Flexfield (or any other Flexfield), the Flexfield View Generator program triggered is showing error in the Log File.

ERROR

Oracle error 905: ORA-00905: missing keyword
ORA-06512: at "SYSTEM.AD_DDL", line 165
ORA-06512: at line 1 has been detected in afuddl() [3_xdd].
do_ddl(APPLSYS, SQLGL, 2, $statement$, CUSTOM AFF): private_do_ddl(APPS, APPLSYS, GL, 2, $statement$, CUSTOM AFF): do_cd_view(0, APPS, 2, CUSTOM AFF, $statement$): : do_apps_ddl(APPS, $statement$): : substr($statement$,1,255)='CREATE OR REPLACE VIEW CUSTOM AFF
(ROW_ID, CODE_COMBINATION_ID, Company, COST, Account, GL_ACCOUNT_TYPE, GL_CONTROL_ACCOUNT, RECONCILIATION_FLAG, DETAIL_BUDGETING_ALLOWED, DETAIL_POSTING_ALLOWED, REFERENCE2, SEGMENT_ATTRIBUTE37, SEGMENT_ATTRIBUTE14, LAS'
Oracle error 905: ORA-00905: missing keyword
ORA-06512: at "SYSTEM.AD_DDL", line 165
ORA-06512: at line 1 has been detected in afuddl() [3_xdd].
do_ddl(APPLSYS, SQLGL, 2, $statement$, CUSTOM AFF): private_do_ddl(APPS, APPLSYS, GL, 2, $statement$, CUSTOM AFF): do_cd_view(0, APPS, 2, CUSTOM AFF, $statement$): : do_apps_ddl(APPS, $statement$): : substr($statement$,1,255)='CREATE OR REPLACE VIEW CUSTOM AFF 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:

1. System Administrator Responsibility -> Application -> Flexfield -> Key -> Segments or

General Ledger Responsibility -> Setup -> Financials -> Flexfields -> Key -> Segments;

2. Query for your Flexfield;

3. Select it -> Click on 'Compile' button;

4. View -> Requests -> Find -> See a Concurrent Program has been triggered (FDFVGN: Flexfield View Generator);

5. Observe the error in it's Log File;

Cause