Oracle Financial Services Institutional Performance Analytics 8.1 - Installation Issue (Script Error) (Doc ID 2794482.1)

Last updated on MAY 22, 2023

Applies to:

Oracle Financial Services Institutional Performance Analytics - Version 8.0.0 and later
Information in this document applies to any platform.

While installing IIA 81000 on top of FSDF/DIH/GL 8.1, getting below error in OFS_IPA_installation.err

Error:

[ERROR] ORA-00942: table or view does not exist

[ERROR] CREATE OR REPLACE VIEW OFS_PA_ACCOUNT_METRICS AS

(SELECT (Select N_AS_OF_DATE_SKEY from VW_EXEC_INFO where PARAM_CLASS='PERFORMANCE_ANALYTICS') N_MIS_DATE_SKEY, T1.* FROM MV_PA_ACCOUNT_METRICS T1)

[ERROR] ../OFS_IPA/scripts/atomic/create/OFS_PA_METRICS.sql

[ERROR]

[ERROR] ===================================================================================================

[ERROR] ORA-00942: table or view does not exist

[ERROR]

CREATE OR REPLACE VIEW OFS_PA_CUSTOMER_METRICS AS

(SELECT (Select N_AS_OF_DATE_SKEY from VW_EXEC_INFO where PARAM_CLASS='PERFORMANCE_ANALYTICS') N_MIS_DATE_SKEY, T1.* FROM MV_PA_CUSTOMER_METRICS T1)

[ERROR] ../OFS_IPA/scripts/atomic/create/OFS_PA_METRICS.sql

	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

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