Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/23.77372_CLOUD_271239_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-08-19 20:03:57 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.77372, has been installed 11 times on the application server while it is installed 0 times on the database! - File: sql/2377372_9.sql: __________________________ The new copy of the file "/opt/cm/v12/test/sql/2377372_9.sql", shipped with the package, is the same as the current copy on disk, and the timestamps on both files are the same! Updating: /opt/cm/v12/test/sql/2377372_9.sql - size (on disk): 26552 bytes - last modified (on disk): 2024-07-25 21:14:48.0 - size (new file): 26552 bytes - last modified (new file): 2024-07-25 21:14:48.0 Warning: The file was not modified. - File: sql/2377372_8.sql: __________________________ The new copy of the file "/opt/cm/v12/test/sql/2377372_8.sql", shipped with the package, is the same as the current copy on disk, and the timestamps on both files are the same! Updating: /opt/cm/v12/test/sql/2377372_8.sql - size (on disk): 22181 bytes - last modified (on disk): 2024-07-22 09:52:28.0 - size (new file): 22181 bytes - last modified (new file): 2024-07-22 09:52:28.0 Warning: The file was not modified. - File: sql/2377372_10.sql: ___________________________ The new copy of the file "/opt/cm/v12/test/sql/2377372_10.sql", shipped with the package, is the same as the current copy on disk, and the timestamps on both files are the same! Updating: /opt/cm/v12/test/sql/2377372_10.sql - size (on disk): 18332 bytes - last modified (on disk): 2024-08-15 10:43:10.0 - size (new file): 18332 bytes - last modified (new file): 2024-08-15 10:43:10.0 Warning: The file was not modified. Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-08-19_20_03_58.035/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-08-19_20_03_58.035/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-08-19_20_03_58.035/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 4 The group 0 entry Name Update:2377372_8.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-08-19_20_03_58.035/2377372_8.sql.sh to run 2377372_8.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-08-19_20_03_58.035/2377372_8.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-08-19_20_03_58.035/2377372_8.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Mon Aug 19 20:04:31 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.77372, Work Item 8 -- AP - HB not posted/released correctly -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2377372_8.sql Output in 2377372_8.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 7,644 INDEX 53,580 INDEX PARTITION 80 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,552 SYNONYM 8,006 TABLE 35,948 TABLE PARTITION 21,003 17 TRIGGER 266 TYPE 10,405 6 VIEW -------- ********** -------- 145,265 sum 24 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,303 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,914 sum 1 230 JS80 INDEX 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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,276 4 VIEW -------- ********** -------- 6,311 sum 4 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 388 VIEW -------- ********** -------- 539 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 144 INDEX PARTITION 74 LOB 144 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 50 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,847 sum -------- -------- 165,111 29 =================================================== =================================================================================== == 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-08-19 20:04:58 special list (before special recompiling) 2024-08-19 20:04:59 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-08-19 20:05:02 special list (after special recompiling) 2024-08-19 20:05: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,644 INDEX 53,580 INDEX PARTITION 80 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,552 SYNONYM 8,006 TABLE 35,948 TABLE PARTITION 21,003 17 TRIGGER 266 TYPE 10,405 6 VIEW -------- ********** -------- 145,265 sum 24 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,303 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,914 sum 1 230 JS80 INDEX 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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,276 4 VIEW -------- ********** -------- 6,311 sum 4 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 388 VIEW -------- ********** -------- 539 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 144 INDEX PARTITION 74 LOB 144 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 50 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,847 sum -------- -------- 165,111 29 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE 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_JCESTIMATE2ZFP_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATEIMYP_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 DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI 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 19-AUG-24 08.05.05.208749 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-03b SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== 0: 1: 2: 3: 4: 5: 6: 7: *: 0: 1: 2: 3: 4: 5: 6: 7: *: PL/SQL procedure successfully completed. -- ====================================================================== -- Drop Obsolete Database Objects -- ====================================================================== -- ====================================================================== -- Create Types -- ====================================================================== -- ====================================================================== -- Create Tables -- ====================================================================== Table created. Table created. -- ====================================================================== -- 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 -- ====================================================================== Start of block for 1966 vendor End of block for 1966 vendor Start of block for 2511 vendor End of block for 2511 -- ====================================================================== -- 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 7,644 INDEX 53,580 INDEX PARTITION 80 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,552 SYNONYM 8,006 TABLE 35,948 TABLE PARTITION 21,003 17 TRIGGER 266 TYPE 10,405 6 VIEW -------- ********** -------- 145,265 sum 24 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,303 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,914 sum 1 230 JS80 INDEX 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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,276 4 VIEW -------- ********** -------- 6,311 sum 4 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 388 VIEW -------- ********** -------- 539 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 144 INDEX PARTITION 74 LOB 144 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 50 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,847 sum -------- -------- 165,111 29 =================================================== =================================================================================== == 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-08-19 20:05:43 special list (before special recompiling) 2024-08-19 20:05:44 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-08-19 20:05:46 special list (after special recompiling) 2024-08-19 20:05: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 7,644 INDEX 53,580 INDEX PARTITION 80 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,552 SYNONYM 8,006 TABLE 35,948 TABLE PARTITION 21,003 17 TRIGGER 266 TYPE 10,405 6 VIEW -------- ********** -------- 145,265 sum 24 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,303 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,914 sum 1 230 JS80 INDEX 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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,276 4 VIEW -------- ********** -------- 6,311 sum 4 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 388 VIEW -------- ********** -------- 539 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 144 INDEX PARTITION 74 LOB 144 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 50 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,847 sum -------- -------- 165,111 29 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE 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_JCESTIMATE2ZFP_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATEIMYP_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 DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI 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 19-AUG-24 08.05.49.275674 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-03b SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 2377372_8.sql completed. Output in 2377372_8.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:2377372_9.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-08-19_20_03_58.035/2377372_9.sql.sh to run 2377372_9.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-08-19_20_03_58.035/2377372_9.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-08-19_20_03_58.035/2377372_9.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Mon Aug 19 20:05:49 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.77372, Work Item 9 -- AP - HB not posted/released correctly -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2377372_9.sql Output in 2377372_9.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 7,644 INDEX 53,580 INDEX PARTITION 80 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,552 SYNONYM 8,006 TABLE 35,948 TABLE PARTITION 21,003 17 TRIGGER 266 TYPE 10,405 6 VIEW -------- ********** -------- 145,265 sum 24 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,303 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,914 sum 1 230 JS80 INDEX 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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,276 4 VIEW -------- ********** -------- 6,311 sum 4 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 388 VIEW -------- ********** -------- 539 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 144 INDEX PARTITION 74 LOB 144 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 50 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,847 sum -------- -------- 165,111 29 =================================================== =================================================================================== == 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-08-19 20:06:19 special list (before special recompiling) 2024-08-19 20:06:20 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-08-19 20:06:23 special list (after special recompiling) 2024-08-19 20:06:24 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,644 INDEX 53,580 INDEX PARTITION 80 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,552 SYNONYM 8,006 TABLE 35,948 TABLE PARTITION 21,003 17 TRIGGER 266 TYPE 10,405 6 VIEW -------- ********** -------- 145,265 sum 24 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,303 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,914 sum 1 230 JS80 INDEX 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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,276 4 VIEW -------- ********** -------- 6,311 sum 4 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 388 VIEW -------- ********** -------- 539 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 144 INDEX PARTITION 74 LOB 144 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 50 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,847 sum -------- -------- 165,111 29 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE 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_JCESTIMATE2ZFP_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATEIMYP_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 DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI 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 19-AUG-24 08.06.26.789130 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-03b SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== 0: 1: 2: 3: 4: 5: 6: 7: *: 0: 1: 2: 3: 4: 5: 6: 7: *: PL/SQL procedure successfully completed. -- ====================================================================== -- Drop Obsolete Database Objects -- ====================================================================== -- ====================================================================== -- Create Types -- ====================================================================== -- ====================================================================== -- Create Tables -- ====================================================================== Table created. Table created. -- ====================================================================== -- 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 -- ====================================================================== 1 2 data inserted in vourlset VEN_CODE:2404 release voucher_tn:2025209511 v_orig_num:2022576142 vrd_rls_amt:105.2v_tax_hldbk_amt: 13.68 3:r.vou_num2022576142vou_hldbk_amt: 1986.5vou_rls_tax1_amt: 244.57 4:i.vou_num2025209511vou_hldbk_amt: -105.2vou_rls_tax1_amt: -13.68 1 2 data inserted in vourlset VEN_CODE:33 release voucher_tn:2025334843 v_orig_num:2023482649 vrd_rls_amt:125v_tax_hldbk_amt: 16.25 3:r.vou_num2023482649vou_hldbk_amt: 1300vou_rls_tax1_amt: 169 4:i.vou_num2025334843vou_hldbk_amt: -125vou_rls_tax1_amt: -16.25 2 data inserted in vourlset VEN_CODE:33 release voucher_tn:2025334842 v_orig_num:2023482649 vrd_rls_amt:510v_tax_hldbk_amt: 66.3 3:r.vou_num2023482649vou_hldbk_amt: 1300vou_rls_tax1_amt: 169 4:i.vou_num2025334842vou_hldbk_amt: -510vou_rls_tax1_amt: -66.3 2 data inserted in vourlset VEN_CODE:33 release voucher_tn:2025334841 v_orig_num:2023482649 vrd_rls_amt:665v_tax_hldbk_amt: 86.45 3:r.vou_num2023482649vou_hldbk_amt: 1300vou_rls_tax1_amt: 169 4:i.vou_num2025334841vou_hldbk_amt: -665vou_rls_tax1_amt: -86.45 1 2 data inserted in vourlset VEN_CODE:2430 release voucher_tn:2025042625 v_orig_num:2023766725 vrd_rls_amt:746.53v_tax_hldbk_amt: 97.05 3:r.vou_num2023766725vou_hldbk_amt: 3614.03vou_rls_tax1_amt: 469.82 4:i.vou_num2025042625vou_hldbk_amt: -746.53vou_rls_tax1_amt: -97.05 2 data inserted in vourlset VEN_CODE:2430 release voucher_tn:2025042624 v_orig_num:2023766725 vrd_rls_amt:200.67v_tax_hldbk_amt: 26.09 3:r.vou_num2023766725vou_hldbk_amt: 3614.03vou_rls_tax1_amt: 469.82 4:i.vou_num2025042624vou_hldbk_amt: -444.5vou_rls_tax1_amt: -57.79 2 data inserted in vourlset VEN_CODE:2430 release voucher_tn:2025042623 v_orig_num:2023766725 vrd_rls_amt:409.7v_tax_hldbk_amt: 53.26 3:r.vou_num2023766725vou_hldbk_amt: 3614.03vou_rls_tax1_amt: 469.82 4:i.vou_num2025042623vou_hldbk_amt: -551.84vou_rls_tax1_amt: -71.74 1 2 data inserted in vourlset VEN_CODE:1605 release voucher_tn:2025511072 v_orig_num:2023054849 vrd_rls_amt:98.5v_tax_hldbk_amt: 12.81 3:r.vou_num2023054849vou_hldbk_amt: 613.8vou_rls_tax1_amt: 79.79 4:i.vou_num2025511072vou_hldbk_amt: -98.5vou_rls_tax1_amt: -12.81 1 2 data inserted in vourlset VEN_CODE:527 release voucher_tn:2024556865 v_orig_num:2024139836 vrd_rls_amt:162v_tax_hldbk_amt: 21.06 3:r.vou_num2024139836vou_hldbk_amt: 5900vou_rls_tax1_amt: 767 4:i.vou_num2024556865vou_hldbk_amt: -162vou_rls_tax1_amt: -21.06 2 data inserted in vourlset VEN_CODE:527 release voucher_tn:2024556863 v_orig_num:2024139836 vrd_rls_amt:447.58v_tax_hldbk_amt: 58.19 3:r.vou_num2024139836vou_hldbk_amt: 5900vou_rls_tax1_amt: 767 4:i.vou_num2024556863vou_hldbk_amt: -447.58vou_rls_tax1_amt: -58.19 1 2 data inserted in vourlset VEN_CODE:510 release voucher_tn:2009439337 v_orig_num:200867560 vrd_rls_amt:193.88v_tax_hldbk_amt: 29.08 3:r.vou_num200867560vou_hldbk_amt: 193.88vou_rls_tax1_amt: 29.08 4:i.vou_num2009439337vou_hldbk_amt: -829.2vou_rls_tax1_amt: -124.38 1 2 data inserted in vourlset VEN_CODE:668 release voucher_tn:2010340229 v_orig_num:2009436856 vrd_rls_amt:37.32v_tax_hldbk_amt: 5.6 3:r.vou_num2009436856vou_hldbk_amt: 166.32vou_rls_tax1_amt: 24.95 4:i.vou_num2010340229vou_hldbk_amt: -70.5vou_rls_tax1_amt: -10.58 2 data inserted in vourlset VEN_CODE:668 release voucher_tn:2010340228 v_orig_num:2009436856 vrd_rls_amt:129v_tax_hldbk_amt: 19.35 3:r.vou_num2009436856vou_hldbk_amt: 166.32vou_rls_tax1_amt: 24.95 4:i.vou_num2010340228vou_hldbk_amt: -129vou_rls_tax1_amt: -19.35 1 2 data inserted in vourlset VEN_CODE:33 release voucher_tn:2021493648 v_orig_num:2020175785 vrd_rls_amt:65v_tax_hldbk_amt: 8.45 3:r.vou_num2020175785vou_hldbk_amt: 720vou_rls_tax1_amt: 93.6 4:i.vou_num2021493648vou_hldbk_amt: -65vou_rls_tax1_amt: -8.45 1 2 data inserted in vourlset VEN_CODE:43 release voucher_tn:2024525169 v_orig_num:2024013054 vrd_rls_amt:468.64v_tax_hldbk_amt: 60.92 3:r.vou_num2024013054vou_hldbk_amt: 1735.82vou_rls_tax1_amt: 0 4:i.vou_num2024525169vou_hldbk_amt: -1436.5vou_rls_tax1_amt: -186.75 2 data inserted in vourlset VEN_CODE:43 release voucher_tn:2024525168 v_orig_num:2024013054 vrd_rls_amt:159.9v_tax_hldbk_amt: 20.79 3:r.vou_num2024013054vou_hldbk_amt: 1735.82vou_rls_tax1_amt: 0 4:i.vou_num2024525168vou_hldbk_amt: -159.9vou_rls_tax1_amt: -20.79 2 data inserted in vourlset VEN_CODE:43 release voucher_tn:2024525167 v_orig_num:2024013054 vrd_rls_amt:1107.28v_tax_hldbk_amt: 143.94 3:r.vou_num2024013054vou_hldbk_amt: 1735.82vou_rls_tax1_amt: 0 4:i.vou_num2024525167vou_hldbk_amt: -1107.28vou_rls_tax1_amt: -143.94 1 2 data inserted in vourlset VEN_CODE:1673 release voucher_tn:2025287510 v_orig_num:2022811424 vrd_rls_amt:400v_tax_hldbk_amt: 52 3:r.vou_num2022811424vou_hldbk_amt: 725.36vou_rls_tax1_amt: 94.3 4:i.vou_num2025287510vou_hldbk_amt: -400vou_rls_tax1_amt: -52 2 data inserted in vourlset VEN_CODE:1673 release voucher_tn:2025287509 v_orig_num:2022811424 vrd_rls_amt:250v_tax_hldbk_amt: 32.5 3:r.vou_num2022811424vou_hldbk_amt: 725.36vou_rls_tax1_amt: 94.3 4:i.vou_num2025287509vou_hldbk_amt: -250vou_rls_tax1_amt: -32.5 2 data inserted in vourlset VEN_CODE:1673 release voucher_tn:2025287508 v_orig_num:2022811424 vrd_rls_amt:45v_tax_hldbk_amt: 5.85 3:r.vou_num2022811424vou_hldbk_amt: 725.36vou_rls_tax1_amt: 94.3 4:i.vou_num2025287508vou_hldbk_amt: -45vou_rls_tax1_amt: -5.85 1 2 data inserted in vourlset VEN_CODE:306 release voucher_tn:2024997847 v_orig_num:2023995594 vrd_rls_amt:66.83v_tax_hldbk_amt: 8.69 3:r.vou_num2023995594vou_hldbk_amt: 431.76vou_rls_tax1_amt: 56.13 4:i.vou_num2024997847vou_hldbk_amt: -211.15vou_rls_tax1_amt: -27.45 2 data inserted in vourlset VEN_CODE:306 release voucher_tn:2024997846 v_orig_num:2023995594 vrd_rls_amt:364.93v_tax_hldbk_amt: 47.44 3:r.vou_num2023995594vou_hldbk_amt: 431.76vou_rls_tax1_amt: 56.13 4:i.vou_num2024997846vou_hldbk_amt: -364.93vou_rls_tax1_amt: -47.44 1 2 data inserted in vourlset VEN_CODE:2123 release voucher_tn:2027473896 v_orig_num:2026976601 vrd_rls_amt:350v_tax_hldbk_amt: 45.5 3:r.vou_num2026976601vou_hldbk_amt: 613.5vou_rls_tax1_amt: 79.76 4:i.vou_num2027473896vou_hldbk_amt: -350vou_rls_tax1_amt: -45.5 1 2 data inserted in vourlset VEN_CODE:1082 release voucher_tn:2028659048 v_orig_num:2025182739 vrd_rls_amt:330v_tax_hldbk_amt: 42.9 3:r.vou_num2025182739vou_hldbk_amt: 2593.97vou_rls_tax1_amt: 337.22 4:i.vou_num2028659048vou_hldbk_amt: -330vou_rls_tax1_amt: -42.9 2 data inserted in vourlset VEN_CODE:1082 release voucher_tn:2028659047 v_orig_num:2025182739 vrd_rls_amt:264v_tax_hldbk_amt: 34.32 3:r.vou_num2025182739vou_hldbk_amt: 2593.97vou_rls_tax1_amt: 337.22 4:i.vou_num2028659047vou_hldbk_amt: -264vou_rls_tax1_amt: -34.32 2 data inserted in vourlset VEN_CODE:1082 release voucher_tn:2028659045 v_orig_num:2025182739 vrd_rls_amt:375.51v_tax_hldbk_amt: 48.82 3:r.vou_num2025182739vou_hldbk_amt: 2593.97vou_rls_tax1_amt: 337.22 4:i.vou_num2028659045vou_hldbk_amt: -375.51vou_rls_tax1_amt: -48.82 2 data inserted in vourlset VEN_CODE:1082 release voucher_tn:2028659044 v_orig_num:2025182739 vrd_rls_amt:130v_tax_hldbk_amt: 16.9 3:r.vou_num2025182739vou_hldbk_amt: 2593.97vou_rls_tax1_amt: 337.22 4:i.vou_num2028659044vou_hldbk_amt: -130vou_rls_tax1_amt: -16.9 2 data inserted in vourlset VEN_CODE:1082 release voucher_tn:2028659043 v_orig_num:2025182739 vrd_rls_amt:253v_tax_hldbk_amt: 32.89 3:r.vou_num2025182739vou_hldbk_amt: 2593.97vou_rls_tax1_amt: 337.22 4:i.vou_num2028659043vou_hldbk_amt: -253vou_rls_tax1_amt: -32.89 2 data inserted in vourlset VEN_CODE:1082 release voucher_tn:2028659042 v_orig_num:2025182739 vrd_rls_amt:690v_tax_hldbk_amt: 89.7 3:r.vou_num2025182739vou_hldbk_amt: 2593.97vou_rls_tax1_amt: 337.22 4:i.vou_num2028659042vou_hldbk_amt: -690vou_rls_tax1_amt: -89.7 2 data inserted in vourlset VEN_CODE:1082 release voucher_tn:2028659041 v_orig_num:2025182739 vrd_rls_amt:-683.93v_tax_hldbk_amt: -88.91 3:r.vou_num2025182739vou_hldbk_amt: 2593.97vou_rls_tax1_amt: 337.22 4:i.vou_num2028659041vou_hldbk_amt: 683.93vou_rls_tax1_amt: 88.91 2 data inserted in vourlset VEN_CODE:1082 release voucher_tn:2028659040 v_orig_num:2025182739 vrd_rls_amt:605.74v_tax_hldbk_amt: 78.75 3:r.vou_num2025182739vou_hldbk_amt: 2593.97vou_rls_tax1_amt: 337.22 4:i.vou_num2028659040vou_hldbk_amt: -605.74vou_rls_tax1_amt: -78.75 1 2 data inserted in vourlset VEN_CODE:2181 release voucher_tn:2026519044 v_orig_num:2025207590 vrd_rls_amt:690v_tax_hldbk_amt: 89.7 3:r.vou_num2025207590vou_hldbk_amt: 9105.28vou_rls_tax1_amt: 1183.69 4:i.vou_num2026519044vou_hldbk_amt: -690vou_rls_tax1_amt: -89.7 2 data inserted in vourlset VEN_CODE:2181 release voucher_tn:2026519043 v_orig_num:2025207590 vrd_rls_amt:1804.3v_tax_hldbk_amt: 234.56 3:r.vou_num2025207590vou_hldbk_amt: 9105.28vou_rls_tax1_amt: 1183.69 4:i.vou_num2026519043vou_hldbk_amt: -1804.3vou_rls_tax1_amt: -234.56 2 data inserted in vourlset VEN_CODE:2181 release voucher_tn:2026519042 v_orig_num:2025207590 vrd_rls_amt:1753.4v_tax_hldbk_amt: 227.94 3:r.vou_num2025207590vou_hldbk_amt: 9105.28vou_rls_tax1_amt: 1183.69 4:i.vou_num2026519042vou_hldbk_amt: -1753.4vou_rls_tax1_amt: -227.94 1 2 data inserted in vourlset VEN_CODE:1673 release voucher_tn:2027231517 v_orig_num:2025182737 vrd_rls_amt:450v_tax_hldbk_amt: 58.5 3:r.vou_num2025182737vou_hldbk_amt: 4000vou_rls_tax1_amt: 520 4:i.vou_num2027231517vou_hldbk_amt: -450vou_rls_tax1_amt: -58.5 1 2 data inserted in vourlset VEN_CODE:2442 release voucher_tn:2025263855 v_orig_num:2023691613 vrd_rls_amt:360v_tax_hldbk_amt: 46.8 3:r.vou_num2023691613vou_hldbk_amt: 400.98vou_rls_tax1_amt: 5.33 4:i.vou_num2025263855vou_hldbk_amt: -360vou_rls_tax1_amt: -46.8 1 2 data inserted in vourlset VEN_CODE:2098 release voucher_tn:2025042210 v_orig_num:2022354767 vrd_rls_amt:-833.9v_tax_hldbk_amt: -108.41 3:r.vou_num2022354767vou_hldbk_amt: 2771vou_rls_tax1_amt: 360.23 4:i.vou_num2025042210vou_hldbk_amt: 833.9vou_rls_tax1_amt: 108.41 2 data inserted in vourlset VEN_CODE:2098 release voucher_tn:2025042209 v_orig_num:2022354767 vrd_rls_amt:1433.9v_tax_hldbk_amt: 186.41 3:r.vou_num2022354767vou_hldbk_amt: 2771vou_rls_tax1_amt: 360.23 4:i.vou_num2025042209vou_hldbk_amt: -10531.9vou_rls_tax1_amt: -1369.15 1 2 data inserted in vourlset VEN_CODE:1046 release voucher_tn:2028532445 v_orig_num:2025351652 vrd_rls_amt:1187.5v_tax_hldbk_amt: 154.38 3:r.vou_num2025351652vou_hldbk_amt: 1800vou_rls_tax1_amt: 234 4:i.vou_num2028532445vou_hldbk_amt: -1187.5vou_rls_tax1_amt: -154.38 1 2 data inserted in vourlset VEN_CODE:168 release voucher_tn:2023383442 v_orig_num:2022694503 vrd_rls_amt:415v_tax_hldbk_amt: 53.95 3:r.vou_num2022694503vou_hldbk_amt: 4359.9vou_rls_tax1_amt: 566.79 4:i.vou_num2023383442vou_hldbk_amt: -415vou_rls_tax1_amt: -53.95 2 data inserted in vourlset VEN_CODE:168 release voucher_tn:2023383441 v_orig_num:2022694503 vrd_rls_amt:710v_tax_hldbk_amt: 92.31 3:r.vou_num2022694503vou_hldbk_amt: 4359.9vou_rls_tax1_amt: 566.79 4:i.vou_num2023383441vou_hldbk_amt: -710vou_rls_tax1_amt: -92.31 2 data inserted in vourlset VEN_CODE:168 release voucher_tn:2023383440 v_orig_num:2022694503 vrd_rls_amt:387.5v_tax_hldbk_amt: 50.38 3:r.vou_num2022694503vou_hldbk_amt: 4359.9vou_rls_tax1_amt: 566.79 4:i.vou_num2023383440vou_hldbk_amt: -387.5vou_rls_tax1_amt: -50.38 1 2 data inserted in vourlset VEN_CODE:86 release voucher_tn:2023680529 v_orig_num:2023359479 vrd_rls_amt:1645v_tax_hldbk_amt: 213.85 3:r.vou_num2023359479vou_hldbk_amt: 6204vou_rls_tax1_amt: 806.52 4:i.vou_num2023680529vou_hldbk_amt: -3625vou_rls_tax1_amt: -471.26 1 2 data inserted in vourlset VEN_CODE:1391 release voucher_tn:2026170808 v_orig_num:2025630741 vrd_rls_amt:363.97v_tax_hldbk_amt: 47.32 3:r.vou_num2025630741vou_hldbk_amt: 1378.7vou_rls_tax1_amt: 179.23 4:i.vou_num2026170808vou_hldbk_amt: -363.97vou_rls_tax1_amt: -47.32 2 data inserted in vourlset VEN_CODE:1391 release voucher_tn:2026170807 v_orig_num:2025630741 vrd_rls_amt:175.49v_tax_hldbk_amt: 22.81 3:r.vou_num2025630741vou_hldbk_amt: 1378.7vou_rls_tax1_amt: 179.23 4:i.vou_num2026170807vou_hldbk_amt: -175.49vou_rls_tax1_amt: -22.81 1 2 data inserted in vourlset VEN_CODE:2391 release voucher_tn:2023151974 v_orig_num:2022329527 vrd_rls_amt:297.16v_tax_hldbk_amt: 14.86 3:r.vou_num2022329527vou_hldbk_amt: 1200vou_rls_tax1_amt: 60 4:i.vou_num2023151974vou_hldbk_amt: -594.31vou_rls_tax1_amt: -29.72 2 data inserted in vourlset VEN_CODE:2391 release voucher_tn:2023151972 v_orig_num:2022329527 vrd_rls_amt:508.48v_tax_hldbk_amt: 25.42 3:r.vou_num2022329527vou_hldbk_amt: 1200vou_rls_tax1_amt: 60 4:i.vou_num2023151972vou_hldbk_amt: -808.57vou_rls_tax1_amt: -40.43 2 data inserted in vourlset VEN_CODE:2391 release voucher_tn:2023151971 v_orig_num:2022329527 vrd_rls_amt:281.41v_tax_hldbk_amt: 14.07 3:r.vou_num2022329527vou_hldbk_amt: 1200vou_rls_tax1_amt: 60 4:i.vou_num2023151971vou_hldbk_amt: -281.41vou_rls_tax1_amt: -14.07 2 data inserted in vourlset VEN_CODE:2391 release voucher_tn:2023151970 v_orig_num:2022329527 vrd_rls_amt:112.95v_tax_hldbk_amt: 5.65 3:r.vou_num2022329527vou_hldbk_amt: 1200vou_rls_tax1_amt: 60 4:i.vou_num2023151970vou_hldbk_amt: -112.95vou_rls_tax1_amt: -5.65 1 2 data inserted in vourlset VEN_CODE:1768 release voucher_tn:2023049444 v_orig_num:2022461012 vrd_rls_amt:107.5v_tax_hldbk_amt: 5.38 3:r.vou_num2022461012vou_hldbk_amt: 4888.95vou_rls_tax1_amt: 244.45 4:i.vou_num2023049444vou_hldbk_amt: -107.5vou_rls_tax1_amt: -5.38 2 data inserted in vourlset VEN_CODE:1768 release voucher_tn:2023049443 v_orig_num:2022461012 vrd_rls_amt:71.7v_tax_hldbk_amt: 3.59 3:r.vou_num2022461012vou_hldbk_amt: 4888.95vou_rls_tax1_amt: 244.45 4:i.vou_num2023049443vou_hldbk_amt: -71.7vou_rls_tax1_amt: -3.59 2 data inserted in vourlset VEN_CODE:1768 release voucher_tn:2023049442 v_orig_num:2022461012 vrd_rls_amt:21.2v_tax_hldbk_amt: 1.06 3:r.vou_num2022461012vou_hldbk_amt: 4888.95vou_rls_tax1_amt: 244.45 4:i.vou_num2023049442vou_hldbk_amt: -21.2vou_rls_tax1_amt: -1.06 2 data inserted in vourlset VEN_CODE:1768 release voucher_tn:2023049441 v_orig_num:2022461012 vrd_rls_amt:260.8v_tax_hldbk_amt: 13.04 3:r.vou_num2022461012vou_hldbk_amt: 4888.95vou_rls_tax1_amt: 244.45 4:i.vou_num2023049441vou_hldbk_amt: -260.8vou_rls_tax1_amt: -13.04 2 data inserted in vourlset VEN_CODE:1768 release voucher_tn:2023049440 v_orig_num:2022461012 vrd_rls_amt:237.6v_tax_hldbk_amt: 11.88 3:r.vou_num2022461012vou_hldbk_amt: 4888.95vou_rls_tax1_amt: 244.45 4:i.vou_num2023049440vou_hldbk_amt: -237.6vou_rls_tax1_amt: -11.88 2 data inserted in vourlset VEN_CODE:1768 release voucher_tn:2023049439 v_orig_num:2022461012 vrd_rls_amt:548.3v_tax_hldbk_amt: 27.42 3:r.vou_num2022461012vou_hldbk_amt: 4888.95vou_rls_tax1_amt: 244.45 4:i.vou_num2023049439vou_hldbk_amt: -548.3vou_rls_tax1_amt: -27.42 2 data inserted in vourlset VEN_CODE:1768 release voucher_tn:2023049438 v_orig_num:2022461012 vrd_rls_amt:76.5v_tax_hldbk_amt: 3.83 3:r.vou_num2022461012vou_hldbk_amt: 4888.95vou_rls_tax1_amt: 244.45 4:i.vou_num2023049438vou_hldbk_amt: -76.5vou_rls_tax1_amt: -3.83 2 data inserted in vourlset VEN_CODE:1768 release voucher_tn:2023049437 v_orig_num:2022461012 vrd_rls_amt:107.4v_tax_hldbk_amt: 5.37 3:r.vou_num2022461012vou_hldbk_amt: 4888.95vou_rls_tax1_amt: 244.45 4:i.vou_num2023049437vou_hldbk_amt: -107.4vou_rls_tax1_amt: -5.37 2 data inserted in vourlset VEN_CODE:1768 release voucher_tn:2023049436 v_orig_num:2022461012 vrd_rls_amt:104v_tax_hldbk_amt: 5.2 3:r.vou_num2022461012vou_hldbk_amt: 4888.95vou_rls_tax1_amt: 244.45 4:i.vou_num2023049436vou_hldbk_amt: -104vou_rls_tax1_amt: -5.2 1 2 data inserted in vourlset VEN_CODE:2244 release voucher_tn:2023352953 v_orig_num:2022499784 vrd_rls_amt:54.86v_tax_hldbk_amt: 2.74 3:r.vou_num2022499784vou_hldbk_amt: 4484vou_rls_tax1_amt: 224.2 4:i.vou_num2023352953vou_hldbk_amt: -54.86vou_rls_tax1_amt: -2.74 2 data inserted in vourlset VEN_CODE:2244 release voucher_tn:2023352952 v_orig_num:2022499784 vrd_rls_amt:63.05v_tax_hldbk_amt: 3.15 3:r.vou_num2022499784vou_hldbk_amt: 4484vou_rls_tax1_amt: 224.2 4:i.vou_num2023352952vou_hldbk_amt: -63.05vou_rls_tax1_amt: -3.15 1 2 data inserted in vourlset VEN_CODE:2431 release voucher_tn:2026731702 v_orig_num:2025925917 vrd_rls_amt:172.38v_tax_hldbk_amt: 22.41 3:r.vou_num2025925917vou_hldbk_amt: 1350.12vou_rls_tax1_amt: 175.52 4:i.vou_num2026731702vou_hldbk_amt: -689.51vou_rls_tax1_amt: -89.64 2 data inserted in vourlset VEN_CODE:2431 release voucher_tn:2026731697 v_orig_num:2025925917 vrd_rls_amt:1177.74v_tax_hldbk_amt: 153.11 3:r.vou_num2025925917vou_hldbk_amt: 1350.12vou_rls_tax1_amt: 175.52 4:i.vou_num2026731697vou_hldbk_amt: -1285.8vou_rls_tax1_amt: -167.15 1 2 data inserted in vourlset VEN_CODE:2430 release voucher_tn:2026168848 v_orig_num:2025053957 vrd_rls_amt:125v_tax_hldbk_amt: 16.25 3:r.vou_num2025053957vou_hldbk_amt: 6796.75vou_rls_tax1_amt: 883.57 4:i.vou_num2026168848vou_hldbk_amt: -3090vou_rls_tax1_amt: -401.7 1 2 data inserted in vourlset VEN_CODE:2713 release voucher_tn:2027408641 v_orig_num:2027400740 vrd_rls_amt:95.34v_tax_hldbk_amt: 12.39 3:r.vou_num2027400740vou_hldbk_amt: 282.72vou_rls_tax1_amt: 36.75 4:i.vou_num2027408641vou_hldbk_amt: -95.34vou_rls_tax1_amt: -12.39 Start of Block 2 1 2 data inserted in vourlset VEN_CODE:127 release voucher_tn:2023072717 v_orig_num:2022692564 vrd_rls_amt:882.5v_tax_hldbk_amt: 114.73 data update in voucher_tn VEN_CODE:127 release voucher_tn:2022692564 rls_tax:114.73 data update in voucher_tn VEN_CODE:127 release voucher number:2023072717 rls_tax:-220.35 1 2 data inserted in vourlset VEN_CODE:1966 release voucher_tn:2025044801 v_orig_num:2023766546 vrd_rls_amt:431.63v_tax_hldbk_amt: 56.11 data update in voucher_tn VEN_CODE:1966 release voucher_tn:2023766546 rls_tax:56.11 data inserted in vourlset VEN_CODE:1966 release voucher_tn:2025044801 v_orig_num:2023766545 vrd_rls_amt:124.99v_tax_hldbk_amt: 16.25 data update in voucher_tn VEN_CODE:1966 release voucher_tn:2023766545 rls_tax:16.25 data inserted in vourlset VEN_CODE:1966 release voucher_tn:2025044801 v_orig_num:2023434169 vrd_rls_amt:4800v_tax_hldbk_amt: 624 data update in voucher_tn VEN_CODE:1966 release voucher_tn:2023434169 rls_tax:624 data update in voucher_tn VEN_CODE:1966 release voucher number:2025044801 rls_tax:-996.72 1 2 data inserted in vourlset VEN_CODE:130 release voucher_tn:2024019872 v_orig_num:2023705705 vrd_rls_amt:2123.55v_tax_hldbk_amt: 276.06 data update in voucher_tn VEN_CODE:130 release voucher_tn:2023705705 rls_tax:207.28 data update in voucher_tn VEN_CODE:130 release voucher number:2024019872 rls_tax:-306.74 1 2 data inserted in vourlset VEN_CODE:2480 release voucher_tn:2026408577 v_orig_num:2026377008 vrd_rls_amt:342.62v_tax_hldbk_amt: 44.54 data update in voucher_tn VEN_CODE:2480 release voucher_tn:2026377008 rls_tax:44.54 data inserted in vourlset VEN_CODE:2480 release voucher_tn:2026408577 v_orig_num:2024649433 vrd_rls_amt:800v_tax_hldbk_amt: 104 data update in voucher_tn VEN_CODE:2480 release voucher_tn:2024649433 rls_tax:104 data update in voucher_tn VEN_CODE:2480 release voucher number:2026408577 rls_tax:-260 1 2 data inserted in vourlset VEN_CODE:1877 release voucher_tn:2023072713 v_orig_num:2023012205 vrd_rls_amt:1947.28v_tax_hldbk_amt: 0 data update in voucher_tn VEN_CODE:1877 release voucher_tn:2023012205 rls_tax:0 data update in voucher_tn VEN_CODE:1877 release voucher number:2023072713 rls_tax:-625.94 1 2 data inserted in vourlset VEN_CODE:1772 release voucher_tn:2023104117 v_orig_num:2022973009 vrd_rls_amt:164.15v_tax_hldbk_amt: 21.34 data update in voucher_tn VEN_CODE:1772 release voucher_tn:2022973009 rls_tax:34.66 data update in voucher_tn VEN_CODE:1772 release voucher number:2023104117 rls_tax:-21.34 1 2 data inserted in vourlset VEN_CODE:1832 release voucher_tn:2023348927 v_orig_num:2023170922 vrd_rls_amt:353.64v_tax_hldbk_amt: 17.68 data update in voucher_tn VEN_CODE:1832 release voucher_tn:2023170922 rls_tax:17.68 data inserted in vourlset VEN_CODE:1832 release voucher_tn:2023348927 v_orig_num:2023170647 vrd_rls_amt:205.6v_tax_hldbk_amt: 10.28 data update in voucher_tn VEN_CODE:1832 release voucher_tn:2023170647 rls_tax:10.28 data inserted in vourlset VEN_CODE:1832 release voucher_tn:2023348927 v_orig_num:2022819086 vrd_rls_amt:482.5v_tax_hldbk_amt: 24.13 data update in voucher_tn VEN_CODE:1832 release voucher_tn:2022819086 rls_tax:24.13 data inserted in vourlset VEN_CODE:1832 release voucher_tn:2023348927 v_orig_num:2022668330 vrd_rls_amt:167.32v_tax_hldbk_amt: 8.37 data update in voucher_tn VEN_CODE:1832 release voucher_tn:2022668330 rls_tax:18.65 data update in voucher_tn VEN_CODE:1832 release voucher number:2023348927 rls_tax:-141.24 1 2 data inserted in vourlset VEN_CODE:1832 release voucher_tn:2023050160 v_orig_num:2022811747 vrd_rls_amt:506.06v_tax_hldbk_amt: 25.3 data update in voucher_tn VEN_CODE:1832 release voucher_tn:2022811747 rls_tax:25.3 data inserted in vourlset VEN_CODE:1832 release voucher_tn:2023050160 v_orig_num:2022307896 vrd_rls_amt:243.94v_tax_hldbk_amt: 12.2 data update in voucher_tn VEN_CODE:1832 release voucher_tn:2022307896 rls_tax:15.7 data update in voucher_tn VEN_CODE:1832 release voucher number:2023050160 rls_tax:-60 1 2 data inserted in vourlset VEN_CODE:2244 release voucher_tn:2024594539 v_orig_num:2024557625 vrd_rls_amt:223.7v_tax_hldbk_amt: 11.19 data update in voucher_tn VEN_CODE:2244 release voucher_tn:2024557625 rls_tax:11.19 data update in voucher_tn VEN_CODE:2244 release voucher number:2024594539 rls_tax:-33.75 1 2 data inserted in vourlset VEN_CODE:14 release voucher_tn:2027026109 v_orig_num:2026754705 vrd_rls_amt:74.5v_tax_hldbk_amt: 9.69 data update in voucher_tn VEN_CODE:14 release voucher_tn:2026754705 rls_tax:9.69 data inserted in vourlset VEN_CODE:14 release voucher_tn:2027026109 v_orig_num:2026670539 vrd_rls_amt:255.5v_tax_hldbk_amt: 33.22 data update in voucher_tn VEN_CODE:14 release voucher_tn:2026670539 rls_tax:38.74 data update in voucher_tn VEN_CODE:14 release voucher number:2027026109 rls_tax:-42.9 End of Block 2 -- ====================================================================== -- 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 7,644 INDEX 53,580 INDEX PARTITION 80 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,552 SYNONYM 8,006 TABLE 35,948 TABLE PARTITION 21,003 17 TRIGGER 266 TYPE 10,405 6 VIEW -------- ********** -------- 145,265 sum 24 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,303 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,914 sum 1 230 JS80 INDEX 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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,276 4 VIEW -------- ********** -------- 6,311 sum 4 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 388 VIEW -------- ********** -------- 539 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 144 INDEX PARTITION 74 LOB 144 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 50 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,847 sum -------- -------- 165,111 29 =================================================== =================================================================================== == 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-08-19 20:07:08 special list (before special recompiling) 2024-08-19 20:07:09 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-08-19 20:07:11 special list (after special recompiling) 2024-08-19 20:07:12 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,644 INDEX 53,580 INDEX PARTITION 80 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,552 SYNONYM 8,006 TABLE 35,948 TABLE PARTITION 21,003 17 TRIGGER 266 TYPE 10,405 6 VIEW -------- ********** -------- 145,265 sum 24 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,303 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,914 sum 1 230 JS80 INDEX 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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,276 4 VIEW -------- ********** -------- 6,311 sum 4 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 388 VIEW -------- ********** -------- 539 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 144 INDEX PARTITION 74 LOB 144 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 50 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,847 sum -------- -------- 165,111 29 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE 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_JCESTIMATE2ZFP_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATEIMYP_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 DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI 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 19-AUG-24 08.07.14.082815 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-03b SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 2377372_9.sql completed. Output in 2377372_9.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:2377372_10.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-08-19_20_03_58.035/2377372_10.sql.sh to run 2377372_10.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-08-19_20_03_58.035/2377372_10.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-08-19_20_03_58.035/2377372_10.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Mon Aug 19 20:07:14 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.77372, Work Item 10 -- AP - HB not posted/released correctly -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2377372_10.sql Output in 2377372_10.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 7,644 INDEX 53,580 INDEX PARTITION 80 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,552 SYNONYM 8,006 TABLE 35,948 TABLE PARTITION 21,003 17 TRIGGER 266 TYPE 10,405 6 VIEW -------- ********** -------- 145,265 sum 24 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,303 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,914 sum 1 230 JS80 INDEX 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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,276 4 VIEW -------- ********** -------- 6,311 sum 4 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 388 VIEW -------- ********** -------- 539 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 144 INDEX PARTITION 74 LOB 144 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 50 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,847 sum -------- -------- 165,111 29 =================================================== =================================================================================== == 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-08-19 20:07:44 special list (before special recompiling) 2024-08-19 20:07:45 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-08-19 20:07:49 special list (after special recompiling) 2024-08-19 20:07:49 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,644 INDEX 53,580 INDEX PARTITION 80 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,552 SYNONYM 8,006 TABLE 35,948 TABLE PARTITION 21,003 17 TRIGGER 266 TYPE 10,405 6 VIEW -------- ********** -------- 145,265 sum 24 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,303 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,914 sum 1 230 JS80 INDEX 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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,276 4 VIEW -------- ********** -------- 6,311 sum 4 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 388 VIEW -------- ********** -------- 539 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 144 INDEX PARTITION 74 LOB 144 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 50 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,847 sum -------- -------- 165,111 29 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE 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_JCESTIMATE2ZFP_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATEIMYP_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 DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI 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 19-AUG-24 08.07.51.739941 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-03b SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Drop Obsolete Database Objects -- ====================================================================== -- ====================================================================== -- Create Types -- ====================================================================== -- ====================================================================== -- Create Tables -- ====================================================================== Table created. Table created. Table created. -- ====================================================================== -- 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 -- ====================================================================== Start of Block 1 to update voudist and update voucher End of Block 1 to update voudist and update voucher Start of Block 2 End of Block 2 Start of Block 3 to insert,update voudist and update voucher End of Block 3 to update voudist and update voucher -- ====================================================================== -- 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 7,644 INDEX 53,580 INDEX PARTITION 80 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,552 SYNONYM 8,006 TABLE 35,948 TABLE PARTITION 21,003 17 TRIGGER 266 TYPE 10,405 6 VIEW -------- ********** -------- 145,265 sum 24 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,303 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,914 sum 1 230 JS80 INDEX 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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,276 4 VIEW -------- ********** -------- 6,311 sum 4 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 388 VIEW -------- ********** -------- 539 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 144 INDEX PARTITION 74 LOB 144 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 50 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,847 sum -------- -------- 165,111 29 =================================================== =================================================================================== == 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-08-19 20:09:01 special list (before special recompiling) 2024-08-19 20:09:02 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-08-19 20:09:05 special list (after special recompiling) 2024-08-19 20:09:06 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,644 INDEX 53,580 INDEX PARTITION 80 JOB 259 LOB 1 MATERIALIZED VIEW 3,157 PACKAGE 3,150 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,552 SYNONYM 8,006 TABLE 35,948 TABLE PARTITION 21,003 17 TRIGGER 266 TYPE 10,405 6 VIEW -------- ********** -------- 145,265 sum 24 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,303 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,914 sum 1 230 JS80 INDEX 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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,276 4 VIEW -------- ********** -------- 6,311 sum 4 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 388 VIEW -------- ********** -------- 539 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 144 INDEX PARTITION 74 LOB 144 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 50 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,847 sum -------- -------- 165,111 29 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE 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_JCESTIMATE2ZFP_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATEIMYP_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 DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI 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 19-AUG-24 08.09.08.036320 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-03b SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 2377372_10.sql completed. Output in 2377372_10.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.77372 was successfully installed, but with warnings. 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: 0 ---------CRITICAL ERRORS--------- ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- =============================== End of Installation Log Review ===============================