FDFVGN: Flexfield View Generator ORA-00907: missing right parenthesis

(Doc ID 2309751.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

Oracle Internet Expenses - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

After changing some IEX flexfields the Flexfield View Generator Errors

 

FDFVGN: Flexfield View Generator
+---------------------------------------------------------------------------+

....

Oracle error 907: ORA-00907: missing right parenthesis
ORA-06512: at "SYSTEM.AD_DDL", line 188
ORA-06512: at line 1 has been detected in afuddl() [3_xdd].
do_ddl(APPLSYS, SQLAP, 2, $statement$, AP_EXPENSE_REPORT_LINES_AL_DFV): private_do_ddl(APPS, APPLSYS, AP, 2, $statement$, AP_EXPENSE_REPORT_LINES_AL_DFV): do_cd_view(1, APPS, 2, AP_EXPENSE_REPORT_LINES_AL_DFV, $statement$): : do_apps_ddl(APPS, $statement$): : substr($statement$,1,255)='CREATE OR REPLACE VIEW AP_EXPENSE_REPORT_LINES_AL_DFV
(ROW_ID, "EXPENSE_TYPE", Place_of_Parking, Licensed__MOT__Insured_Vehicle, This_was_a_Temporary_Location, Authorised_Police_Business_, Public_Transport_Unavailable, Authoriser__Full_Name_, Glasses_f'
CREATE OR REPLACE VIEW AP_EXPENSE_REPORT_LINES_AL_DFV
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