Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/23.79653_CLOUD_138724_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-07-10 15:12:29 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.79653, has been installed 4 times on the application server while it is installed 0 times on the database! - File: sql/2379653_4.sql: __________________________ Updating: /opt/cm/v12/test/sql/2379653_4.sql - This is a new file, no information available on disk - size (new file): 7580 bytes - last modified (new file): 2024-05-10 11:32:50.0 - File: sql/2379653_3.sql: __________________________ Updating: /opt/cm/v12/test/sql/2379653_3.sql - This is a new file, no information available on disk - size (new file): 70557 bytes - last modified (new file): 2024-05-10 10:54:16.0 Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-10_15_12_30.677/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-07-10_15_12_30.677/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-10_15_12_30.677/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 3 The group 0 entry Name Update:2379653_3.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-10_15_12_30.677/2379653_3.sql.sh to run 2379653_3.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-10_15_12_30.677/2379653_3.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-07-10_15_12_30.677/2379653_3.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 10 15:12:39 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.79653, Work Item 3 -- PWPS different for two emps with same calculated PWF. -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2379653_3.sql Output in 2379653_3.lst -- ====================================================================== -- ====================================================================== -- Turn Patch Flag ON -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- Get the initial 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,626 INDEX 53,408 INDEX PARTITION 105 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 1 PACKAGE 3,149 4 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,975 TABLE 35,800 TABLE PARTITION 20,888 21 TRIGGER 266 TYPE 10,354 VIEW -------- ********** -------- 144,752 sum 27 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 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 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 1 VIEW -------- ********** -------- 6,260 sum 1 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 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 -------- -------- 164,539 29 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== start additional_compx.sql 2024-07-10 15:12:45 special list (before special recompiling) 2024-07-10 15:12:45 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-10 15:12:46 special list (after special recompiling) 2024-07-10 15:12:46 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 105 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 1 PACKAGE 3,149 4 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,975 TABLE 35,800 TABLE PARTITION 20,888 21 TRIGGER 266 TYPE 10,354 VIEW -------- ********** -------- 144,752 sum 27 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 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 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 1 VIEW -------- ********** -------- 6,260 sum 1 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 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 -------- -------- 164,539 29 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PACKAGE DBK_RTI_PY_EMPLOYEE DA PACKAGE BODY DBK_HREMPAPP DA PACKAGE BODY DBK_PY_EMP_IMP DA PACKAGE BODY DBK_PY_INTEGRATION DA PACKAGE BODY DBK_RTI_PY_EMPLOYEE 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 DA TRIGGER DBT_I_IUD_RTI#PYEMPLOYEE DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 10-JUL-24 03.12.47.341968 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 -- ====================================================================== old 240: tablespace &vtab new 240: tablespace USERS CREATE TABLE DA.PYEMPTIMSHT_LOGGER_TN * ERROR at line 1: ORA-00955: name is already used by an existing object Grant succeeded. Grant succeeded. create_z_audit_columns_a - create columns TO_CHAR(SYSDATE,' ----------------- 20240710 15:12:47 1 row selected. (1) Correction to UETD column_names with too many underscores (no longer needed) TO_CHAR(SYSDATE,' ----------------- 20240710 15:12:47 1 row selected. Work table TO_CHAR(SYSDATE,' ----------------- 20240710 15:12:47 1 row selected. drop table da.clean_temp_1271010 * ERROR at line 1: ORA-00942: table or view does not exist drop table da.clean_temp_1271010b * ERROR at line 1: ORA-00942: table or view does not exist Table dropped. Table dropped. Recyclebin purged. Table created. 29 rows deleted. Commit complete. 3533 rows deleted. Commit complete. 387599 rows deleted. Commit complete. 0 rows deleted. Commit complete. 0 rows deleted. Commit complete. 0 rows deleted. Commit complete. 0 rows deleted. Commit complete. TO_CHAR(SYSDATE,' ----------------- 20240710 15:13:10 1 row selected. Table created. must return no rows no rows selected no rows selected TO_CHAR(SYSDATE,' ----------------- 20240710 15:13:11 1 row selected. Creating "__IU__" auditing columns t1=1 t2=1 t3=1 t4=1 PL/SQL procedure successfully completed. create _TENANT_ID columns (except for da.seqnum_TN) TO_CHAR(SYSDATE,'YY ------------------- 2024-07-10 15:13:11 1 row selected. t5=1 PL/SQL procedure successfully completed. add _LAST_SESSIONINFO TO_CHAR(SYSDATE,'YY ------------------- 2024-07-10 15:13:11 1 row selected. t5=1 PL/SQL procedure successfully completed. add _ORIG_SESSIONINFO TO_CHAR(SYSDATE,'YY ------------------- 2024-07-10 15:13:11 1 row selected. t5=1 PL/SQL procedure successfully completed. TO_CHAR(SYSDATE,'YY ------------------- 2024-07-10 15:13:11 1 row selected. '__IU__' Auditing columns SUBSTR(COLUMN_NAM ------------------------- ----------------- 1 REATE_PERIOD 7546 _CREATE_DATE 7545 _CREATE_USER 7667 _LAST_SESSIONINFO 7670 _ORIG_SESSIONINFO 7698 _TENANT_ID 7543 _UPDATE_DATE 7543 _UPDATE_USER 8 rows selected. Table IU-column count (not 4) ------------------------------ ----------------------- SKELETAL_IUD_EVENT_TN 5 AGI_ACTIVE_PROJECT_TMP 5 IMG_DOCUMENTS_REV_GTT 2 IMG_DOCUMENTS_REV_JBBU_GTT 2 PYEMPTIMSHT_LOG 8 5 rows selected. TO_CHAR(SYSDATE,' ----------------- 20240710 15:13:18 1 row selected. Update DA.IMG_FLYSHEETS_TABLE Package altered. Package body altered. No errors. No errors. 107 rows updated. Commit complete. TO_CHAR(SYSDATE,' ----------------- 20240710 15:13:19 1 row selected. TENANT without audit TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------- DC_ACCOUNT DC_ADDRESS DC_APREGINV DC_AP_VOU_MAP_TABLE DC_BABANK DC_BABANKACCT DC_BABRANCH DC_BPADDRESSES DC_BPARTNERS DC_BPARTNERSPRQINFO DC_BPBANKS DC_BPCLASSIFICATION DC_BPCSICODE DC_BPCUSTOMERS DC_BPMARKETSECTOR DC_BPVENDORS DC_CHQPAYEE DC_CIITEM DC_CIITEMDET DC_CIITEMHDR DC_CISTDCST DC_CITALTUM DC_CMDETAIL_POSTED DC_DEPT_TABLE DC_EMACTUALLOCATION DC_EMDETAIL DC_EMEQPCLASS DC_EMEQPCOMTRAN DC_EMEQPHCOMPON DC_EMEQUIPMENT DC_EMLOCHIST DC_EMTRANPOST DC_FAASSET DC_GLEDGER DC_HRELECTEDPLANS_EM DC_HREMRELATIVES DC_HRPOSITIONS DC_HRPOSITIONS_TABLE DC_INVDIST DC_INVMEMO DC_INVRLSDET DC_JBBILL DC_JBBILLDET DC_JBCONT DC_JBCONTDET DC_JBGROUP DC_JBGROUP_V1 DC_JB_BILLING_RATE_DETAIL DC_JB_BILLING_RATE_HEADER DC_JCDETAIL DC_JCJOBHPHS DC_JCJOBSECGRPJOB DC_JCJOBSECGRPPROJ DC_JCJOBSECGRPUSER DC_JCJOB_TABLE DC_JCMPHS DC_JCPROFITPLAN_JOBS DC_JCPROFITPLAN_PERIOD DC_JCPROFITPLAN_WIP DC_JCTCAT DC_JCTIME_PHASED_FIN_FCST DC_JCTPHS DC_JCUTRAN DC_JCWIPTMJOBS DC_LOCATION_TABLE DC_OMCLASSIFIERVAL DC_OMOPPOCOMPETITOR DC_OMOPPORTUNITY DC_OMOPPORTUNITY_DATA_SHEET DC_OMOPPORTUNITY_NOTES DC_OMORGANIZATION_NOTES DC_OMORGANIZATION_TABLE DC_OMORGBUILDINGTYPE DC_OMSALESTEAM DC_OM_GENERAL_UED DC_ORGANIZATION_DETAIL_UED DC_PAYCHQ DC_PMBIDPACKAGE DC_PMDESCRIPTION DC_PMHISTORY DC_PMJOURMAT DC_PMMEETING DC_PMMEETINGITEM DC_PMMEETINGTRACK DC_PMNOTES DC_PMPROJCONTACT DC_PMPROJCONTACTROLE DC_PMPROJECTITEM DC_PMPROJECT_TABLE DC_PMPROJPARTNER DC_PMPRQFINANCIALINFO DC_PMRFI DC_PMROLE DC_PMSBMTPDETAIL DC_PMSUBMITPACKAGE DC_PMSUBMITTAL DC_PMTRANSMITTAL_TABLE DC_POCODET DC_POCOMAST DC_PODETAIL DC_POFFITM DC_POMAST DC_POSHIPMDET DC_POSHIPMENT DC_PRMCLASSACCUMS DC_PRMWORKITEMS_POSTED DC_PYACCESSCODE DC_PYCHECKS DC_PYCHKLOC DC_PYCOMMAX DC_PYEMPBEN DC_PYEMPDED DC_PYEMPLEAVE DC_PYEMPLEAVEHIST DC_PYEMPLOAN DC_PYEMPLOYEE_TABLE DC_PYEMPPAYHIST DC_PYEMPPAYRATE DC_PYEMPSALSPL DC_PYEMPSECGRPEMP DC_PYEMPTIMSHT DC_PYJOBBEN DC_PYJOBPAYRATE DC_PYPLCODE DC_PYTAXEMP DC_PYTAXEXM DC_PYUNIBEN DC_PYUNIDED DC_PYUNIPAYRATE DC_PYWCBENEFIT DC_PYWORKLOC DC_SCMAST_MINORITY_PART DC_SCP_VENDOR_CIS_INFO DC_SYSACTIONITEMS_UED DC_SYSADDRESS DC_SYSCONTACT DC_SYSCONTACT_REFERENCE DC_TERM DC_VOUCHER DC_VOUCHQ DC_VOUDIST DC_VOUDIST_RB_DIST_CAT_CODE DC_VOUDIST_RB_DIST_CHECK DC_VOUDIST_RB_REMAIN_ERRORS_1 DC_VOUDIST_RB_VDIST_BCH_NUM DC_VOUDIST_REM DC_VOUDIST_V1 DC_VOUMEMO DC_VOURLSDET DC_WGTCONV MLOG$_PYEMPPAYHIST_TN PYEMPPAYHIST_BEN_TN_MV RTI_TEXTURA_FILE_IMPORT_TN 153 rows selected. TENANT without last_sessioninfo TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------- DC_CHQPAYEE DC_EMACTUALLOCATION DC_EMDETAIL DC_EMEQPCOMTRAN DC_EMEQPHCOMPON DC_EMRATE_V DC_EMTRANPOST DC_INVMEMO DC_JBGROUP DC_JBGROUP_V1 DC_JCJOBSECGRPUSER DC_JCUTRAN DC_OMCLASSIFIERVAL DC_OMOPPOCOMPETITOR DC_OMOPPORTUNITY_DATA_SHEET DC_OMOPPORTUNITY_NOTES DC_OMORGANIZATION_NOTES DC_OMORGBUILDINGTYPE DC_OM_GENERAL_UED DC_ORGANIZATION_DETAIL_UED DC_SYSACTIONITEMS_UED DC_SYSCONTACT_REFERENCE IMG_DOCUMENTS_REV_JBBU_GTT MLOG$_PYEMPPAYHIST_TN PYEMPPAYHIST_BEN_TN_MV RTI_TEXTURA_FILE_IMPORT_TN 26 rows selected. TENANT without orig_sessioninfo TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------- DC_CHQPAYEE DC_EMACTUALLOCATION DC_EMDETAIL DC_EMEQPCOMTRAN DC_EMEQPHCOMPON DC_EMRATE_V DC_EMTRANPOST DC_INVMEMO DC_JBGROUP DC_JBGROUP_V1 DC_JCJOBSECGRPUSER DC_JCUTRAN DC_OMCLASSIFIERVAL DC_OMOPPOCOMPETITOR DC_OMOPPORTUNITY_DATA_SHEET DC_OMOPPORTUNITY_NOTES DC_OMORGANIZATION_NOTES DC_OMORGBUILDINGTYPE DC_OM_GENERAL_UED DC_ORGANIZATION_DETAIL_UED DC_SYSACTIONITEMS_UED DC_SYSCONTACT_REFERENCE IMG_DOCUMENTS_REV_JBBU_GTT MLOG$_PYEMPPAYHIST_TN PYEMPPAYHIST_BEN_TN_MV RTI_TEXTURA_FILE_IMPORT_TN 26 rows selected. audit without TENANT TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------- IMG_DOCUMENTS_REV_GTT INVDIST_GTT MS_BILLING_INVOICE_TAX_GTT RS_DISPATCH_GTT SD_CMIC_OBJECTS 5 rows selected. create_z_audit_columns_b - create triggers work table TO_CHAR(SYSDATE,'YY ------------------- 2024-07-10 15:13:30 1 row selected. drop table da.clean_temp_1271010c * ERROR at line 1: ORA-00942: table or view does not exist Table dropped. Recyclebin purged. Table created. TO_CHAR(SYSDATE,'YY ------------------- 2024-07-10 15:13:30 1 row selected. PL/SQL procedure successfully completed. TO_CHAR(SYSDATE,'YY ------------------- 2024-07-10 15:13:30 1 row selected. create triggers (table da.seqnum_TN must have a different form of the trigger) 5 5 PL/SQL procedure successfully completed. 0 PL/SQL procedure successfully completed. TO_CHAR(SYSDATE,'YY ------------------- 2024-07-10 15:13:31 1 row selected. 'DBTA_' Auditing triggers 'DBTI_' Auditing triggers Trg Stat Obj Sta ------------------------- ------------------------- -------- ------- 7470 7714 ENABLED VALID 0 2 DISABLED VALID 0 11 ENABLED INVALID 3 rows selected. no rows selected no rows selected multiple 'DBTI_' triggers -------------------------------------------------------------------------------------------------------------------------------- UETD_JCESTIMATE9G1Q UETD_EMP401KWKUH UETD_JCWBSVWKUH UETD_JCESTIMATEWKUH UETD_EMP_CUSTOM9TR7 UETD_EMP_ST_SUIFHND UETD_CONTRACTJJKV UETD_CHKDISTQNH0 UETD_ADDTARAGETNUK UETD_LICNUMTPHQ UETD_CHKDIST7T15 UETD_MILESTONEJJKV UETD_LICENSE6YCF UETD_CHKDISTMBKW UETD_JCWBSVCAJB UETD_JCESTIMATEQVHY UETD_LK_PROJ9TN0 UETD_CHKDISTG7CF UETD_ABCG7BK UETD_JCWBSVQNH0 UETD_CHKDISTKEUI UETD_EMP401KACWR UETD_CHKDIST6YCF UETD_GLTAVRKYA UETD_JCESTIMATELBW0 UETD_EMP401KG7BK UETD_APTAXFCL39KQ UETD_JCJOBCONTNHKX UETD_GC_MULTIPLZEHE UETD_EMP401KNQZA UETD_INVRGCODEDWKUH UETD_JCWBSV2RGD UETD_EMP401K9G1Q UETD_JCWBSV31JA UETD_CHKDISTQZYD UETD_CHKDISTTPHQ UETD_CHKDIST7HL2 UETD_JCWBSVNPZ4 UETD_INVRGCODEJ39KQ UETD_CHKDISTMHTR UETD_CHKDISTBSCR UETD_JC_JOBMBKW UETD_EQUIPMENTZEHE UETD_INVCOMNTSDKRE UETD_EMP_AVAIL2BF8 UETD_CHKDISTOXDD UETD_CONT_AMTAKLG UETD_EMP_ST_SUIZRUL UETD_DICIPLINEZCNE UETD_EMP401K6YCF UETD_CHKDISTGBEP UETD_CHKDISTMB48 UETD_EMP_AVAILNYIV UETD_SUBCONTRACJJKV UETD_INVCOMNTSG7BK UETD_EMP_AVAIL84PQ UETD_TAXESG7BK UETD_JCESTIMATEIC9M UETD_JCWBSV6FA5 UETD_SCPRELIM6FA5 UETD_GLTAVG7CF UETD_SM_TABLE22BF8 UETD_EMP_ST_SUIWKUH UETD_JCWBSV9G1Q UETD_EMP_AVAILTPHQ UETD_EMP401KPKA5 UETD_VEND_EXTG7BK UETD_LOC_CODEPLNYIV UETD_JCESTIMATEFHND UETD_FRMINV_LOGFHND UETD_INVRGCODEJR4DI UETD_COMPLTYPER4DI UETD_CHKDIST26US UETD_ADDITIONAL26US UETD_GROUPCODER4DI UETD_PROJC2ZCNE UETD_TESTTABLEP38P UETD_JCESTIMATEGBEP UETD_VEND_INCENZEHE UETD_EMP_ST_SUIZCH1 UETD_SHELCODIVOXDD UETD_DBSPROJCYZKN UETD_CONTCUSTP38P UETD_EMP_AVAILAKLG UETD_INVRGCODEJGBEP UETD_LINKSNYIV UETD_CHKDISTJJKV UETD_TESTERG7BK UETD_SCG7BK UETD_CHKDISTMKG4 UETD_FORE_COMMG7CF UETD_CHKDISTH9DN UETD_EMP_ST_SUIG7CF UETD_EMP_ST_SUI9G1Q UETD_EMP401K9TR7 UETD_EMP401KFHND UETD_PREMIUMPKA5 UETD_ORGOPPUDFTPHQ UETD_JCWBSVNQZA UETD_FRMDEL_LOGFHND UETD_OPPORALC0HWV UETD_CHKDISTXEVP UETD_CHKDIST98CJ UETD_CHKDISTZCH1 UETD_GLTAVIMYP UETD_EXHIBITDAG7BK UETD_JCESTIMATEZCH1 UETD_JCWBSVDKRE UETD_CHKDISTR9X9 UETD_A999G7BK UETD_JCJOBYDKJ UETD_JCESTIMATEYDKJ UETD_EMP_AVAILZCH1 UETD_EMP_AVAILMBKW UETD_JCWBSVYDKJ UETD_INVCOMNTSYDKJ UETD_SCADDLINFOOXDD UETD_INVRGCODEJJ7JN UETD_OMOPPALCNHKX UETD_INVRGCODEJNPZ4 UETD_GLTAV6FA5 UETD_JCWBSVKILS UETD_CUSTEQUIPCTA3 UETD_CHKDIST6FA5 UETD_MRKTSEC7V4Q UETD_CHKDISTER85 UETD_ADDBILLDATG7BK UETD_CONTRACTS7V4Q UETD_JCESTIMATE84PQ UETD_INVCOMNTSZEHE UETD_EMP_ST_SUINQZA UETD_JCWBSV4VOC UETD_JCESTIMATERSAP UETD_JCWBSVFSZY UETD_EMP401K7HL2 UETD_CHKDIST2ZFP UETD_OPPORGUDFTPHQ UETD_EMP_ST_SUI7HL2 UETD_ALCOMNHKX UETD_CHKDIST24RM UETD_INSTYPER4DI UETD_CHKDISTYDKJ UETD_JCESTIMATEP22W UETD_CHKDISTQNQ8 UETD_CHKDIST94KJ UETD_SM_TABLE2BF8 UETD_CHKDISTU2BY UETD_ZTESTPMZCH1 UETD_CHKDIST8D25 UETD_CHKDISTQM3H UETD_PRJCLOOUTLNYIV UETD_AGEDREPJ0GJ UETD_CHKDISTZEHE UETD_JCWBSVSSP6 UETD_EXHIBIT6YCF UETD_CIEXTG7BK UETD_JCJOBEXTZEHE UETD_INVCOMNTS6YCF UETD_INVRGCODEJQVHY UETD_TESTNL1G7BK UETD_PERFP38P UETD_CHKDISTR4DI UETD_INVRGCODEDNYIV UETD_APTAXFCLTMBS UETD_COMPLTESTNPZ4 UETD_INVRGCODEDQVHY UETD_CHKDISTYOQ3 UETD_APZZFA UETD_JCWBSVFHND UETD_EMP_AVAILQVHY UETD_EMP_ATTACHR9X9 UETD_INVCOMNTSZCH1 UETD_GLTAVCE02 UETD_CHKDISTIHQO UETD_EXHIBITI1PP UETD_CHKDISTAKLG UETD_INVRGCODEJNQZA UETD_JCWBSVIMYP UETD_SALESGOALZEHE UETD_INVCOMNTSYJ8M UETD_JCESTIMATEMBKW UETD_ACTEMPUVRU UETD_INVCOMNTS2ZFP UETD_DEFG7BK UETD_SCPMPRELIM6FA5 UETD_INVRGCODED84PQ UETD_BPSECZCNE UETD_JBCONTG7BK UETD_EMP_ST_SUIGBEP UETD_JCWBSVP22W UETD_CCP_LOGFHND UETD_CHKDIST39KQ UETD_MBE_WBE7HL2 UETD_TEST_DUMMYFHND UETD_EMP_AVAIL7HL2 UETD_JCWBSVNYIV UETD_JCWBSV7HL2 UETD_TESTJJKV UETD_ACTUALINVP42V UETD_KCO_BIDJOBKEUI UETD_ADDITIONALHNMA UETD_EMP_ABSYEEE UETD_INVRGCODEJY752 UETD_PROJCOORDZCNE UETD_EMP_AVAILGBEP UETD_GLTAVNQZA UETD_INVCOMNTSFLT3 UETD_INVRGCODEJZCNE UETD_JCESTIMATEZEHE UETD_CHKDISTCTA3 UETD_PYAPPROVZCNE UETD_WSIBCMSI UETD_CHKDISTYJ8M UETD_COMMPRICEZEHE UETD_PLR_CONT1NYIV UETD_SCADDLINFOBSCR UETD_JCWBSVQVHY UETD_INVRGCODEJ84PQ UETD_INVRGCODEJYDO9 UETD_GLTAV9OPQ UETD_INT_EXTKRFR UETD_CHKDISTACWR UETD_EMP_ST_SUIGFN2 UETD_CHKDIST84PQ UETD_INVRGCODED9G1Q UETD_JCWBSVBEUL UETD_PM_INFOG7BK UETD_PMINFOG7BK UETD_GLTAVFHND UETD_JCESTIMATENQZA UETD_CHKDISTJ0GJ UETD_CHKDISTFLT3 UETD_CHKDIST4PGX UETD_ADDETAILSR4DI UETD_JCJOBZCH1 UETD_GLTAVZEHE UETD_JBLIENWVRGVTL UETD_JBCONTGVTL UETD_ADTESTGBEP UETD_JOBFIELDZEHE UETD_PROJC3ZCNE UETD_EMP401KZCH1 UETD_CLICENSE6YCF UETD_GL_LISTZEHE UETD_INVCOMNTSZCNE UETD_EMPSALESGOZEHE UETD_EMP401KNYIV UETD_INVCOMNTSQNQ8 UETD_ZZPONPZ4 UETD_BEBOPG7BK UETD_EMP_AVAILACWR UETD_EMP_AVAIL6FA5 UETD_JCPTYPEUVRU UETD_EMP_ST_SUIJJKV UETD_SCMASTJJKV UETD_INVRGCODEJLBW0 UETD_WEATHERJJKV 257 rows selected. TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------- DC_APREGINV DC_BPVENDORS DC_CIITEM DC_CIITEMHDR DC_HRELECTEDPLANS_EM DC_JB_BILLING_RATE_HEADER DC_LOCATION_TABLE DC_OMOPPORTUNITY DC_OMOPPORTUNITY_NOTES DC_PMHISTORY DC_PMROLE DC_PYCHECKS DC_PYEMPLEAVEHIST DC_PYEMPPAYRATE DC_SYSADDRESS DC_SYSCONTACT DC_BABANKACCT DC_BABRANCH DC_BPCSICODE DC_EMDETAIL DC_GLEDGER DC_JBCONT DC_JBGROUP DC_JCJOBSECGRPPROJ DC_JCTIME_PHASED_FIN_FCST DC_OMORGANIZATION_NOTES DC_PMMEETING DC_PMPROJECT_TABLE DC_PMSUBMITPACKAGE DC_POSHIPMENT DC_PYEMPDED DC_PYEMPPAYHIST DC_PYJOBPAYRATE DC_PYUNIDED DC_VOUCHER MS_BILLING_INVOICE_TAX_GTT DC_AP_VOU_MAP_TABLE DC_EMEQUIPMENT DC_FAASSET DC_JCJOBHPHS DC_JCJOBSECGRPJOB DC_JCPROFITPLAN_WIP DC_JCUTRAN DC_PAYCHQ DC_PMPROJCONTACTROLE DC_PMPROJPARTNER DC_PMTRANSMITTAL_TABLE DC_POSHIPMDET DC_PYCOMMAX DC_PYTAXEXM DC_PYUNIBEN DC_PYUNIPAYRATE DC_VOUDIST_RB_DIST_CAT_CODE DC_VOUDIST_RB_DIST_CHECK DC_VOUDIST_V1 SEQNUM_TN DC_CISTDCST DC_EMACTUALLOCATION DC_EMLOCHIST DC_HRPOSITIONS_TABLE DC_JCDETAIL DC_JCPROFITPLAN_JOBS DC_JCTPHS DC_JCWIPTMJOBS DC_PMDESCRIPTION DC_PODETAIL DC_PRMWORKITEMS_POSTED DC_PYEMPLOAN DC_PYPLCODE DC_VOUDIST_RB_VDIST_BCH_NUM MLOG$_PYEMPPAYHIST_TN DC_ACCOUNT DC_BPCLASSIFICATION DC_CIITEMDET DC_CITALTUM DC_EMEQPCOMTRAN DC_HRPOSITIONS DC_JCMPHS DC_JCPROFITPLAN_PERIOD DC_OMCLASSIFIERVAL DC_OMSALESTEAM DC_ORGANIZATION_DETAIL_UED DC_PMBIDPACKAGE DC_PMPRQFINANCIALINFO DC_PMRFI DC_POCOMAST DC_PYEMPTIMSHT DC_PYWORKLOC DC_SCP_VENDOR_CIS_INFO DC_SYSCONTACT_REFERENCE DC_VOUCHQ INVDIST_GTT PYEMPPAYHIST_BEN_TN_MV RS_DISPATCH_GTT DC_ADDRESS DC_BPADDRESSES DC_CMDETAIL_POSTED DC_DEPT_TABLE DC_EMEQPCLASS DC_EMEQPHCOMPON DC_INVMEMO DC_JBBILL DC_JBGROUP_V1 DC_JCJOB_TABLE DC_JCTCAT DC_OMOPPORTUNITY_DATA_SHEET DC_OMORGBUILDINGTYPE DC_OM_GENERAL_UED DC_PMMEETINGITEM DC_PMSBMTPDETAIL DC_PRMCLASSACCUMS DC_PYCHKLOC DC_PYEMPSALSPL DC_SCMAST_MINORITY_PART DC_TERM IMG_DOCUMENTS_REV_GTT RTI_TEXTURA_FILE_IMPORT_TN DC_BPARTNERS DC_BPARTNERSPRQINFO DC_BPCUSTOMERS DC_HREMRELATIVES DC_INVRLSDET DC_JBCONTDET DC_JCJOBSECGRPUSER DC_PMNOTES DC_PMPROJCONTACT DC_POCODET DC_POFFITM DC_PYACCESSCODE DC_PYEMPBEN DC_PYEMPLEAVE DC_PYEMPLOYEE_TABLE DC_PYJOBBEN DC_SYSACTIONITEMS_UED DC_VOUDIST DC_VOUDIST_RB_REMAIN_ERRORS_1 DC_VOUDIST_REM DC_VOUMEMO DC_VOURLSDET SD_CMIC_OBJECTS DC_BABANK DC_BPBANKS DC_BPMARKETSECTOR DC_CHQPAYEE DC_EMTRANPOST DC_INVDIST DC_JBBILLDET DC_JB_BILLING_RATE_DETAIL DC_OMOPPOCOMPETITOR DC_OMORGANIZATION_TABLE DC_PMJOURMAT DC_PMMEETINGTRACK DC_PMPROJECTITEM DC_PMSUBMITTAL DC_POMAST DC_PYEMPSECGRPEMP DC_PYTAXEMP DC_PYWCBENEFIT DC_WGTCONV 159 rows selected. TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------- IMG_DOCUMENTS_REV_GTT INVDIST_GTT MS_BILLING_INVOICE_TAX_GTT RS_DISPATCH_GTT SD_CMIC_OBJECTS SEQNUM_TN 6 rows selected. (2) Correction to UETD column_names with too many underscores (no longer needed) TO_CHAR(SYSDATE,' ----------------- 20240710 15:13:36 1 row selected. TO_CHAR(SYSDATE,' ----------------- 20240710 15:13:36 1 row selected. -- ====================================================================== -- 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 -- ====================================================================== -- ====================================================================== -- 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,626 INDEX 53,408 INDEX PARTITION 105 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 1 PACKAGE 3,149 4 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,975 TABLE 35,800 TABLE PARTITION 20,898 21 TRIGGER 266 TYPE 10,354 VIEW -------- ********** -------- 144,762 sum 27 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 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 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 1 VIEW -------- ********** -------- 6,260 sum 1 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 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 -------- -------- 164,549 29 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== start additional_compx.sql 2024-07-10 15:13:42 special list (before special recompiling) 2024-07-10 15:13:42 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-10 15:13:43 special list (after special recompiling) 2024-07-10 15:13:44 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 105 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 1 PACKAGE 3,149 4 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,975 TABLE 35,800 TABLE PARTITION 20,898 21 TRIGGER 266 TYPE 10,354 VIEW -------- ********** -------- 144,762 sum 27 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 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 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 1 VIEW -------- ********** -------- 6,260 sum 1 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 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 -------- -------- 164,549 29 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PACKAGE DBK_RTI_PY_EMPLOYEE DA PACKAGE BODY DBK_HREMPAPP DA PACKAGE BODY DBK_PY_EMP_IMP DA PACKAGE BODY DBK_PY_INTEGRATION DA PACKAGE BODY DBK_RTI_PY_EMPLOYEE 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 DA TRIGGER DBT_I_IUD_RTI#PYEMPLOYEE DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 10-JUL-24 03.13.44.670721 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. -- ====================================================================== -- 2379653_3.sql completed. Output in 2379653_3.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:2379653_4.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-10_15_12_30.677/2379653_4.sql.sh to run 2379653_4.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-10_15_12_30.677/2379653_4.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-07-10_15_12_30.677/2379653_4.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 10 15:13:44 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.79653, Work Item 4 -- PWPS different for two emps with same calculated PWF. -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2379653_4.sql Output in 2379653_4.lst -- ====================================================================== -- ====================================================================== -- Turn Patch Flag ON -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- Get the initial 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,626 INDEX 53,408 INDEX PARTITION 105 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 1 PACKAGE 3,149 4 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,975 TABLE 35,800 TABLE PARTITION 20,898 21 TRIGGER 266 TYPE 10,354 VIEW -------- ********** -------- 144,762 sum 27 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 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 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 1 VIEW -------- ********** -------- 6,260 sum 1 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 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 -------- -------- 164,549 29 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== start additional_compx.sql 2024-07-10 15:13:50 special list (before special recompiling) 2024-07-10 15:13:51 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-10 15:13:52 special list (after special recompiling) 2024-07-10 15:13:52 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 105 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 1 PACKAGE 3,149 4 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,975 TABLE 35,800 TABLE PARTITION 20,898 21 TRIGGER 266 TYPE 10,354 VIEW -------- ********** -------- 144,762 sum 27 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 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 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 1 VIEW -------- ********** -------- 6,260 sum 1 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 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 -------- -------- 164,549 29 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PACKAGE DBK_RTI_PY_EMPLOYEE DA PACKAGE BODY DBK_HREMPAPP DA PACKAGE BODY DBK_PY_EMP_IMP DA PACKAGE BODY DBK_PY_INTEGRATION DA PACKAGE BODY DBK_RTI_PY_EMPLOYEE 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 DA TRIGGER DBT_I_IUD_RTI#PYEMPLOYEE DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 10-JUL-24 03.13.52.790676 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 -- ====================================================================== -- ====================================================================== -- 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 -- ====================================================================== -- ====================================================================== -- 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,626 INDEX 53,408 INDEX PARTITION 105 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 1 PACKAGE 3,149 4 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,975 TABLE 35,800 TABLE PARTITION 20,898 21 TRIGGER 266 TYPE 10,354 VIEW -------- ********** -------- 144,762 sum 27 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 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 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 1 VIEW -------- ********** -------- 6,260 sum 1 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 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 -------- -------- 164,549 29 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== start additional_compx.sql 2024-07-10 15:13:58 special list (before special recompiling) 2024-07-10 15:13:59 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-10 15:13:59 special list (after special recompiling) 2024-07-10 15:14:00 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 105 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 1 PACKAGE 3,149 4 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,975 TABLE 35,800 TABLE PARTITION 20,898 21 TRIGGER 266 TYPE 10,354 VIEW -------- ********** -------- 144,762 sum 27 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 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 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 1 VIEW -------- ********** -------- 6,260 sum 1 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 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 -------- -------- 164,549 29 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PACKAGE DBK_RTI_PY_EMPLOYEE DA PACKAGE BODY DBK_HREMPAPP DA PACKAGE BODY DBK_PY_EMP_IMP DA PACKAGE BODY DBK_PY_INTEGRATION DA PACKAGE BODY DBK_RTI_PY_EMPLOYEE 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 DA TRIGGER DBT_I_IUD_RTI#PYEMPLOYEE DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 10-JUL-24 03.14.00.658134 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. -- ====================================================================== -- 2379653_4.sql completed. Output in 2379653_4.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.79653 was successfully installed. As specified with --no-deploy option, JSPs did not get deployed. Deploy JSPs manually Installation Log Review: ======================== ---------SUMMARY--------- Critical Errors: 0 Warning Errors: 0 Informative Errors: 4 ---------CRITICAL ERRORS--------- ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- 476 | * 477 | ERROR at line 1: 478 | ORA-00955: name is already used by an existing object 479 | 512 | * 513 | ERROR at line 1: 514 | ORA-00942: table or view does not exist 515 | 518 | * 519 | ERROR at line 1: 520 | ORA-00942: table or view does not exist 521 | 951 | * 952 | ERROR at line 1: 953 | ORA-00942: table or view does not exist 954 | =============================== End of Installation Log Review ===============================