Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/24.90254_CLOUD_112811_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-10-08 20:01:07 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 - File: sql/2490254_4.sql: __________________________ Updating: /opt/cm/v12/test/sql/2490254_4.sql - This is a new file, no information available on disk - size (new file): 7706 bytes - last modified (new file): 2024-10-08 09:36:14.0 Entryname Update:wkf_notifications.vw@sql - File: sql/wkf_notifications.vw: _________________________________ Updating: /opt/cm/v12/test/sql/wkf_notifications.vw - size (on disk): 9459 bytes - last modified (on disk): 2024-09-11 09:58:32.0 -project (on disk): C_GEN_V12 - version (on disk): 1.2 - size (new file): 9325 bytes - last modified (new file): 2024-10-08 09:04:34.0 -project (new file): C_GEN_V12 - version (new file): 1.3 Entryname Update:DBK_WKF_NTF_APPROVALS.pb@sql - File: sql/DBK_WKF_NTF_APPROVALS.pb: _____________________________________ Updating: /opt/cm/v12/test/sql/DBK_WKF_NTF_APPROVALS.pb - size (on disk): 192375 bytes - last modified (on disk): 2024-09-11 10:06:48.0 -project (on disk): C_GEN_V12 - version (on disk): 1.1 - size (new file): 190622 bytes - last modified (new file): 2024-10-08 09:39:44.0 -project (new file): C_GEN_V12 - version (new file): 1.2 Entryname Update:DBK_WKF_NTF_APPROVALS.ps@sql - File: sql/DBK_WKF_NTF_APPROVALS.ps: _____________________________________ Updating: /opt/cm/v12/test/sql/DBK_WKF_NTF_APPROVALS.ps - size (on disk): 10753 bytes - last modified (on disk): 2023-12-20 16:50:58.0 -project (on disk): ERPV12-019-2_V12 - version (on disk): 170888 - size (new file): 11027 bytes - last modified (new file): 2024-10-08 09:00:48.0 -project (new file): C_GEN_V12 - version (new file): 1.0 Entryname Update:WKF_NOTIFICATIONS_V2_V.vw@sql - File: sql/WKF_NOTIFICATIONS_V2_V.vw: ______________________________________ Updating: /opt/cm/v12/test/sql/WKF_NOTIFICATIONS_V2_V.vw - size (on disk): 8436 bytes - last modified (on disk): 2024-09-11 10:00:18.0 -project (on disk): C_GEN_V12 - version (on disk): 1.2 - size (new file): 8008 bytes - last modified (new file): 2024-10-08 09:04:34.0 -project (new file): C_GEN_V12 - version (new file): 1.3 - File: sql/NOTIFICATION_LIST_WEB_SERVICE_DATA.typ: ___________________________________________________ Updating: /opt/cm/v12/test/sql/NOTIFICATION_LIST_WEB_SERVICE_DATA.typ - size (on disk): 16824 bytes - last modified (on disk): 2022-07-18 00:51:26.0 - size (new file): 18241 bytes - last modified (new file): 2024-10-08 09:04:54.0 Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-10-08_20_01_08.274/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-10-08_20_01_08.274/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-10-08_20_01_08.274/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 2 The group 0 entry Name Update:2490254_4.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-10-08_20_01_08.274/2490254_4.sql.sh to run 2490254_4.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-10-08_20_01_08.274/2490254_4.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-10-08_20_01_08.274/2490254_4.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 8 20:01:29 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 24.90254, Work Item 4 -- Unable to add new distributions in Construct Approvals -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2490254_4.sql Output in 2490254_4.lst -- ====================================================================== -- ====================================================================== -- Turn Patch Flag ON -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- Get the initial state of the database -- ====================================================================== PL/SQL procedure successfully completed. 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 17,800 INDEX 58,035 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,161 PACKAGE 3,154 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,548 SYNONYM 18,173 TABLE 38,288 TABLE PARTITION 61,602 12 TRIGGER 266 TYPE 40,859 10 VIEW -------- ********** -------- 243,416 sum 23 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 11,465 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 13,074 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 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,894 VIEW -------- ********** -------- 4,492 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 34,101 36 VIEW -------- ********** -------- 34,136 sum 36 8 REPORT_WRI INDEX 1 LOB 56 PACKAGE 56 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 393 VIEW -------- ********** -------- 548 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 147 INDEX PARTITION 74 LOB 147 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 51 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,854 sum -------- -------- 301,262 60 =================================================== =================================================================================== == 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-10-08 20:01:45 special list (before special recompiling) 2024-10-08 20:01:45 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-10-08 20:01:47 special list (after special recompiling) 2024-10-08 20:01:47 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 17,800 INDEX 58,035 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,161 PACKAGE 3,154 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,548 SYNONYM 18,173 TABLE 38,288 TABLE PARTITION 61,602 12 TRIGGER 266 TYPE 40,859 10 VIEW -------- ********** -------- 243,416 sum 23 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 11,465 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 13,074 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 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,894 VIEW -------- ********** -------- 4,492 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 34,101 36 VIEW -------- ********** -------- 34,136 sum 36 8 REPORT_WRI INDEX 1 LOB 56 PACKAGE 56 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 393 VIEW -------- ********** -------- 548 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 147 INDEX PARTITION 74 LOB 147 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 51 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,854 sum -------- -------- 301,262 60 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE 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_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DA TRIGGER DBT_AUTO_COLD_STORE_2456605959 DA TRIGGER DBT_I_IUD_EMP_AVAILFLT3_FATVIE DA TRIGGER DBT_I_IUD_EMP_AVAILKOFX_FATVIE DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI DA VIEW UETD_EMP_AVAILFLT3_FATVIEW DA VIEW UETD_EMP_AVAILKOFX_FATVIEW DA VIEW UETD_EMP_AVAILKOFX_OUTER_VIEW DA VIEW UETD_EMP_AVAILKOFX_VIEW DA VIEW UETD_SLC_ARTAXRDKRE_FATVIEW DA VIEW UETD_SLC_ARTAXRDKRE_OUTER_VIEW DA VIEW UETD_SLC_ARTAXRDKRE_VIEW DA VIEW UETD_SLC_TAXREFDKRE_FATVIEW DA VIEW UETD_SLC_TAXREFDKRE_OUTER_VIEW DA VIEW UETD_SLC_TAXREFDKRE_VIEW DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 08-OCT-24 08.01.49.295405 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-04e SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Drop Obsolete Database Objects -- ====================================================================== -- ====================================================================== -- Create Types -- ====================================================================== -- ================================================================================================================================================================================================================================================================================================================================================================================================ -- Creating type "DA"."WKF_NOTIFICATIONS","DA"."WKF_ACCEPT_REJECT_NTF","DA"."WKF_GET_USER_LIST","DA"."WKF_NTF_SETTING_LIST","DA"."WKF_NOTIFICATION","DA"."WKF_ACCEPT_REJECT_NTF","DA"."WKF_GET_USER","DA"."WKF_GET_FLAGS","DA"."WKF_NOTIF","DA"."WKF_NOTIF_FLYSHEET","DA"."WKF_NOTIF_FLYSHEETS","DA"."WKF_NOTIFS","DA"."WKF_NOTIFICATION","DA"."WKF_ACCEPT_REJECT_NTF_LIST","DA"."WKF_NOTIFICATION" -- =============================================================================================================================================================================================================================================================================================================================================================================================== Type dropped. Type dropped. Type dropped. Type dropped. Type dropped. Type dropped. Type dropped. Type dropped. Type dropped. Type dropped. Type dropped. Type dropped. DROP TYPE WKF_NOTIFS2 * ERROR at line 1: ORA-04043: object WKF_NOTIFS2 does not exist DROP TYPE WKF_NOTIF2 * ERROR at line 1: ORA-04043: object WKF_NOTIF2 does not exist DROP TYPE WKF_NOTIF_FLYSHEETS2 force * ERROR at line 1: ORA-04043: object WKF_NOTIF_FLYSHEETS2 does not exist DROP TYPE WKF_NOTIF_FLYSHEET2 force * ERROR at line 1: ORA-04043: object WKF_NOTIF_FLYSHEET2 does not exist Type created. Grant succeeded. Type created. Grant succeeded. Type created. Grant succeeded. Type created. Grant succeeded. Type created. Grant succeeded. Type created. Grant succeeded. Type created. Grant succeeded. Type created. Grant succeeded. Type created. Grant succeeded. Type created. Grant succeeded. Type created. Grant succeeded. Type created. Grant succeeded. Type created. Grant succeeded. Type created. Grant succeeded. Type created. Grant succeeded. Type created. Grant succeeded. No errors. -- ====================================================================== -- Create Tables -- ====================================================================== -- ====================================================================== -- Add Columns -- ====================================================================== -- ====================================================================== -- Install Table and Column Comments -- ====================================================================== -- ====================================================================== -- Create Sequences -- ====================================================================== -- ====================================================================== -- Install Keys and Constraints -- ====================================================================== -- ====================================================================== -- Install Indexes -- ====================================================================== -- ====================================================================== -- Install VWT files or Create Synonyms for TN tables -- ====================================================================== -- ====================================================================== -- Register Table-Packages and Rebuild Automatically Created Packages -- ====================================================================== -- ====================================================================== -- Install Package Headers -- ====================================================================== ========================================================================= Started DBK_WKF_NTF_APPROVALS.ps: Workflow Procedures ========================================================================= ========================================================================= Creating OR replacing PACKAGE DBK_WKF_NTF_APPROVALS ========================================================================= No errors. ========================================================================= Completed DBK_WKF_NTF_APPROVALS.ps: Workflow Procedures ========================================================================= -- ====================================================================== -- Install Views -- ====================================================================== ========================================================================= Started WKF_Notifications.vw ========================================================================= Creating da.wkf_notifications_v Creating da.wkf_notification_body_v ========================================================================= Completed WKF_Notifications.vw ========================================================================= Creating da.wkf_notifications_api_v Created da.wkf_notifications_api_v ==================================================== Create VIEW DA.WKF_NOTIFICATIONS_V2_V ==================================================== No errors. ==================================================== Create VIEW DA.WKF_NOTIFICATIONS_API_V2_V ==================================================== No errors. -- ====================================================================== -- Install Triggers -- ====================================================================== -- ====================================================================== -- Install Package Bodies -- ====================================================================== ========================================================================= Started DBK_WKF_NTF_APPROVALS.pb ========================================================================= ========================================================================= Creating OR replacing PACKAGE BODY DBK_WKF_NTF_APPROVALS ========================================================================= No errors. ========================================================================= Completed DBK_WKF_NTF_APPROVALS.pb: Workflow Procedures ========================================================================= -- ====================================================================== -- Install or Update System Data -- ====================================================================== -- ====================================================================== -- Update Data, Modify Table/Column Definitions -- ====================================================================== -- ====================================================================== -- Data Correction Statements -- ====================================================================== -- ====================================================================== -- Get the current State of the Database -- ====================================================================== -- ==================================================================================================== -- 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 17,800 INDEX 58,035 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,161 PACKAGE 3,154 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,548 SYNONYM 18,173 TABLE 38,288 TABLE PARTITION 61,602 12 TRIGGER 270 TYPE 40,859 10 VIEW -------- ********** -------- 243,420 sum 23 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 11,465 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 13,074 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 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,894 VIEW -------- ********** -------- 4,492 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 34,101 36 VIEW -------- ********** -------- 34,136 sum 36 8 REPORT_WRI INDEX 1 LOB 56 PACKAGE 56 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 393 VIEW -------- ********** -------- 548 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 147 INDEX PARTITION 74 LOB 147 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 51 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,854 sum -------- -------- 301,266 60 =================================================== =================================================================================== == 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-10-08 20:02:07 special list (before special recompiling) 2024-10-08 20:02:07 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-10-08 20:02:09 special list (after special recompiling) 2024-10-08 20:02:09 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 17,800 INDEX 58,035 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,161 PACKAGE 3,154 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,548 SYNONYM 18,173 TABLE 38,288 TABLE PARTITION 61,602 12 TRIGGER 270 TYPE 40,859 10 VIEW -------- ********** -------- 243,420 sum 23 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 11,465 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 13,074 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 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,894 VIEW -------- ********** -------- 4,492 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 34,101 36 VIEW -------- ********** -------- 34,136 sum 36 8 REPORT_WRI INDEX 1 LOB 56 PACKAGE 56 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 393 VIEW -------- ********** -------- 548 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 147 INDEX PARTITION 74 LOB 147 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 51 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,854 sum -------- -------- 301,266 60 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE 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_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DA TRIGGER DBT_AUTO_COLD_STORE_2456605959 DA TRIGGER DBT_I_IUD_EMP_AVAILFLT3_FATVIE DA TRIGGER DBT_I_IUD_EMP_AVAILKOFX_FATVIE DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI DA VIEW UETD_EMP_AVAILFLT3_FATVIEW DA VIEW UETD_EMP_AVAILKOFX_FATVIEW DA VIEW UETD_EMP_AVAILKOFX_OUTER_VIEW DA VIEW UETD_EMP_AVAILKOFX_VIEW DA VIEW UETD_SLC_ARTAXRDKRE_FATVIEW DA VIEW UETD_SLC_ARTAXRDKRE_OUTER_VIEW DA VIEW UETD_SLC_ARTAXRDKRE_VIEW DA VIEW UETD_SLC_TAXREFDKRE_FATVIEW DA VIEW UETD_SLC_TAXREFDKRE_OUTER_VIEW DA VIEW UETD_SLC_TAXREFDKRE_VIEW DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 08-OCT-24 08.02.11.167487 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-04e SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 2490254_4.sql completed. Output in 2490254_4.LST -- ====================================================================== Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 1 deployment dir /opt/cm/ias/j2ee/test/deployment/deploy Case 4 Issue 24.90254 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: 4 ---------CRITICAL ERRORS--------- ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- 580 | * 581 | ERROR at line 1: 582 | ORA-04043: object WKF_NOTIFS2 does not exist 583 | 586 | * 587 | ERROR at line 1: 588 | ORA-04043: object WKF_NOTIF2 does not exist 589 | 592 | * 593 | ERROR at line 1: 594 | ORA-04043: object WKF_NOTIF_FLYSHEETS2 does not exist 595 | 598 | * 599 | ERROR at line 1: 600 | ORA-04043: object WKF_NOTIF_FLYSHEET2 does not exist 601 | =============================== End of Installation Log Review ===============================