Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/24.91248_CLOUD_100706_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-11-07 22:50:41 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/2491248_1.sql: __________________________ Updating: /opt/cm/v12/test/sql/2491248_1.sql - This is a new file, no information available on disk - size (new file): 7269 bytes - last modified (new file): 2024-10-31 07:48:02.0 - File: sql/SVC_JCWIP_20241024.sql: ___________________________________ Updating: /opt/cm/v12/test/sql/SVC_JCWIP_20241024.sql - This is a new file, no information available on disk - size (new file): 9884 bytes - last modified (new file): 2024-10-31 07:48:02.0 Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-11-07_22_50_42.035/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-11-07_22_50_42.035/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-11-07_22_50_42.035/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 2 The group 0 entry Name Update:2491248_1.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-11-07_22_50_42.035/2491248_1.sql.sh to run 2491248_1.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-11-07_22_50_42.035/2491248_1.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-11-07_22_50_42.035/2491248_1.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Thu Nov 7 22:51: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 24.91248, Work Item 1 -- CMiC - Work Order Request -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2491248_1.sql Output in 2491248_1.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,842 INDEX 61,849 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,161 PACKAGE 3,154 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,543 SYNONYM 18,228 TABLE 40,301 TABLE PARTITION 61,782 12 TRIGGER 270 TYPE 40,989 10 VIEW -------- ********** -------- 249,649 sum 23 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 11,509 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 13,118 sum 1 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 799 JSR PACKAGE 799 PACKAGE BODY 2 SYNONYM 2,904 VIEW -------- ********** -------- 4,504 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,188 38 VIEW -------- ********** -------- 34,223 sum 38 8 REPORT_WRI INDEX 1 LOB 55 PACKAGE 55 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 390 VIEW -------- ********** -------- 543 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 135 INDEX PARTITION 74 LOB 135 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 47 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,826 sum -------- -------- 307,611 62 =================================================== =================================================================================== == 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-11-07 22:51:22 special list (before special recompiling) 2024-11-07 22:51:23 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-11-07 22:51:24 special list (after special recompiling) 2024-11-07 22:51:25 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,842 INDEX 61,849 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,161 PACKAGE 3,154 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,543 SYNONYM 18,228 TABLE 40,301 TABLE PARTITION 61,782 12 TRIGGER 270 TYPE 40,989 10 VIEW -------- ********** -------- 249,649 sum 23 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 11,509 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 13,118 sum 1 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 799 JSR PACKAGE 799 PACKAGE BODY 2 SYNONYM 2,904 VIEW -------- ********** -------- 4,504 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,188 38 VIEW -------- ********** -------- 34,223 sum 38 8 REPORT_WRI INDEX 1 LOB 55 PACKAGE 55 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 390 VIEW -------- ********** -------- 543 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 135 INDEX PARTITION 74 LOB 135 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 47 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,826 sum -------- -------- 307,611 62 ========================================================================== 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 07-NOV-24 10.51.27.148649 PM -05:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-05f SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Drop Obsolete Database Objects -- ====================================================================== -- ====================================================================== -- Create Types -- ====================================================================== -- ====================================================================== -- 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 -- ====================================================================== -- ====================================================================== -- Install Views -- ====================================================================== -- ====================================================================== -- Install Triggers -- ====================================================================== -- ====================================================================== -- Install Package Bodies -- ====================================================================== -- ====================================================================== -- Install or Update System Data -- ====================================================================== -- ====================================================================== -- Update Data, Modify Table/Column Definitions -- ====================================================================== -- ====================================================================== -- Data Correction Statements -- ====================================================================== -- ========================================================================================== -- ===== Started: SVC_JCWIP_20241024.sql -- ========================================================================================== -- ====================================================================== -- ===== view: CMIC_REPORT_WRITER.svc_jcwip -- ====================================================================== No errors. COMMENT ON COLUMN svc_jcwip.jcw_comp_code IS 'comp_code' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_cont_code IS 'cont_code' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_job_code IS 'job_code' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_yr IS 'yr' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_per IS 'per' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_cost_td_amt IS 'cost_td_amt' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_proj_cost_budg_amt IS 'proj_cost_budg_amt' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_proj_cost_amt IS 'proj_cost_amt' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_proj_rev_budg_amt IS 'proj_rev_budg_amt' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_proj_rev_amt IS 'proj_rev_amt' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_cum_cost_amt IS 'cum_cost_amt' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_cum_bill_amt IS 'cum_bill_amt' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_percent_complete IS 'percent_complete' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_budgeted_gross_profit IS 'budgeted_gross_profit' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_budgeted_gross_margin IS 'budgeted_gross_margin' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_projected_gross_profit IS 'projected_gross_profit' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_projected_gross_margin IS 'projected_gross_margin' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_revenue_earned IS 'revenue_earned' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_sales_unbilled IS 'sales_unbilled_deferred_to_next_period' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_sales_deferred_to_next_period IS 'sales_deferred_to_next_period' * ERROR at line 1: ORA-00942: table or view does not exist COMMENT ON COLUMN svc_jcwip.jcw_unbilled_sales_in_current_period IS 'unbilled_sales_in_current_period' * ERROR at line 1: ORA-00942: table or view does not exist -- ========================================================================================== -- ===== drop view cmic_report_views.svc_jcwip (if it exists) -- ========================================================================================== DROP VIEW CMIC_REPORT_VIEWS.SVC_JCWIP * ERROR at line 1: ORA-00942: table or view does not exist -- ========================================================================================== -- ===== create cmic_report_views.svc_jcwip -- ========================================================================================== . *** VIEW NOT CREATED: Table or View does not exist (or tenant_id column not found). *** -->CMIC_REPORT_WRITER.SVC_JCWIP -- ========================================================================================== -- ===== grants on cmic_report_views.svc_jcwip -- ========================================================================================== GRANT READ ON CMIC_REPORT_VIEWS.svc_jcwip TO UIG WITH GRANT OPTION * ERROR at line 1: ORA-00942: table or view does not exist GRANT READ ON CMIC_REPORT_VIEWS.svc_jcwip TO CMIC_BI_RUNTIME WITH GRANT OPTION * ERROR at line 1: ORA-00942: table or view does not exist -- ========================================================================================== -- ===== Verify cmic_report_views.svc_jcwip exists -- ========================================================================================== -- ========================================================================================== -- ===== Completed: SVC_JCWIP_20241024.sql -- ========================================================================================== 1* GRANT READ ON CMIC_REPORT_VIEWS.svc_jcwip TO CMIC_BI_RUNTIME WITH GRANT OPTION -- ====================================================================== -- 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,842 INDEX 61,849 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,161 PACKAGE 3,154 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,543 SYNONYM 18,228 TABLE 40,301 TABLE PARTITION 61,782 12 TRIGGER 270 TYPE 40,989 10 VIEW -------- ********** -------- 249,649 sum 23 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 11,509 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 13,118 sum 1 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 799 JSR PACKAGE 799 PACKAGE BODY 2 SYNONYM 2,904 VIEW -------- ********** -------- 4,504 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,188 38 VIEW -------- ********** -------- 34,223 sum 38 8 REPORT_WRI INDEX 1 LOB 55 PACKAGE 55 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 391 VIEW -------- ********** -------- 544 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 135 INDEX PARTITION 74 LOB 135 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 47 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,826 sum -------- -------- 307,612 62 =================================================== =================================================================================== == 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-11-07 22:51:45 special list (before special recompiling) 2024-11-07 22:51:45 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-11-07 22:51:47 special list (after special recompiling) 2024-11-07 22:51: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,842 INDEX 61,849 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,161 PACKAGE 3,154 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,543 SYNONYM 18,228 TABLE 40,301 TABLE PARTITION 61,782 12 TRIGGER 270 TYPE 40,989 10 VIEW -------- ********** -------- 249,649 sum 23 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 11,509 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 13,118 sum 1 230 JS80 INDEX 21 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 21 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 429 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 799 JSR PACKAGE 799 PACKAGE BODY 2 SYNONYM 2,904 VIEW -------- ********** -------- 4,504 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,188 38 VIEW -------- ********** -------- 34,223 sum 38 8 REPORT_WRI INDEX 1 LOB 55 PACKAGE 55 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 391 VIEW -------- ********** -------- 544 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 135 INDEX PARTITION 74 LOB 135 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 47 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,826 sum -------- -------- 307,612 62 ========================================================================== 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 07-NOV-24 10.51.49.509036 PM -05:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-05f SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 2491248_1.sql completed. Output in 2491248_1.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.91248 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: 24 ---------CRITICAL ERRORS--------- ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- 523 | * 524 | ERROR at line 1: 525 | ORA-00942: table or view does not exist 526 | 529 | * 530 | ERROR at line 1: 531 | ORA-00942: table or view does not exist 532 | 535 | * 536 | ERROR at line 1: 537 | ORA-00942: table or view does not exist 538 | 541 | * 542 | ERROR at line 1: 543 | ORA-00942: table or view does not exist 544 | 547 | * 548 | ERROR at line 1: 549 | ORA-00942: table or view does not exist 550 | 553 | * 554 | ERROR at line 1: 555 | ORA-00942: table or view does not exist 556 | 559 | * 560 | ERROR at line 1: 561 | ORA-00942: table or view does not exist 562 | 565 | * 566 | ERROR at line 1: 567 | ORA-00942: table or view does not exist 568 | 571 | * 572 | ERROR at line 1: 573 | ORA-00942: table or view does not exist 574 | 577 | * 578 | ERROR at line 1: 579 | ORA-00942: table or view does not exist 580 | 583 | * 584 | ERROR at line 1: 585 | ORA-00942: table or view does not exist 586 | 589 | * 590 | ERROR at line 1: 591 | ORA-00942: table or view does not exist 592 | 595 | * 596 | ERROR at line 1: 597 | ORA-00942: table or view does not exist 598 | 601 | * 602 | ERROR at line 1: 603 | ORA-00942: table or view does not exist 604 | 607 | * 608 | ERROR at line 1: 609 | ORA-00942: table or view does not exist 610 | 613 | * 614 | ERROR at line 1: 615 | ORA-00942: table or view does not exist 616 | 619 | * 620 | ERROR at line 1: 621 | ORA-00942: table or view does not exist 622 | 625 | * 626 | ERROR at line 1: 627 | ORA-00942: table or view does not exist 628 | 631 | * 632 | ERROR at line 1: 633 | ORA-00942: table or view does not exist 634 | 637 | * 638 | ERROR at line 1: 639 | ORA-00942: table or view does not exist 640 | 643 | * 644 | ERROR at line 1: 645 | ORA-00942: table or view does not exist 646 | 652 | * 653 | ERROR at line 1: 654 | ORA-00942: table or view does not exist 655 | 665 | * 666 | ERROR at line 1: 667 | ORA-00942: table or view does not exist 668 | 671 | * 672 | ERROR at line 1: 673 | ORA-00942: table or view does not exist 674 | =============================== End of Installation Log Review ===============================