My Oracle Support Banner

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

Last updated on MARCH 01, 2023

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

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


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