Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/23.77372_CLOUD_343299_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-07-24 20:10:16 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 8 times on the application server while it is installed 0 times on the database! - File: sql/2377372_8.sql: __________________________ Updating: /opt/cm/v12/test/sql/2377372_8.sql - This is a new file, no information available on disk - size (new file): 22181 bytes - last modified (new file): 2024-07-22 09:52:28.0 - File: sql/2377372_7.sql: __________________________ Updating: /opt/cm/v12/test/sql/2377372_7.sql - This is a new file, no information available on disk - size (new file): 26582 bytes - last modified (new file): 2024-07-22 09:51:38.0 Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-24_20_10_18.26/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-07-24_20_10_18.26/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-24_20_10_18.26/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 3 The group 0 entry Name Update:2377372_7.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-24_20_10_18.26/2377372_7.sql.sh to run 2377372_7.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-24_20_10_18.26/2377372_7.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-07-24_20_10_18.26/2377372_7.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 24 20:11:08 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 7 -- 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_7.sql Output in 2377372_7.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,627 INDEX 52,447 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,986 TABLE 34,833 TABLE PARTITION 20,838 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,760 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 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 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 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,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 162,614 46 =================================================== =================================================================================== == 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-07-24 20:11:46 special list (before special recompiling) 2024-07-24 20:11:58 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-24 20:12:09 special list (after special recompiling) 2024-07-24 20:12:20 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,627 INDEX 52,447 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,986 TABLE 34,833 TABLE PARTITION 20,838 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,760 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 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 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 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,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 162,614 46 ========================================================================== 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 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 24-JUL-24 08.12.25.499381 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-02j 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:1877 release voucher_tn:2023072713 v_orig_num:2023012205 vrd_rls_amt:1947.28v_tax_hldbk_amt: 253.15 3:r.vou_num2023012205vou_hldbk_amt: 1947.28vou_rls_tax1_amt: 0 4:i.vou_num2023072713vou_hldbk_amt: -4814.95vou_rls_tax1_amt: -625.94 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 Block 2: error code -1 error message:ORA-00001: unique constraint (DA.VOURLSDET_PK) violated -- ====================================================================== -- 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,627 INDEX 52,447 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,986 TABLE 34,833 TABLE PARTITION 20,838 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,760 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 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 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 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,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 162,614 46 =================================================== =================================================================================== == 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-07-24 20:13:55 special list (before special recompiling) 2024-07-24 20:13:59 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-24 20:14:20 special list (after special recompiling) 2024-07-24 20:14:29 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,627 INDEX 52,447 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,986 TABLE 34,833 TABLE PARTITION 20,838 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,760 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 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 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 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,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 162,614 46 ========================================================================== 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 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 24-JUL-24 08.14.35.152945 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-02j SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 2377372_7.sql completed. Output in 2377372_7.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_8.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-24_20_10_18.26/2377372_8.sql.sh to run 2377372_8.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-24_20_10_18.26/2377372_8.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-07-24_20_10_18.26/2377372_8.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 24 20:14:35 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,627 INDEX 52,447 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,986 TABLE 34,833 TABLE PARTITION 20,838 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,760 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 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 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 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,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 162,614 46 =================================================== =================================================================================== == 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-07-24 20:15:27 special list (before special recompiling) 2024-07-24 20:15:35 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-24 20:15:47 special list (after special recompiling) 2024-07-24 20:15:51 end additional_compx.sql =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,627 INDEX 52,447 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,986 TABLE 34,833 TABLE PARTITION 20,838 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,760 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 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 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 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,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 162,614 46 ========================================================================== 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 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 24-JUL-24 08.16.03.529498 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-02j 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 -- ====================================================================== select * from da.voucher_tn where vou_tenant_id = da.dbk_sys_uig_audit.get_current_client_id * ERROR at line 2: ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT 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,627 INDEX 52,447 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,986 TABLE 34,833 TABLE PARTITION 20,838 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,760 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 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 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 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,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 162,614 46 =================================================== =================================================================================== == 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-07-24 20:17:45 special list (before special recompiling) 2024-07-24 20:17:48 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-24 20:17:59 special list (after special recompiling) 2024-07-24 20:18: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,627 INDEX 52,447 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,986 TABLE 34,833 TABLE PARTITION 20,838 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,760 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 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 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,490 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,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 150 INDEX PARTITION 74 LOB 150 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 52 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,861 sum -------- -------- 162,614 46 ========================================================================== 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 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 24-JUL-24 08.18.08.016637 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-02j 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 2 deployment dir /opt/cm/ias/j2ee/test/deployment/deploy Case 4 Issue 23.77372 was successfully installed. As specified with --no-deploy option, JSPs did not get deployed. Deploy JSPs manually Installation Log Review: ======================== ---------SUMMARY--------- Critical Errors: 1 Warning Errors: 0 Informative Errors: 1 ---------CRITICAL ERRORS--------- 853 | 2 854 | data inserted in vourlset VEN_CODE:1877 release voucher_tn:2023072713 v_orig_num:2023012205 vrd_rls_amt:1947.28v_tax_hldbk_amt: 0 855 | Block 2: error code -1 error message:ORA-00001: unique constraint (DA.VOURLSDET_PK) violated 856 | -- ====================================================================== ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- 1654 | * 1655 | ERROR at line 2: 1656 | ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT 1657 | =============================== End of Installation Log Review ===============================