ORA-00904: invalid identifier Error Running Data Model Upload (Doc ID 1930019.1)

Last updated on JULY 05, 2017

Applies to:

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

Symptoms

On OFSAAI 7.3.4.0.0, after making changes to a couple of data types of columns and running the data model upload, it is failing with the following errors:

ERROR

Altering the Columns for the table fsi_d_investments_vw.sql
fsi_d_investments_vw.sql---------Error while executing Update :Failed Executing Query. Reason: ORA-00904: "CUR_TP_PER_ADB": invalid identifier
Inside the Rollback Segment
Number of Exec Statements = 69

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