My Oracle Support Banner

FDFVGN: Flexfield View Generator - Oracle Error 905: ORA-00905: Missing Keyword (Doc ID 789358.1)

Last updated on JULY 10, 2019

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]
Oracle Inventory Management - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.
Executable:FDFVGN - Flexfield View Generator




Symptoms

NOTE: In the images/examples above or below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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'




Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.