Errors Creating Views Like FCT_LR_CB_BASE_V During ALMBI 6.1 Install (Doc ID 1563836.1)

Last updated on APRIL 16, 2015

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Asset Liability Management Analytics (ALMBI) 6.1, when running the ALMBI 6.1 install, you receive multiple ORA-00942 errors when creating the following views:

FCT_LR_CB_BASE_V
FCT_LR_CB_CONS_V
FCT_LR_CB_CONS_LCY_V

The following errors are in the installation log:

[Mon  17/6/2013 06:18:22] [OFSALMBI] [DEBUG] - ===>Executing file:/app/ofsaai/scripts/atomic/create/FCT_LR_CB_BASE_V.sql
[Mon  17/6/2013 06:18:22] [OFSALMBI] [ERROR] - Query:'CREATE OR REPLACE VIEW FCT_LR_CB_BASE_V AS
.
.
.
Error:ORA-00942: table or view does not exist

[Mon  17/6/2013 06:18:22] [OFSALMBI] [DEBUG] - ===>Executing file:/app/ofsaai/scripts/atomic/create/FCT_LR_CB_CONS_V.sql
[Mon  17/6/2013 06:18:22] [OFSALMBI] [ERROR] - Query:'CREATE OR REPLACE VIEW FCT_LR_CB_CONS_V AS
.
.
.
Error:ORA-00942: table or view does not exist

[Mon  17/6/2013 06:18:22] [OFSALMBI] [DEBUG] - ===>Executing file:/app/ofsaai/scripts/atomic/create/FCT_LR_CB_CONS_LCY_V.sql
[Mon  17/6/2013 06:18:22] [OFSALMBI] [ERROR] - Query:'CREATE OR REPLACE VIEW FCT_LR_CB_CONS_LCY_V AS
.
.
.
Error:ORA-00942: table or view does not exist


The errors prevent the views from getting created during the ALMBI installation.

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