FDFVGN: Flexfield View Generator - Oracle Error 905: ORA-00905: Missing Keyword

(Doc ID 789358.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

Oracle General Ledger - Version 11.5 to 11.5.10.2 [Release 11.5.0 to 11.5.10]
Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 27-Feb-2012***
Executable:FDFVGN - Flexfield View Generator

Symptoms

When attempting to compile the flexfield, Flexfield View Generator resulted into the following error:

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'




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