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 MAY 24, 2023

Applies to:

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

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