Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/24.85414_CLOUD_122536_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-07-09 12:13:42 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 24.85414, has been installed 2 times on the application server while it is installed 0 times on the database! - File: jspsql/HIK_WKF_Subcontract_WFT.wft: ___________________________________________ Updating: /opt/cm/v12/test/jspsql/HIK_WKF_Subcontract_WFT.wft - size (on disk): 948955 bytes - last modified (on disk): 2024-02-27 19:19:18.0 - size (new file): 949456 bytes - last modified (new file): 2024-06-07 12:02:58.0 - File: jspsql/HIK_WKF_RFI_WFT.wft: ___________________________________ Updating: /opt/cm/v12/test/jspsql/HIK_WKF_RFI_WFT.wft - size (on disk): 723173 bytes - last modified (on disk): 2022-07-18 00:51:17.0 - size (new file): 846017 bytes - last modified (new file): 2024-06-07 12:02:58.0 - File: sql/2485414_2.sql: __________________________ Updating: /opt/cm/v12/test/sql/2485414_2.sql - This is a new file, no information available on disk - size (new file): 8169 bytes - last modified (new file): 2024-06-07 12:07:58.0 - File: sql/wkf_cloudr12_lookups.dat: _____________________________________ Updating: /opt/cm/v12/test/sql/wkf_cloudr12_lookups.dat - size (on disk): 26143 bytes - last modified (on disk): 2023-11-30 14:06:02.0 - size (new file): 29000 bytes - last modified (new file): 2024-06-07 12:07:58.0 - File: jspsql/HIK_WKF_PCI_WFT.wft: ___________________________________ Updating: /opt/cm/v12/test/jspsql/HIK_WKF_PCI_WFT.wft - size (on disk): 770069 bytes - last modified (on disk): 2023-11-01 22:24:52.0 - size (new file): 863487 bytes - last modified (new file): 2024-06-07 12:02:58.0 - File: jspsql/HIK_WKF_OCO_WFT.wft: ___________________________________ Updating: /opt/cm/v12/test/jspsql/HIK_WKF_OCO_WFT.wft - size (on disk): 744109 bytes - last modified (on disk): 2024-02-08 10:03:18.0 - size (new file): 839612 bytes - last modified (new file): 2024-06-07 12:02:58.0 - File: jspsql/HIK_WKF_SCO_WFT.wft: ___________________________________ Updating: /opt/cm/v12/test/jspsql/HIK_WKF_SCO_WFT.wft - size (on disk): 858863 bytes - last modified (on disk): 2023-11-01 22:24:52.0 - size (new file): 865822 bytes - last modified (new file): 2024-06-07 12:02:58.0 Loading file : HIK_WKF_Subcontract_WFT.wft - Command: /opt/cm/ias/j2ee/test/workflow/bin/WFTParser_test.sh -d /opt/cm/v12/test/jspsql/HIK_WKF_Subcontract_WFT.wft Start execution of command /opt/cm/ias/j2ee/test/workflow/bin/WFTParser_test.sh -d /opt/cm/v12/test/jspsql/HIK_WKF_Subcontract_WFT.wft Wait for procedure starts Connecting.. Connected (1.37) Started : 09-Jul-24 12:13:43 Ended : 09-Jul-24 12:14:16 Loading file : HIK_WKF_RFI_WFT.wft - Command: /opt/cm/ias/j2ee/test/workflow/bin/WFTParser_test.sh -d /opt/cm/v12/test/jspsql/HIK_WKF_RFI_WFT.wft Start execution of command /opt/cm/ias/j2ee/test/workflow/bin/WFTParser_test.sh -d /opt/cm/v12/test/jspsql/HIK_WKF_RFI_WFT.wft Wait for procedure starts Connecting.. Connected (1.37) Started : 09-Jul-24 12:14:16 Ended : 09-Jul-24 12:14:41 Loading file : HIK_WKF_PCI_WFT.wft - Command: /opt/cm/ias/j2ee/test/workflow/bin/WFTParser_test.sh -d /opt/cm/v12/test/jspsql/HIK_WKF_PCI_WFT.wft Start execution of command /opt/cm/ias/j2ee/test/workflow/bin/WFTParser_test.sh -d /opt/cm/v12/test/jspsql/HIK_WKF_PCI_WFT.wft Wait for procedure starts Connecting.. Connected (1.37) Started : 09-Jul-24 12:14:41 Ended : 09-Jul-24 12:15:08 Loading file : HIK_WKF_OCO_WFT.wft - Command: /opt/cm/ias/j2ee/test/workflow/bin/WFTParser_test.sh -d /opt/cm/v12/test/jspsql/HIK_WKF_OCO_WFT.wft Start execution of command /opt/cm/ias/j2ee/test/workflow/bin/WFTParser_test.sh -d /opt/cm/v12/test/jspsql/HIK_WKF_OCO_WFT.wft Wait for procedure starts Connecting.. Connected (1.37) Started : 09-Jul-24 12:15:08 Ended : 09-Jul-24 12:15:34 Loading file : HIK_WKF_SCO_WFT.wft - Command: /opt/cm/ias/j2ee/test/workflow/bin/WFTParser_test.sh -d /opt/cm/v12/test/jspsql/HIK_WKF_SCO_WFT.wft Start execution of command /opt/cm/ias/j2ee/test/workflow/bin/WFTParser_test.sh -d /opt/cm/v12/test/jspsql/HIK_WKF_SCO_WFT.wft Wait for procedure starts Connecting.. Connected (1.37) Started : 09-Jul-24 12:15:34 Ended : 09-Jul-24 12:16:02 Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-09_12_16_02.888/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-07-09_12_16_02.888/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-09_12_16_02.888/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 2 The group 0 entry Name Update:2485414_2.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-09_12_16_02.888/2485414_2.sql.sh to run 2485414_2.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-09_12_16_02.888/2485414_2.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-07-09_12_16_02.888/2485414_2.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jul 9 12:16:22 2024 Version 19.23.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. ************************* * Start of dbdefine.sql * ************************* *********************** * End of dbdefine.sql * *********************** ************************* * Connect as DA * ************************* Connected. *********************** * Connected * *********************** -- ====================================================================== -- Work Order 24.85414, Work Item 2 -- Modification to cloud workflows - PM Role code lookups -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2485414_2.sql Output in 2485414_2.lst -- ====================================================================== -- ====================================================================== -- Turn Patch Flag ON -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- Get the initial state of the database -- ====================================================================== PL/SQL procedure successfully completed. -- ==================================================================================================== -- 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,626 INDEX 53,408 INDEX PARTITION 81 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,550 SYNONYM 7,972 TABLE 35,799 TABLE PARTITION 20,888 20 TRIGGER 266 TYPE 10,355 VIEW -------- ********** -------- 144,724 sum 21 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,286 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,897 sum 1 230 JS80 INDEX 17 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 17 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 421 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,225 VIEW -------- ********** -------- 6,260 sum 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 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 -------- -------- 164,493 22 =================================================== =================================================================================== == 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-09 12:16:37 special list (before special recompiling) 2024-07-09 12:16:37 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-09 12:16:38 special list (after special recompiling) 2024-07-09 12:16:38 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,626 INDEX 53,408 INDEX PARTITION 81 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,550 SYNONYM 7,972 TABLE 35,799 TABLE PARTITION 20,888 20 TRIGGER 266 TYPE 10,355 VIEW -------- ********** -------- 144,724 sum 21 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,286 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,897 sum 1 230 JS80 INDEX 17 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 17 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 421 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,225 VIEW -------- ********** -------- 6,260 sum 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 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 -------- -------- 164,493 22 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTBIU_OSHEA_0035_1736951118 DA TRIGGER DBTBIU_OSHEA_0036_1740233151 DA TRIGGER DBTBIU_OSHEA_0042_2184344894 DA TRIGGER DBTBIU_OSHEA_0045_2305347441 DA TRIGGER DBTBIU_PRISM_0002_1682955575 DA TRIGGER DBTBIU_USCCONV3_000_1090700249 DA TRIGGER DBTBIU_USCPROD_0002_1208036606 DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST24RM_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST39KQ_OBJSEQ DA TRIGGER DBTI_UETD_CHKDISTYOQ3_OBJSEQ DA TRIGGER DBTI_UETD_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 09-JUL-24 12.16.40.345939 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-02e SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Drop Obsolete Database Objects -- ====================================================================== -- ====================================================================== -- Create Types -- ====================================================================== -- ====================================================================== -- Create Tables -- ====================================================================== -- ====================================================================== -- Add Columns -- ====================================================================== -- ====================================================================== -- Install Table and Column Comments -- ====================================================================== -- ====================================================================== -- Create Sequences -- ====================================================================== -- ====================================================================== -- Install Keys and Constraints -- ====================================================================== PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. -- ====================================================================== -- 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 -- ====================================================================== PL/SQL procedure successfully completed. SC SCO FYI to Submitter at End has been updated. XDepartment Invoice Approver 1 has been updated. Department Invoice Approver 2 has been updated. Department Invoice Approver 3 has been updated. Department Invoice Approver 4 has been updated. Department Level 1 Timeout Days has been updated. XDepartment Level 2 Timeout Days has been updated. XDepartment Level 3 Timeout Days has been updated. XDepartment Level 4 Timeout Days has been updated. XDepartment Timeout Recipient 1 has been updated. Department Timeout Recipient 2 has been updated. Department Timeout Recipient 3 has been updated. Department Timeout Recipient 4 has been updated. FYI On Approval Of OCO has been updated. XFYI On Approval Of PCI has been updated. XFYI On Approval Of RFI has been updated. XOCO Approver 1 has been updated. OCO Approver 2 has been updated. OCO Level 1 Timeout Days has been updated. XOCO Level 2 Timeout Days has been updated. XOCO PM Role Code 1 has been updated. XOCO PM Role Code 2 has been updated. XOCO Timeout Recipient 1 has been updated. OCO Timeout Recipient 2 has been updated. PCI Approved Status Code has been updated. XPCI Approver 1 has been updated. PCI Approver 2 has been updated. PCI Level 1 Timeout Days has been updated. XPCI Level 2 Timeout Days has been updated. XPCI PM Role Code 1 has been updated. XPCI PM Role Code 2 has been updated. XPCI Rejected Status Code has been updated. XPCI Timeout Recipient 1 has been updated. PCI Timeout Recipient 2 has been updated. PO Inv Dept Approver 1 has been updated. PO Inv Dept Approver 2 has been updated. PO Inv Dept Level 1 Timeout Days has been updated. XPO Inv Dept Level 2 Timeout Days has been updated. XPO Inv Dept Timeout Recipient 1 has been updated. PO Inv Dept Timeout Recipient 2 has been updated. PO Inv Job Approver 1 has been updated. PO Inv Job Approver 2 has been updated. PO Inv Level 1 Timeout Days has been updated. XPO Inv Level 2 Timeout Days has been updated. XPO Inv PM Role Code 1 has been updated. PO Inv PM Role Code 2 has been updated. PO Inv Timeout Recipient 1 has been updated. PO Inv Timeout Recipient 2 has been updated. PO Job Timeout level 1 has been updated. XPO Job Timeout level 2 has been updated. XPO Job Timeout Recipient PM Role Code 1 has been updated. PO Job Timeout Recipient PM Role Code 2 has been updated. PO Job Timeout Recipient PM Role Code 3 has been updated. Post OCO in Workflow has been updated. XPost PCI in Workflow has been updated. XPost PO Invoice in Workflow has been updated. XPost Reg RFP in Workflow has been updated. XPost SC RFP in Workflow has been updated. XPost SCO in Workflow has been updated. XPost Subcontract in Workflow has been updated. XProject Setup Specialist has been updated. XRFI Approved Status Code has been updated. RFI Approver 1 has been updated. RFI Approver 2 has been updated. RFI Level 1 Timeout Days has been updated. XRFI Level 2 Timeout Days has been updated. XRFI PM Role Code 1 has been updated. XRFI PM Role Code 2 has been updated. XRFI Timeout Recipient 1 has been updated. RFI Timeout Recipient 2 has been updated. RFQ Response Recipient has been updated. RFQ Response Recipient Role 1 has been updated. RFQ Response Recipient Role 2 has been updated. Reg Inv Job Approver 1 has been updated. Reg Inv Job Approver 2 has been updated. Reg Inv Job Approver 3 has been updated. Reg Inv Job Approver 4 has been updated. Reg Inv Level 1 Timeout Days has been updated. XReg Inv Level 2 Timeout Days has been updated. XReg Inv Level 3 Timeout Days has been updated. XReg Inv Level 4 Timeout Days has been updated. XReg Inv PM Role Code 1 has been updated. Reg Inv PM Role Code 2 has been updated. Reg Inv PM Role Code 3 has been updated. Reg Inv PM Role Code 4 has been updated. Reg Inv Timeout Recipient 1 has been updated. Reg Inv Timeout Recipient 2 has been updated. Reg Inv Timeout Recipient 3 has been updated. Reg Inv Timeout Recipient 4 has been updated. SC RFP Approver 1 has been updated. SC RFP Approver 2 has been updated. SC RFP Approver 3 has been updated. SC RFP Approver 4 has been updated. SC RFP Level 1 Timeout Days has been updated. XSC RFP Level 2 Timeout Days has been updated. XSC RFP Level 3 Timeout Days has been updated. XSC RFP Level 4 Timeout Days has been updated. XSC RFP PM Role Code 1 has been updated. SC RFP PM Role Code 2 has been updated. SC RFP PM Role Code 3 has been updated. SC RFP PM Role Code 4 has been updated. SC RFP Step 2 Mandatory Flag has been updated. XSC RFP Step 3 Mandatory Flag has been updated. XSC RFP Step 4 Mandatory Flag has been updated. XSC RFP Timeout Recipient 1 has been updated. SC RFP Timeout Recipient 2 has been updated. SC RFP Timeout Recipient 3 has been updated. SC RFP Timeout Recipient 4 has been updated. SCO Approver 1 has been updated. SCO Approver 2 has been updated. SCO Level 1 Timeout Days has been updated. XSCO Level 2 Timeout Days has been updated. XSCO Level 3 Timeout Days has been updated. XSCO PM Role Code 1 has been updated. XSCO PM Role Code 2 has been updated. XSCO Timeout Recipient 1 has been updated. SCO Timeout Recipient 2 has been updated. Subcontract Approver 1 has been updated. Subcontract Approver 2 has been updated. Subcontract Level 1 Timeout Days has been updated. XSubcontract Level 2 Timeout Days has been updated. XSubcontract PM Role Code 1 has been updated. XSubcontract PM Role Code 2 has been updated. XSubcontract PM Role Code 3 has been updated. XSubcontract Timeout Recipient 1 has been updated. Subcontract Timeout Recipient 2 has been updated. Timeout Minutes - External Pre-qual approvers has been updated. Timeout Minutes - Internal Pre-qual approvers has been updated. Prequal Timeout Days External has been updated. Prequal Timeout Days Internal has been updated. Validate AP Invoice Balance has been updated. XValidate SC RFP Balance has been updated. XDepartment Approver 2 Bypass Amount has been updated. XDepartment Approver 3 Bypass Amount has been updated. XJob Approver 2 Bypass Amount has been updated. XJob Approver 3 Bypass Amount has been updated. XUse PO Routing Job for PO Invoice has been updated. Reg Inv Timeout Recipient PM Role Code 1 has been updated. Reg Inv Timeout Recipient PM Role Code 2 has been updated. Reg Inv Timeout Recipient PM Role Code 3 has been updated. Reg Inv Timeout Recipient PM Role Code 4 has been updated. SC RFP Timeout Recipient PM Role Code 1 has been updated. SC RFP Timeout Recipient PM Role Code 2 has been updated. SC RFP Timeout Recipient PM Role Code 3 has been updated. SC RFP Timeout Recipient PM Role Code 4 has been updated. Subcontract Timeout Recipient PM Role Code 1 has been updated. Subcontract Timeout Recipient PM Role Code 2 has been updated. Subcontract Timeout Recipient PM Role Code 3 has been updated. PO Inv Job Approver 3 has been updated. PO Inv Job Approver 4 has been updated. PO Inv Timeout Recipient 3 has been updated. PO Inv Timeout Recipient 4 has been updated. PO Inv PM Role Code 3 has been updated. PO Inv PM Role Code 4 has been updated. PO Inv Job Timeout Recipient PM Role Code 1 has been updated. PO Inv Job Timeout Recipient PM Role Code 2 has been updated. PO Inv Job Timeout Recipient PM Role Code 3 has been updated. PO Inv Job Timeout Recipient PM Role Code 4 has been updated. PO Inv Level 3 Timeout Days has been updated. XPO Inv Level 4 Timeout Days has been updated. XPO Inv Dept Approver 3 has been updated. PO Inv Dept Approver 4 has been updated. PO Inv Dept Timeout Recipient 3 has been updated. PO Inv Dept Timeout Recipient 4 has been updated. PO Inv Dept Level 3 Timeout Days has been updated. XPO Inv Dept Level 4 Timeout Days has been updated. XPCI Timeout Recipient PM Role Code 1 has been updated. PCI Timeout Recipient PM Role Code 2 has been updated. PCI Timeout Recipient PM Role Code 3 has been inserted. SC SCO Approver 3 has been updated. Timeout Recipient 3 has been updated. Subcontract Level 3 Timeout Days has been updated. XSCO Timeout Recipient PM Role Code 1 has been updated. SCO Timeout Recipient PM Role Code 2 has been updated. SCO Timeout Recipient PM Role Code 3 has been updated. OCO Timeout Recipient PM Role Code 1 has been updated. OCO Timeout Recipient PM Role Code 2 has been updated. OCO Timeout Recipient PM Role Code 3 has been inserted. RFI Timeout Recipient PM Role Code 1 has been updated. RFI Timeout Recipient PM Role Code 2 has been updated. RFI Timeout Recipient PM Role Code 3 has been inserted. Do Not Post External PCIs has been updated. Populate PO Invoice Details at Start has been updated. XInterval for First Notice has been updated. Interval for Second Notice has been updated. Job Approver 2 Bypass Amount has been updated. Job Approver 3 Bypass Amount has been updated. PO Inv PM Role Code 3 has been updated. PO Job Threshold 1 has been inserted. PO Job Threshold 2 has been inserted. PO Job Threshold 3 has been inserted. PO Job Timeout Level 1 has been inserted. PO Job Timeout Level 2 has been inserted. PO Job Timeout Level 3 has been inserted. SCO PM Role Code 3 has been inserted. Validate AP Invoice Balance at Start has been updated. Validate RFP Against Contract Balance has been inserted. Validate SC RFP Balance at Start has been updated. PCI PM Role Code 3 has been inserted. PCI Approver 3 has been inserted. PCI Level 3 Timeout Days has been inserted. PCI Timeout Recipient 3 has been inserted. OCO PM Role Code 3 has been inserted. OCO Approver 3 has been inserted. OCO Level 3 Timeout Days has been inserted. OCO Timeout Recipient 3 has been inserted. RFI PM Role Code 3 has been inserted. RFI Approver 3 has been inserted. RFI Level 3 Timeout Days has been inserted. RFI Timeout Recipient 3 has been inserted. PL/SQL procedure successfully completed. -- ====================================================================== -- Get the current State of the Database -- ====================================================================== PL/SQL procedure successfully completed. -- ==================================================================================================== -- 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,626 INDEX 53,408 INDEX PARTITION 81 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,550 SYNONYM 7,972 TABLE 35,799 TABLE PARTITION 20,888 20 TRIGGER 266 TYPE 10,355 VIEW -------- ********** -------- 144,724 sum 21 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,286 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,897 sum 1 230 JS80 INDEX 17 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 17 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 421 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,225 VIEW -------- ********** -------- 6,260 sum 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 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 -------- -------- 164,493 22 =================================================== =================================================================================== == 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-09 12:16:54 special list (before special recompiling) 2024-07-09 12:16:55 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-09 12:16:55 special list (after special recompiling) 2024-07-09 12:16:56 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,626 INDEX 53,408 INDEX PARTITION 81 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,550 SYNONYM 7,972 TABLE 35,799 TABLE PARTITION 20,888 20 TRIGGER 266 TYPE 10,355 VIEW -------- ********** -------- 144,724 sum 21 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,286 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,897 sum 1 230 JS80 INDEX 17 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 17 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 421 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 797 JSR PACKAGE 797 PACKAGE BODY 2 SYNONYM 2,892 VIEW -------- ********** -------- 4,488 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,225 VIEW -------- ********** -------- 6,260 sum 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 386 VIEW -------- ********** -------- 537 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 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 -------- -------- 164,493 22 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTBIU_OSHEA_0035_1736951118 DA TRIGGER DBTBIU_OSHEA_0036_1740233151 DA TRIGGER DBTBIU_OSHEA_0042_2184344894 DA TRIGGER DBTBIU_OSHEA_0045_2305347441 DA TRIGGER DBTBIU_PRISM_0002_1682955575 DA TRIGGER DBTBIU_USCCONV3_000_1090700249 DA TRIGGER DBTBIU_USCPROD_0002_1208036606 DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST24RM_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST39KQ_OBJSEQ DA TRIGGER DBTI_UETD_CHKDISTYOQ3_OBJSEQ DA TRIGGER DBTI_UETD_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 09-JUL-24 12.16.57.668162 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-02e SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 2485414_2.sql completed. Output in 2485414_2.LST -- ====================================================================== Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 1 deployment dir /opt/cm/ias/j2ee/test/deployment/deploy Case 4 Issue 24.85414 was successfully installed. As specified with --no-deploy option, JSPs did not get deployed. Deploy JSPs manually Installation Log Review: ======================== ---------SUMMARY--------- Critical Errors: 0 Warning Errors: 0 Informative Errors: 0 ---------CRITICAL ERRORS--------- ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- =============================== End of Installation Log Review ===============================