Can "Skipping below sql files from execution" Warnings Be Ignored While Installing OIDF 8.1 (Doc ID 2728324.1)

Last updated on JULY 31, 2023

Applies to:

Goal

The following two questions have come up during new installation of OIDF 8.1:

Question 1: This is a fresh installation. As part of the installation there is a step to apply one patch (OIDF Data Model <Patch 31924513>) which is having the model upgrade. But that patch is giving error as pasted below.

Error while executing - DECLARE EXS NUMBER(5); flg varchar2(3); Z EXCEPTION; Z1 EXCEPTION; BEGIN select count(*) INTO EXS from util_configuration where V_APP_ID='OFS_OIDF' AND V_PATCH_NAME ='8.1.0.0.0'; IF EXS = 1 THEN select is_exec_flag into flg from util_status where app_id = 'OFS_OIDF'; if flg = 'N' then PRESCRIPT_SCD_METADATA_DEL_810;PRESCRIPT_DQ_METADATA_DEL_810;RESTORE_SPECIFIC_TBLS_810;RESTORE_DROPPED_TBLS_COLS_810;RESTORE_SCD_METADATA_810;RESTORE_DQ_METADATA_810;update util_status set is_exec_flag = 'Y', exec_time = sysdate where app_id = 'OFS_OIDF';EXECUTE IMMEDIATE 'DROP PROCEDURE PREPARE_CUSTM_TBL_810';EXECUTE IMMEDIATE 'DROP PROCEDURE PRESCRIPT_DEFAULT_VALUES_810';EXECUTE IMMEDIATE 'DROP PROCEDURE prescript_drop_tbles_810';EXECUTE IMMEDIATE 'DROP PROCEDURE PRESCRIPT_DROP_COLUMNS_810';EXECUTE IMMEDIATE 'DROP PROCEDURE PRESCRIPT_SCD_METADATA_BKP_810';EXECUTE IMMEDIATE 'DROP PROCEDURE PRESCRIPT_DQ_METADATA_BKP_810';EXECUTE IMMEDIATE 'DROP PROCEDURE PRESCRIPT_SCD_METADATA_DEL_810';EXECUTE IMMEDIATE 'DROP PROCEDURE PRESCRIPT_DQ_METADATA_DEL_810';EXECUTE IMMEDIATE 'DROP PROCEDURE RESTORE_DROPPED_TBLS_COLS_810';EXECUTE IMMEDIATE 'DROP PROCEDURE RESTORE_SPECIFIC_TBLS_810';EXECUTE IMMEDIATE 'DROP PROCEDURE RESTORE_SCD_METADATA_810';EXECUTE IMMEDIATE 'DROP PROCEDURE RESTORE_DQ_METADATA_810';else RAISE Z1; end if;else raise Z; end if; for x in (SELECT TABLE_NAME FROM REV_TABLES_B WHERE TABLE_NAME in (SELECT TABLE_NAME FROM DROPPED_DATAELEMENTS_CUSTOMIZATION_81 WHERE COLUM_NAME IS NULL)) loop UPDATE DROPPED_DATAELEMENTS_CUSTOMIZATION_81 SET RETAIN_AS_CUSTOMIZATION='Y' WHERE TABLE_NAME = ''||X.TABLE_NAME||'' AND COLUM_NAME IS NULL; end loop;COMMIT;for x in (SELECT TABLE_NAME, COLUMN_NAME FROM REV_TAB_COLUMNS WHERE TABLE_NAME || '.' || COLUMN_NAME IN ( SELECT TABLE_NAME || '.' || COLUM_NAME FROM DROPPED_DATAELEMENTS_CUSTOMIZATION_81 WHERE COLUM_NAME IS NOT NULL)) loop UPDATE DROPPED_DATAELEMENTS_CUSTOMIZATION_81 SET RETAIN_AS_CUSTOMIZATION='Y' WHERE TABLE_NAME = ''||X.TABLE_NAME||'' AND COLUM_NAME = ''||X.COLUMN_NAME||''; end loop;COMMIT;MERGE INTO FSI_MESSAGE_LOG T USING (SELECT 200 PROCESS_ID, 1 SEQUENCES, SYSDATE MSG_TIMESTAMP, 20015 MESSAGE_CD,'Tables/Columns with RETAIN_AS_CUSTOMIZATION value as Y are the customized data elements in table DROPPED_DATAELEMENTS_CUSTOMIZATION_81, please validate' CONTEXT_SPECIFIC_TEXT FROM DUAL) SON (T.PROCESS_ID = S.PROCESS_IDAND T.CONTEXT_SPECIFIC_TEXT = S.CONTEXT_SPECIFIC_TEXT)WHEN NOT MATCHED THENINSERT (PROCESS_ID, SEQUENCES, MSG_TIMESTAMP, MESSAGE_CD, CONTEXT_SPECIFIC_TEXT) VALUES (S.PROCESS_ID, S.SEQUENCES, S.MSG_TIMESTAMP, S.MESSAGE_CD, S.CONTEXT_SPECIFIC_TEXT); exception when z then MERGE INTO FSI_MESSAGE_LOG T USING (SELECT 200 PROCESS_ID, 1 SEQUENCES, SYSDATE MSG_TIMESTAMP, 20014 MESSAGE_CD,'8.1 Installation is not happnened properly after Pre Script execution as part of offline utility, please check' CONTEXT_SPECIFIC_TEXT FROM DUAL) SON (T.PROCESS_ID = S.PROCESS_IDAND T.CONTEXT_SPECIFIC_TEXT = S.CONTEXT_SPECIFIC_TEXT)WHEN NOT MATCHED THENINSERT (PROCESS_ID, SEQUENCES, MSG_TIMESTAMP, MESSAGE_CD, CONTEXT_SPECIFIC_TEXT) VALUES (S.PROCESS_ID, S.SEQUENCES, S.MSG_TIMESTAMP, S.MESSAGE_CD, S.CONTEXT_SPECIFIC_TEXT);WHEN Z1 THEN MERGE INTO FSI_MESSAGE_LOG T USING (SELECT 200 PROCESS_ID, 1 SEQUENCES, SYSDATE MSG_TIMESTAMP, 20013 MESSAGE_CD,'PostScripts are already Executed. Please update is_exec_flag to N of util_status table to execute Post Scrip again' CONTEXT_SPECIFIC_TEXT FROM DUAL) SON (T.PROCESS_ID = S.PROCESS_IDAND T.CONTEXT_SPECIFIC_TEXT = S.CONTEXT_SPECIFIC_TEXT)WHEN NOT MATCHED THENINSERT (PROCESS_ID, SEQUENCES, MSG_TIMESTAMP, MESSAGE_CD, CONTEXT_SPECIFIC_TEXT) VALUES (S.PROCESS_ID, S.SEQUENCES, S.MSG_TIMESTAMP, S.MESSAGE_CD, S.CONTEXT_SPECIFIC_TEXT);WHEN OTHERS THEN if sqlcode != -4043 then raise; end if; COMMIT; COMMIT; END;
ORA-06550: line 8, column 32:
PL/SQL: ORA-00942: table or view does not exist

