'ORA-00907: Missing Right Parenthesis' Error Running Data Model Upload (Doc ID 1576741.1)

Last updated on MARCH 01, 2023

Applies to:

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure, when you try to upload the OFSAA data model, the process fails with the following error in the Model Upload log in /<ftpshare>/<Infodom>/log:

Creating the table stg_test_table.sql
stg_test_table.sql---------Error while executing Update :Failed Executing Query. Reason: ORA-00907: missing right parenthesis
Inside the Rollback Segment
Number of Exec Statements = 16

In 8.0.x, the following error may also appear:

Altering the Columns for the table tda_cost_volume_txns.sql
tda_cost_volume_txns.sql---------ORA-00906: missing left parenthesis

Inside the Rollback Segment
Number of Exec Statements = 1
Executed altercolumn r_tda_trading_acct_instr.sql successfully on the database

In this case, invalid SQL like the following is generated:
Alter table tda_cost_volume_txns add (as_of_date DATE DEFAULT NULL Null , iso_currency_code VARCHAR2 DEFAULT NULL Not Null , identity_code_chg NUMBER(10,0) DEFAULT NULL Null)

The error causes the Model Upload process to stop before it has uploaded the changes into the Oracle Database.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.