R12: AP: GN: Flexfield View Generator Program Completing With Error : ORA-00907: Missing Right Parenthesis

(Doc ID 2388315.1)

Last updated on APRIL 18, 2018

Applies to:

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

Symptoms

 Flexfield view generator triggered after freezing & compiling expense report lines DFF. Below is the error it shows. I'm attaching copy of log file.

Oracle error 907: ORA-00907: missing right parenthesis
ORA-06512: at "SYSTEM.AD_DDL", line 2086
ORA-06512: at line 1 has been detected in afuddl() [6_xad].
do_array_ddl(APPLSYS, SQLAP, 2, 1, 218, AP_EXPENSE_REPORT_LINES_AL_DFV): private_do_array_ddl(APPS, APPLSYS, AP, 2, 1, 218, AP_EXPENSE_REPORT_LINES_AL_DFV): do_array_c_view(1, APPS, AP_EXPENSE_REPORT_LINES_AL_DFV, 1, 218): array_assign_and_execute(APPS, 1, 218, FALSE): : do_apps_array_ddl(APPS, 1, 218, FALSE): : substr($statement$,1,255)='CREATE OR REPLACE VIEW AP_EXPENSE_REPORT_LINES_AL_DFV
(ROW_ID, "EXPENSE_TYPE", PROJECT_SOURCE, PROJECT_CODE, NO_OF_GIFTS, TYPE_OF_GIFT, COMPLIANCE_APPROVAL, BUSINESS_PURPOSE, TYPE_OF_COST, FACE_VALUE, TYPE_OF_PARKING, EYE_TEST, EYE_GLASSES, CAR_REGISTR'
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

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