FTP 8.1.1.0.0 Installation Fails With "Error:ORA-00904: "T"."V_ADJUSTMENT_TYPE": invalid identifier"
(Doc ID 2928687.1)
Last updated on FEBRUARY 27, 2023
Applies to:
Oracle Financial Services Funds Transfer Pricing - Version 8.1.1 and laterInformation in this document applies to any platform.
Oracle Financial Services Funds Transfer Pricing - FTP
Oracle Financial Services Enterprise Performance Management - EPM
Oracle Financial Services Analytical Application Infrastructure - OFSAAI
Oracle Financial Services Profitability Management - PFT
Oracle Financial Services Asset Liability Management - ALM
Symptoms
FTP 8.1.1.0.0 installation has multiple ORA-00904 errors in the log:
ERROR
-----------------------
[23-12-22 13:17:30,506 IST PM] [ERROR] Query:create table FSI_M_REP_PORTFOLIO_MASTER...
Error:Object already exists
[23-12-22 13:17:30,512 IST PM] [ERROR] Query:alter table FSI_M_REP_PORTFOLIO_MASTER...
Error:Table already has a primary key
[23-12-22 13:17:30,517 IST PM] [ERROR] Query:alter table FSI_M_REP_PORTFOLIO_MASTER...
Error:Table already has a referential constraint with same name
[23-12-22 13:17:30,517 IST PM] [INFO ] # statements executed: 0 , time consumed in milliseconds: 14
..............
[23-12-22 13:17:25,826 IST PM] [ERROR] Query:DECLARE...
Error:ORA-00904: "T"."V_ADJUSTMENT_TYPE": invalid identifier
ORA-06512: at line 420
[23-12-22 13:17:25,827 IST PM] [INFO ] # statements executed: 2 , time consumed in milliseconds: 8034
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 |
| References |