R12: OIE: FDFVGN (Flexfield View Generator) ORA-00907: missing right parenthesis
(Doc ID 2309751.1)
Last updated on OCTOBER 07, 2024
Applies to:
Oracle Internet Expenses - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
After changing some IEX flexfields the Flexfield View Generator Error with the following:
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
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |