My Oracle Support Banner

ORA-00904 and ORA-00942 Errors Occurring in OFS_PFT_patch_installation.log After PFT Upgrade to 8.0.4 (Doc ID 2541047.1)

Last updated on AUGUST 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)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Enterprise Performance Management (EPM)

Goal

There are ORA-00904 and ORA-00942 errors occurring in OFS_PFT_patch_installation.log after OFSAA upgrade to 8.0.4:

[Sat 13/4/2019 01:54:52] [OFS_PFT] [ INFO] - Executing file:/opt/ofsaa/ofsa/scripts/atomic/insert/fcas_fts_fccs_dimensions_default.sql

[Sat 13/4/2019 01:54:56] [OFS_PFT] [ERROR] - Query:'--SEC_POOL_MASTER
DECLARE
flag NUMBER(5);
v_sql VARCHAR2(25000);

BEGIN

...
IF flag = 1 THEN
execute immediate(v_sql);
END IF;
END;'
Error:ORA-00904: "F_FIDUCIARY_PORTFOLIO_IND": invalid identifier
ORA-06512: at line 40
...
[Sat 13/4/2019 01:55:19] [OFS_PFT] [ INFO] - Executing file:/opt/ofsaa/ofsa/scripts/atomic/create/dm_mv_ccentral.sql
[Sat 13/4/2019 01:55:19] [OFS_PFT] [ERROR] - Query:'CREATE OR REPLACE VIEW RPT_VW_CUSTOMER AS
SELECT DIM_DATES.n_date_skey,
-1 AS n_run_skey,
DIM_CUSTOMER.n_cust_skey,
FCT_COMMON_CUSTOMER_SUMMARY.n_cust_type_skey AS n_cust_type_skey,
...
[Sat 13/4/2019 01:55:23] [OFS_PFT] [ INFO] - Executing file:/opt/ofsaa/ofsa/scripts/atomic/insert/dim_position_type.sql
[Sat 13/4/2019 01:55:23] [OFS_PFT] [ERROR] - Query:'CALL FSI_CREATE_SEQUENCE('SEQ_DIM_POSITION_TYPE','DIM_POSITION_TYPE','N_POSITION_TYPE_SKEY')'
Error:ORA-00942: table or view does not exist
ORA-06512: at "INFOBANK.FSI_CREATE_SEQUENCE", line 5

[Sat 13/4/2019 01:55:23] [OFS_PFT] [ERROR] - Query:'MERGE INTO DIM_POSITION_TYPE T
...
[Sat 13/4/2019 01:55:23] [OFS_PFT] [ INFO] - # of statements executed: 0
[Sat 13/4/2019 01:55:23] [OFS_PFT] [ INFO] - Executing file:/opt/ofsaa/ofsa/scripts/atomic/insert/scd-430-dim_position_type-stg_position_type_master.sql
[Sat 13/4/2019 01:55:23] [OFS_PFT] [ERROR] - Query:'CALL FSI_CREATE_SEQUENCE('SEQ_DIM_POSITION_TYPE','DIM_POSITION_TYPE','N_POSITION_TYPE_SKEY')'
Error:ORA-00942: table or view does not exist
ORA-06512: at "INFOBANK.FSI_CREATE_SEQUENCE", line 5

[Sat 13/4/2019 01:55:23] [OFS_PFT] [ INFO] - # of errors in file=1
...
[Sat 13/4/2019 01:55:51] [OFS_PFT] [ INFO] - Atomic Scripts
[Sat 13/4/2019 01:55:51] [OFS_PFT] [ INFO] - Executing file:/opt/ofsaa/ofsa/scripts/atomic/insert/dm_postscripts_804.sql
[Sat 13/4/2019 01:55:51] [OFS_PFT] [ERROR] - Query:'insert into FSI_IRC_TS_PARAM_HIST select * from FSI_IRC_TS_PARAM_HIST_BKP'
Error:ORA-00942: table or view does not exist

[Sat 13/4/2019 01:55:51] [OFS_PFT] [ERROR] - Query:'Drop table FSI_IRC_TS_PARAM_HIST_BKP'
Error:ORA-00942: table or view does not exist

[Sat 13/4/2019 01:55:51] [OFS_PFT] [ INFO] - # of errors in file=2
[Sat 13/4/2019 01:55:51] [OFS_PFT] [ INFO] - # of statements executed: 0
[Sat 13/4/2019 01:55:51] [OFS_PFT] [ INFO] - Sandbox Scripts


According to the guide, these errors are not in the ignore list. After the upgrade, have also tried to perform object migration with some Data Quality (DQ) objects and noticed that DQ_CHECK_MASTER is missing the V_BASE_ENTITY_TYPE column. Is this related to the upgrade errors?

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


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