Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/23.74103_CLOUD_357610_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-06-25 20:01:06 The following directories are used: CMiC Home: "/opt/cm", as specified in /home/oracle/.cms/cms.conf. Oracle Home: "D:/as10g2/midtier", default value. JSP Oracle Home: "/u01/app/oracle/midtierjsp", as specified in /home/oracle/.cms/cms.conf. Mobile Oracle Home: "/u01/app/oracle/midtiermobile", as specified in /home/oracle/.cms/cms.conf. Oracle Client Home: "/u01/app/oracle/product/19.19/PROD", as specified in /home/oracle/.cms/cms.conf. /u01/app/oracle/product/19.19/PROD/jdbc/lib/ojdbc7.jar /u01/app/oracle/product/19.19/PROD/jdbc/lib/ojdbc6.jar /u01/app/oracle/product/19.19/PROD/jdbc/lib/ojdbc8.jar Connection string: jdbc:oracle:oci:da/********@test Warning: Issue 23.74103, has been installed 5 times on the application server while it is installed 0 times on the database! - File: sql/2374103_33.sql: ___________________________ Updating: /opt/cm/v12/test/sql/2374103_33.sql - This is a new file, no information available on disk - size (new file): 11183 bytes - last modified (new file): 2024-06-25 14:37:38.0 - File: sql/2374103_31.sql: ___________________________ Updating: /opt/cm/v12/test/sql/2374103_31.sql - This is a new file, no information available on disk - size (new file): 5868 bytes - last modified (new file): 2024-06-25 14:35:40.0 - File: sql/2374103_32.sql: ___________________________ Updating: /opt/cm/v12/test/sql/2374103_32.sql - This is a new file, no information available on disk - size (new file): 11185 bytes - last modified (new file): 2024-06-25 14:36:46.0 Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-06-25_20_01_07.139/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-06-25_20_01_07.139/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-06-25_20_01_07.139/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 4 The group 0 entry Name Update:2374103_31.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-06-25_20_01_07.139/2374103_31.sql.sh to run 2374103_31.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-06-25_20_01_07.139/2374103_31.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-06-25_20_01_07.139/2374103_31.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jun 25 20:01:18 2024 Version 19.23.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. ************************* * Start of dbdefine.sql * ************************* *********************** * End of dbdefine.sql * *********************** ************************* * Connect as DA * ************************* Connected. *********************** * Connected * *********************** -- ====================================================================== -- Work Order 23.74103, Work Item 31 -- Invoice Format Removing Reports SER_JBINV, SER_JB_C10 -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 23.74103_31.sql Output in 23.74103_31.lst -- ====================================================================== -- ====================================================================== -- Get the initial state of the database -- ====================================================================== BEGIN sys.UTL_RECOMP.recomp_parallel; END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored Session altered. -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 g) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,605 INDEX 51,259 INDEX PARTITION 74 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,950 TABLE 33,674 TABLE PARTITION 20,831 19 TRIGGER 266 TYPE 10,345 VIEW -------- ********** -------- 140,334 sum 20 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,272 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,883 sum 1 230 JS80 INDEX 18 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 18 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 423 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,205 2 VIEW -------- ********** -------- 6,240 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 141 INDEX PARTITION 74 LOB 141 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 49 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,840 sum -------- -------- 160,064 23 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== start additional_compx.sql 2024-06-25 20:01:27 special list (before special recompiling) 2024-06-25 20:01:27 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-06-25 20:01:28 special list (after special recompiling) 2024-06-25 20:01:28 end additional_compx.sql =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,605 INDEX 51,259 INDEX PARTITION 74 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,950 TABLE 33,674 TABLE PARTITION 20,831 19 TRIGGER 266 TYPE 10,345 VIEW -------- ********** -------- 140,334 sum 20 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,272 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,883 sum 1 230 JS80 INDEX 18 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 18 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 423 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,205 2 VIEW -------- ********** -------- 6,240 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 141 INDEX PARTITION 74 LOB 141 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 49 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,840 sum -------- -------- 160,064 23 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTBIU_OSHEA_0035_1736951118 DA TRIGGER DBTBIU_OSHEA_0036_1740233151 DA TRIGGER DBTBIU_OSHEA_0042_2184344894 DA TRIGGER DBTBIU_PRISM_0002_1682955575 DA TRIGGER DBTBIU_USCCONV3_000_1090700249 DA TRIGGER DBTBIU_USCPROD_0002_1208036606 DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST24RM_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST39KQ_OBJSEQ DA TRIGGER DBTI_UETD_CHKDISTYOQ3_OBJSEQ DA TRIGGER DBTI_UETD_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 25-JUN-24 08.01.29.980489 PM -04:00 Flag value=null DBK_patch_flag.show_flag=null.null CMiC CLOUD R12 - V12-019-2-HF-CLD-01f SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Drop Obsolete Columns, Tables, Views, Other Objects -- ====================================================================== -- ====================================================================== -- Create Tables -- ====================================================================== -- ====================================================================== -- Add Columns -- ====================================================================== -- ====================================================================== -- Register Table-Packages and Rebuild Automatically Created Packages -- ====================================================================== -- ====================================================================== -- Install Package Headers -- ====================================================================== -- ====================================================================== -- Install Views -- ====================================================================== -- ====================================================================== -- Install Triggers -- ====================================================================== -- ====================================================================== -- Install Package Bodies -- ====================================================================== -- ====================================================================== -- Install/Update System Data -- ====================================================================== 1 row deleted. 1 row deleted. DELETE FROM DA.SDDATA WHERE SD_CODE = 'SER_JBINV' and exists (SELECT * FROM DA.SDDATA WHERE REPORT_FILENAME = 'SER_JBINV') * ERROR at line 1: ORA-00904: "REPORT_FILENAME": invalid identifier DELETE FROM DA.SDDATA WHERE SD_CODE = 'SER_JB_C10' and exists (SELECT * FROM DA.SDDATA WHERE REPORT_FILENAME = 'SER_JB_C10') * ERROR at line 1: ORA-00904: "REPORT_FILENAME": invalid identifier DELETE FROM DA.SDCODES WHERE SD_CODE = 'SER_JBINV' and exists (SELECT * FROM DA.SDCODES WHERE REPORT_FILENAME = 'SER_JBINV') * ERROR at line 1: ORA-00904: "REPORT_FILENAME": invalid identifier DELETE FROM DA.SDCODES WHERE SD_CODE = 'SER_JB_C10' and exists (SELECT * FROM DA.SDCODES WHERE REPORT_FILENAME = 'SER_JB_C10') * ERROR at line 1: ORA-00904: "REPORT_FILENAME": invalid identifier Commit complete. -- ====================================================================== -- Update Data, Modify Table/Column Definitions -- ====================================================================== -- ====================================================================== -- Data Correction Statements -- ====================================================================== -- ====================================================================== -- Install Keys and Constraints -- ====================================================================== -- ====================================================================== -- Install Indexes -- ====================================================================== -- ====================================================================== -- Install Table and Column Comments -- ====================================================================== -- ====================================================================== -- Get the Current State of the Database -- ====================================================================== BEGIN sys.UTL_RECOMP.recomp_parallel; END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 g) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,605 INDEX 51,259 INDEX PARTITION 74 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,950 TABLE 33,674 TABLE PARTITION 20,831 19 TRIGGER 266 TYPE 10,345 VIEW -------- ********** -------- 140,334 sum 20 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,272 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,883 sum 1 230 JS80 INDEX 18 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 18 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 423 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,205 2 VIEW -------- ********** -------- 6,240 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 141 INDEX PARTITION 74 LOB 141 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 49 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,840 sum -------- -------- 160,064 23 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== start additional_compx.sql 2024-06-25 20:01:38 special list (before special recompiling) 2024-06-25 20:01:38 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-06-25 20:01:39 special list (after special recompiling) 2024-06-25 20:01:39 end additional_compx.sql =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,605 INDEX 51,259 INDEX PARTITION 74 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,950 TABLE 33,674 TABLE PARTITION 20,831 19 TRIGGER 266 TYPE 10,345 VIEW -------- ********** -------- 140,334 sum 20 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,272 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,883 sum 1 230 JS80 INDEX 18 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 18 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 423 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,205 2 VIEW -------- ********** -------- 6,240 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 141 INDEX PARTITION 74 LOB 141 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 49 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,840 sum -------- -------- 160,064 23 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTBIU_OSHEA_0035_1736951118 DA TRIGGER DBTBIU_OSHEA_0036_1740233151 DA TRIGGER DBTBIU_OSHEA_0042_2184344894 DA TRIGGER DBTBIU_PRISM_0002_1682955575 DA TRIGGER DBTBIU_USCCONV3_000_1090700249 DA TRIGGER DBTBIU_USCPROD_0002_1208036606 DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST24RM_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST39KQ_OBJSEQ DA TRIGGER DBTI_UETD_CHKDISTYOQ3_OBJSEQ DA TRIGGER DBTI_UETD_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 25-JUN-24 08.01.40.886362 PM -04:00 Flag value=null DBK_patch_flag.show_flag=null.null CMiC CLOUD R12 - V12-019-2-HF-CLD-01f SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Update Menu Items in Treeview -- ====================================================================== -- ====================================================================== -- 23.74103_31.sql completed. Output in 23.74103_31.LST -- ====================================================================== Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 1 entry Name Update:2374103_32.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-06-25_20_01_07.139/2374103_32.sql.sh to run 2374103_32.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-06-25_20_01_07.139/2374103_32.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-06-25_20_01_07.139/2374103_32.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jun 25 20:01:40 2024 Version 19.23.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. ************************* * Start of dbdefine.sql * ************************* *********************** * End of dbdefine.sql * *********************** ************************* * Connect as DA * ************************* Connected. *********************** * Connected * *********************** -- ====================================================================== -- Work Order 23.74103, Work Item 32 -- Invoice Format Created New Report SER_JBINV -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 23.74103_32.sql Output in 23.74103_32.lst -- ====================================================================== -- ====================================================================== -- Get the initial state of the database -- ====================================================================== BEGIN sys.UTL_RECOMP.recomp_parallel; END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored Session altered. -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 g) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,605 INDEX 51,259 INDEX PARTITION 74 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,950 TABLE 33,674 TABLE PARTITION 20,831 19 TRIGGER 266 TYPE 10,345 VIEW -------- ********** -------- 140,334 sum 20 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,272 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,883 sum 1 230 JS80 INDEX 18 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 18 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 423 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,205 2 VIEW -------- ********** -------- 6,240 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 141 INDEX PARTITION 74 LOB 141 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 49 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,840 sum -------- -------- 160,064 23 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== start additional_compx.sql 2024-06-25 20:01:49 special list (before special recompiling) 2024-06-25 20:01:50 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-06-25 20:01:51 special list (after special recompiling) 2024-06-25 20:01:51 end additional_compx.sql =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,605 INDEX 51,259 INDEX PARTITION 74 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,950 TABLE 33,674 TABLE PARTITION 20,831 19 TRIGGER 266 TYPE 10,345 VIEW -------- ********** -------- 140,334 sum 20 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,272 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,883 sum 1 230 JS80 INDEX 18 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 18 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 423 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,205 2 VIEW -------- ********** -------- 6,240 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 141 INDEX PARTITION 74 LOB 141 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 49 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,840 sum -------- -------- 160,064 23 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTBIU_OSHEA_0035_1736951118 DA TRIGGER DBTBIU_OSHEA_0036_1740233151 DA TRIGGER DBTBIU_OSHEA_0042_2184344894 DA TRIGGER DBTBIU_PRISM_0002_1682955575 DA TRIGGER DBTBIU_USCCONV3_000_1090700249 DA TRIGGER DBTBIU_USCPROD_0002_1208036606 DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST24RM_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST39KQ_OBJSEQ DA TRIGGER DBTI_UETD_CHKDISTYOQ3_OBJSEQ DA TRIGGER DBTI_UETD_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 25-JUN-24 08.01.52.750098 PM -04:00 Flag value=null DBK_patch_flag.show_flag=null.null CMiC CLOUD R12 - V12-019-2-HF-CLD-01f SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Drop Obsolete Columns, Tables, Views, Other Objects -- ====================================================================== -- ====================================================================== -- Create Tables -- ====================================================================== -- ====================================================================== -- Add Columns -- ====================================================================== -- ====================================================================== -- Register Table-Packages and Rebuild Automatically Created Packages -- ====================================================================== -- ====================================================================== -- Install Package Headers -- ====================================================================== -- ====================================================================== -- Install Views -- ====================================================================== -- ====================================================================== -- Install Triggers -- ====================================================================== -- ====================================================================== -- Install Package Bodies -- ====================================================================== -- ====================================================================== -- Install/Update System Data -- ====================================================================== 0: 1: 2: 3: 4: 5: 6: 7: *: 0: 1: 2: 3: 4: 5: 6: 7: *: PL/SQL procedure successfully completed. .========================================================= . Dropping Temporary TABLES .========================================================= Table dropped. drop table TMP_SDCODES * ERROR at line 1: ORA-00942: table or view does not exist drop table TMP_sddata_user_table * ERROR at line 1: ORA-00942: table or view does not exist .========================================================= . Creating Temporary TABLES .========================================================= Table created. Table created. Table created. ================================================================ Creating Temporary INDEXES ================================================================ Index created. Index created. .========================================================= . PROCESSING table DA.REPORTS_WITHIN_APPS .=TMP===================================================== 1 row created. Commit complete. .=UPDATE================================================== 0 rows updated. Commit complete. .=INSERT================================================== 1 row created. .========================================================= Commit complete. .========================================================= . PROCESSED table DA.REPORTS_WITHIN_APPS .========================================================= .========================================================= . PROCESSING table da.SDCODES .=TMP===================================================== 1 row created. Commit complete. .=UPDATE================================================== 1 row updated. Commit complete. .=INSERT================================================== 0 rows created. .========================================================= Commit complete. .========================================================= . PROCESSED table DA.SDCODES .========================================================= .========================================================= . PROCESSING table da.sddata_user_table .=TMP===================================================== 1 row created. .=UPDATE=================================================== 0 rows updated. Commit complete. .=INSERT=================================================== 1 row created. Commit complete. .========================================================= Commit complete. .========================================================= . PROCESSED table DA.sddata_user_table .========================================================= .========================================================= . Dropping Temporary TABLES .========================================================= Table dropped. Table dropped. Table dropped. 0: 1: 2: 3: 4: 5: 6: 7: *: 0: 1: 2: 3: 4: 5: 6: 7: *: PL/SQL procedure successfully completed. -- ====================================================================== -- Update Data, Modify Table/Column Definitions -- ====================================================================== -- ====================================================================== -- Data Correction Statements -- ====================================================================== -- ====================================================================== -- Install Keys and Constraints -- ====================================================================== -- ====================================================================== -- Install Indexes -- ====================================================================== -- ====================================================================== -- Install Table and Column Comments -- ====================================================================== -- ====================================================================== -- Get the Current State of the Database -- ====================================================================== BEGIN sys.UTL_RECOMP.recomp_parallel; END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 g) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,605 INDEX 51,259 INDEX PARTITION 74 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,949 TABLE 33,674 TABLE PARTITION 20,831 19 TRIGGER 266 TYPE 10,345 VIEW -------- ********** -------- 140,333 sum 20 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,272 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,883 sum 1 230 JS80 INDEX 18 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 18 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 423 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,205 2 VIEW -------- ********** -------- 6,240 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 141 INDEX PARTITION 74 LOB 141 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 49 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,840 sum -------- -------- 160,063 23 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== start additional_compx.sql 2024-06-25 20:02:01 special list (before special recompiling) 2024-06-25 20:02:02 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-06-25 20:02:03 special list (after special recompiling) 2024-06-25 20:02:03 end additional_compx.sql =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,605 INDEX 51,259 INDEX PARTITION 74 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,949 TABLE 33,674 TABLE PARTITION 20,831 19 TRIGGER 266 TYPE 10,345 VIEW -------- ********** -------- 140,333 sum 20 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,272 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,883 sum 1 230 JS80 INDEX 18 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 18 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 423 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,205 2 VIEW -------- ********** -------- 6,240 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 141 INDEX PARTITION 74 LOB 141 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 49 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,840 sum -------- -------- 160,063 23 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTBIU_OSHEA_0035_1736951118 DA TRIGGER DBTBIU_OSHEA_0036_1740233151 DA TRIGGER DBTBIU_OSHEA_0042_2184344894 DA TRIGGER DBTBIU_PRISM_0002_1682955575 DA TRIGGER DBTBIU_USCCONV3_000_1090700249 DA TRIGGER DBTBIU_USCPROD_0002_1208036606 DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST24RM_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST39KQ_OBJSEQ DA TRIGGER DBTI_UETD_CHKDISTYOQ3_OBJSEQ DA TRIGGER DBTI_UETD_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 25-JUN-24 08.02.04.567200 PM -04:00 Flag value=null DBK_patch_flag.show_flag=null.null CMiC CLOUD R12 - V12-019-2-HF-CLD-01f SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Update Menu Items in Treeview -- ====================================================================== -- ====================================================================== -- 23.74103_32.sql completed. Output in 23.74103_32.LST -- ====================================================================== Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 2 entry Name Update:2374103_33.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-06-25_20_01_07.139/2374103_33.sql.sh to run 2374103_33.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-06-25_20_01_07.139/2374103_33.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-06-25_20_01_07.139/2374103_33.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jun 25 20:02:04 2024 Version 19.23.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. ************************* * Start of dbdefine.sql * ************************* *********************** * End of dbdefine.sql * *********************** ************************* * Connect as DA * ************************* Connected. *********************** * Connected * *********************** -- ====================================================================== -- Work Order 23.74103, Work Item 33 -- Invoice Format Created New Report SER_JB_C10 -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 23.74103_33.sql Output in 23.74103_33.lst -- ====================================================================== -- ====================================================================== -- Get the initial state of the database -- ====================================================================== BEGIN sys.UTL_RECOMP.recomp_parallel; END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored Session altered. -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 g) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,605 INDEX 51,259 INDEX PARTITION 74 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,949 TABLE 33,674 TABLE PARTITION 20,831 19 TRIGGER 266 TYPE 10,345 VIEW -------- ********** -------- 140,333 sum 20 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,272 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,883 sum 1 230 JS80 INDEX 18 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 18 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 423 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,205 2 VIEW -------- ********** -------- 6,240 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 141 INDEX PARTITION 74 LOB 141 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 49 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,840 sum -------- -------- 160,063 23 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== start additional_compx.sql 2024-06-25 20:02:13 special list (before special recompiling) 2024-06-25 20:02:13 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-06-25 20:02:14 special list (after special recompiling) 2024-06-25 20:02:15 end additional_compx.sql =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,605 INDEX 51,259 INDEX PARTITION 74 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,949 TABLE 33,674 TABLE PARTITION 20,831 19 TRIGGER 266 TYPE 10,345 VIEW -------- ********** -------- 140,333 sum 20 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,272 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,883 sum 1 230 JS80 INDEX 18 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 18 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 423 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,205 2 VIEW -------- ********** -------- 6,240 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 141 INDEX PARTITION 74 LOB 141 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 49 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,840 sum -------- -------- 160,063 23 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTBIU_OSHEA_0035_1736951118 DA TRIGGER DBTBIU_OSHEA_0036_1740233151 DA TRIGGER DBTBIU_OSHEA_0042_2184344894 DA TRIGGER DBTBIU_PRISM_0002_1682955575 DA TRIGGER DBTBIU_USCCONV3_000_1090700249 DA TRIGGER DBTBIU_USCPROD_0002_1208036606 DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST24RM_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST39KQ_OBJSEQ DA TRIGGER DBTI_UETD_CHKDISTYOQ3_OBJSEQ DA TRIGGER DBTI_UETD_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 25-JUN-24 08.02.16.484232 PM -04:00 Flag value=null DBK_patch_flag.show_flag=null.null CMiC CLOUD R12 - V12-019-2-HF-CLD-01f SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Drop Obsolete Columns, Tables, Views, Other Objects -- ====================================================================== -- ====================================================================== -- Create Tables -- ====================================================================== -- ====================================================================== -- Add Columns -- ====================================================================== -- ====================================================================== -- Register Table-Packages and Rebuild Automatically Created Packages -- ====================================================================== -- ====================================================================== -- Install Package Headers -- ====================================================================== -- ====================================================================== -- Install Views -- ====================================================================== -- ====================================================================== -- Install Triggers -- ====================================================================== -- ====================================================================== -- Install Package Bodies -- ====================================================================== -- ====================================================================== -- Install/Update System Data -- ====================================================================== 0: 1: 2: 3: 4: 5: 6: 7: *: 0: 1: 2: 3: 4: 5: 6: 7: *: PL/SQL procedure successfully completed. .========================================================= . Dropping Temporary TABLES .========================================================= drop table TMP_REPORTS_WITHIN_APPS * ERROR at line 1: ORA-00942: table or view does not exist drop table TMP_SDCODES * ERROR at line 1: ORA-00942: table or view does not exist drop table TMP_sddata_user_table * ERROR at line 1: ORA-00942: table or view does not exist .========================================================= . Creating Temporary TABLES .========================================================= Table created. Table created. Table created. ================================================================ Creating Temporary INDEXES ================================================================ Index created. Index created. .========================================================= . PROCESSING table DA.REPORTS_WITHIN_APPS .=TMP===================================================== 1 row created. Commit complete. .=UPDATE================================================== 0 rows updated. Commit complete. .=INSERT================================================== 1 row created. .========================================================= Commit complete. .========================================================= . PROCESSED table DA.REPORTS_WITHIN_APPS .========================================================= .========================================================= . PROCESSING table da.SDCODES .=TMP===================================================== 1 row created. Commit complete. .=UPDATE================================================== 1 row updated. Commit complete. .=INSERT================================================== 0 rows created. .========================================================= Commit complete. .========================================================= . PROCESSED table DA.SDCODES .========================================================= .========================================================= . PROCESSING table da.sddata_user_table .=TMP===================================================== 1 row created. .=UPDATE=================================================== 0 rows updated. Commit complete. .=INSERT=================================================== 1 row created. Commit complete. .========================================================= Commit complete. .========================================================= . PROCESSED table DA.sddata_user_table .========================================================= .========================================================= . Dropping Temporary TABLES .========================================================= Table dropped. Table dropped. Table dropped. 0: 1: 2: 3: 4: 5: 6: 7: *: 0: 1: 2: 3: 4: 5: 6: 7: *: PL/SQL procedure successfully completed. -- ====================================================================== -- Update Data, Modify Table/Column Definitions -- ====================================================================== -- ====================================================================== -- Data Correction Statements -- ====================================================================== -- ====================================================================== -- Install Keys and Constraints -- ====================================================================== -- ====================================================================== -- Install Indexes -- ====================================================================== -- ====================================================================== -- Install Table and Column Comments -- ====================================================================== -- ====================================================================== -- Get the Current State of the Database -- ====================================================================== BEGIN sys.UTL_RECOMP.recomp_parallel; END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 g) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,605 INDEX 51,259 INDEX PARTITION 74 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,949 TABLE 33,674 TABLE PARTITION 20,831 19 TRIGGER 266 TYPE 10,345 VIEW -------- ********** -------- 140,333 sum 20 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,272 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,883 sum 1 230 JS80 INDEX 18 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 18 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 423 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,205 2 VIEW -------- ********** -------- 6,240 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 141 INDEX PARTITION 74 LOB 141 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 49 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,840 sum -------- -------- 160,063 23 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== start additional_compx.sql 2024-06-25 20:02:25 special list (before special recompiling) 2024-06-25 20:02:26 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-06-25 20:02:26 special list (after special recompiling) 2024-06-25 20:02:27 end additional_compx.sql =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,605 INDEX 51,259 INDEX PARTITION 74 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,949 TABLE 33,674 TABLE PARTITION 20,831 19 TRIGGER 266 TYPE 10,345 VIEW -------- ********** -------- 140,333 sum 20 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,272 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,883 sum 1 230 JS80 INDEX 18 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 18 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 423 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,205 2 VIEW -------- ********** -------- 6,240 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 141 INDEX PARTITION 74 LOB 141 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 49 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,840 sum -------- -------- 160,063 23 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTBIU_OSHEA_0035_1736951118 DA TRIGGER DBTBIU_OSHEA_0036_1740233151 DA TRIGGER DBTBIU_OSHEA_0042_2184344894 DA TRIGGER DBTBIU_PRISM_0002_1682955575 DA TRIGGER DBTBIU_USCCONV3_000_1090700249 DA TRIGGER DBTBIU_USCPROD_0002_1208036606 DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST24RM_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST39KQ_OBJSEQ DA TRIGGER DBTI_UETD_CHKDISTYOQ3_OBJSEQ DA TRIGGER DBTI_UETD_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 25-JUN-24 08.02.28.387074 PM -04:00 Flag value=null DBK_patch_flag.show_flag=null.null CMiC CLOUD R12 - V12-019-2-HF-CLD-01f SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Update Menu Items in Treeview -- ====================================================================== -- ====================================================================== -- 23.74103_33.sql completed. Output in 23.74103_33.LST -- ====================================================================== Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 3 deployment dir /opt/cm/ias/j2ee/test/deployment/deploy Case 4 Issue 23.74103 was successfully installed. As specified with --no-deploy option, JSPs did not get deployed. Deploy JSPs manually Installation Log Review: ======================== ---------SUMMARY--------- Critical Errors: 0 Warning Errors: 0 Informative Errors: 21 ---------CRITICAL ERRORS--------- ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- 114 | * 115 | ERROR at line 1: 116 | ORA-06550: line 1, column 7: 117 | PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared 116 | ORA-06550: line 1, column 7: 117 | PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared 118 | ORA-06550: line 1, column 7: 119 | PL/SQL: Statement ignored 508 | * 509 | ERROR at line 1: 510 | ORA-00904: "REPORT_FILENAME": invalid identifier 511 | 514 | * 515 | ERROR at line 1: 516 | ORA-00904: "REPORT_FILENAME": invalid identifier 517 | 520 | * 521 | ERROR at line 1: 522 | ORA-00904: "REPORT_FILENAME": invalid identifier 523 | 526 | * 527 | ERROR at line 1: 528 | ORA-00904: "REPORT_FILENAME": invalid identifier 529 | 554 | * 555 | ERROR at line 1: 556 | ORA-06550: line 1, column 7: 557 | PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared 556 | ORA-06550: line 1, column 7: 557 | PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared 558 | ORA-06550: line 1, column 7: 559 | PL/SQL: Statement ignored 972 | * 973 | ERROR at line 1: 974 | ORA-06550: line 1, column 7: 975 | PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared 974 | ORA-06550: line 1, column 7: 975 | PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared 976 | ORA-06550: line 1, column 7: 977 | PL/SQL: Statement ignored 1387 | * 1388 | ERROR at line 1: 1389 | ORA-00942: table or view does not exist 1390 | 1393 | * 1394 | ERROR at line 1: 1395 | ORA-00942: table or view does not exist 1396 | 1553 | * 1554 | ERROR at line 1: 1555 | ORA-06550: line 1, column 7: 1556 | PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared 1555 | ORA-06550: line 1, column 7: 1556 | PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared 1557 | ORA-06550: line 1, column 7: 1558 | PL/SQL: Statement ignored 1971 | * 1972 | ERROR at line 1: 1973 | ORA-06550: line 1, column 7: 1974 | PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared 1973 | ORA-06550: line 1, column 7: 1974 | PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared 1975 | ORA-06550: line 1, column 7: 1976 | PL/SQL: Statement ignored 2383 | * 2384 | ERROR at line 1: 2385 | ORA-00942: table or view does not exist 2386 | 2389 | * 2390 | ERROR at line 1: 2391 | ORA-00942: table or view does not exist 2392 | 2395 | * 2396 | ERROR at line 1: 2397 | ORA-00942: table or view does not exist 2398 | 2555 | * 2556 | ERROR at line 1: 2557 | ORA-06550: line 1, column 7: 2558 | PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared 2557 | ORA-06550: line 1, column 7: 2558 | PLS-00201: identifier 'SYS.UTL_RECOMP' must be declared 2559 | ORA-06550: line 1, column 7: 2560 | PL/SQL: Statement ignored =============================== End of Installation Log Review ===============================