My Oracle Support Banner

Invalid Database Objects Found in OFSAA Application Due to Compilation Errors (Doc ID 2792376.1)

Last updated on JULY 21, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7.2.0 and later
Information in this document applies to any platform.
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Oracle Financial Services Data Governance for US Regulatory Reporting product (DGS)
Oracle Financial Services Institutional Performance Analytics (IPA)

Goal

On OFSAA 8.0.7.2.0 version, below seeded database objects (views, procedures, packages) were found invalid due to following compilation errors:

fn_dt_pop_mob_summ_rpa --> PLS-00201: identifier 'PROC_SEG_MOB_SUMM_POP_RPA' must be declared

PKG_WSVIEW_CUST_ACCT_PROF --> PL/SQL: ORA-00918: column ambiguously defined

PKG_DQ_DASHBOARD_LOADER --> ORA-00942 table or view does not exist

PKG_DQ_CREATE_CONTROL --> ORA-00942 table or view does not exist

PKG_OPERATIONAL_CONTROL --> ORA-00942 table or view does not exist

VW_FSI_DE_DIH_CON_METADATA --> ORA-00942 table or view does not exist

VW_FSI_DE_DIH_EDD_METADATA --> ORA-00942 table or view does not exist

BASE_IRC_RATE_INTERPOLATED TEMP_BASE_VIEW --> ORA-00942 table or view does not exist


Please advise.

Solution

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
Goal
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.