ORA-00942 on FSI_IRCS and Compilation Errors Running ALM/FTP 5.5 Service Pack Install (Doc ID 1357402.1)

Last updated on SEPTEMBER 23, 2011

Applies to:

Oracle Financial Services Asset Liability Management - Version: 5.5 and later   [Release: 5 and later ]
Oracle Financial Services Funds Transfer Pricing - Version: 5.5 and later    [Release: 5 and later]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When installing the Oracle Financial Services Asset Liability Management (ALM) or Funds Transfer Pricing (FTP) 5.5 Service Pack, you get multiple ORA-00942 errors and package compilation errors in the ALM_xxxxxx.log or FTP_xxxxxxx.log in $FIC_HOME.  You previously had another version of ALM or FTP installed.

Examples of errors:

create or replace view IRCS as select * from FSI_IRCS
*
ERROR at line 1:
ORA-00942: table or view does not exist

"dm_alm_ddl_5.5 for ALM Script Execution - Begin"
insert into FSI_INTEREST_RATES_AUDIT select * from FSI_INTEREST_RATES_AUDIT_5_5
*
ERROR at line 1:
ORA-00942: table or view does not exist

insert into FSI_IRC_RATE_TERMS select * from FSI_IRC_RATE_TERMS_5_5
*
ERROR at line 1:
ORA-00942: table or view does not exist

There are also several object compilation errors in the log:

"FSI IRC Hybrid Merge Linear ALM prc Execution - Begin"

Warning: Procedure created with compilation errors.

"dm_common_ddl_5.5 for ALM Script Execution - Begin"

Warning: Function altered with compilation errors.

Warning: Package Body altered with compilation errors.

Warning: Package altered with compilation errors.

Warning: Procedure altered with compilation errors.

Warning: Procedure altered with compilation errors.

Warning: View altered with compilation errors.


The errors above prevent you from installing ALM and/or FTP successfully.

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