My Oracle Support Banner

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

Last updated on JUNE 14, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

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.

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.