My Oracle Support Banner

'ORA-00942 table or view does not exist' on REV_TAB_CONSTRAINT_COLUMNS Upgrading to 8.0.4 (Doc ID 2283579.1)

Last updated on MARCH 27, 2019

Applies to:

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


When upgrading from Oracle Financial Services Profitability Management (PFT) 8.0 to 8.0.4, you get the following error when executing the Model_Prescripts_804.sql script as described in #9 under '1.2.1 Installing OFS Profitability Application Pack':

ORA-00942 table or view does not exist on REV_TAB_CONSTRAINT_COLUMNS

This table does not exist in 8.0.


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

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