My Oracle Support Banner

RTI_VIR_PHY_TBL_NAME does not exist error during 8.1.1 upgrade (Doc ID 2758593.1)

Last updated on MARCH 14, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

While upgrading from 8.1 to 8.1.1 below error can be seen in the Update.log

Log [2021-02-21 16:11:56.122] [OFSAAIUPDATE] [DEBUG] - Error while executing - create or replace view RTI_VIR_PHY_TBL_NAME ASselect * from ofsaaconf.RTI_VIR_PHY_TBL_NAME

Log [2021-02-21 16:11:56.122] [OFSAAIUPDATE] [DEBUG] - ORA-00942: table or view does not existLog [2021-02-21 16:12:03.113] [OFSAAIUPDATE] [DEBUG] - Executing script atomic_8.1.1.0.0.sql for database User : ofsasbx2

Log [2021-02-21 16:12:05.692] [OFSAAIUPDATE] [ERROR] - Exception while executing the query - create or replace view RTI_UI_EXCLUDE_PDM_LIST AS

select N_EX_TABLE_ID,V_EX_TABLE_NAME,V_INFODOM from ofsaaconf.RTI_UI_EXCLUDE_PDM_LIST

java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8.jar:19.3.0.0.0]

 

 

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


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