Is there any action to be taken to fix above error when applying <Patch 31924513> for a new installation?
 
Question 2 : Can the following error message while performing the installation on OIDF can be ignored:

[17-10-20 03:43:16,960 EST AM] [WARN ] SYSADMN has failed to create FIV Stage path on the webserver OFSAAINFO

[17-10-20 05:45:00,787 EST AM] [WARN ] **** Skipping below sql files from execution... ***
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_FSI_EXCHANGE_RATES.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_COMMODITIES_CAS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_CREDIT_DERIVATIVES_CAS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_INVESTMENTS_CAS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_LOANS_CAS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_MM_CAS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_MUTUAL_FUNDS_CAS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_REPO_CONTRACTS_CAS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_TRUSTS_CAS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_COMMODITIES_TXNS_FTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_CREDIT_DERIVATIVES_TXNS_FTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_INVESTMENT_TXNS_FTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_LOAN_CONTRACT_TXNS_FTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_MM_TXNS_FTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_MUTUAL_FUNDS_TXNS_FTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_REPO_TRANSACTIONS_FTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_STG_TRUSTS_TXNS_FTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_FCT_MGMT_REPORTING_STG_GL_DATA.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_FFSIS_STG_TRUSTS.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/DM_T2T_FCT_MGMT_REPORTING_STG_GL_DATA.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] - config/insert/commonapps_core_forms_locale_en_us.sql
[17-10-20 05:45:00,787 EST AM] [INFO ] **** End of skipping sql files from execution... ***

[17-10-20 05:59:34,381 EST AM] [WARN ] **** Skipping below sql files from execution... ***
[17-10-20 05:59:34,381 EST AM] [INFO ] - atomic/create/dt_buss_day_calc.sql
[17-10-20 05:59:34,381 EST AM] [INFO ] - atomic/create/VW_FSI_RATE_TRIANGULATION.sql
[17-10-20 05:59:34,381 EST AM] [INFO ] - atomic/create/fsi_create_sequence.sql
[17-10-20 05:59:34,381 EST AM] [INFO ] - atomic/create/fsi_messages.sql
[17-10-20 05:59:34,381 EST AM] [INFO ] - atomic/insert/DQCUSTACCT0003_STG_BORROWING_COMMITMENTS_N_UNDRAWN_AMT.sql
[17-10-20 05:59:34,381 EST AM] [INFO ] - atomic/insert/DQCUSTACCT0017_STG_LEASES_CONTRACTS_V_LV_CODE.sql

Solution

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