Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/24.85086_CLOUD_16745_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-07-02 03:54:36 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.85086, has been installed 6 times on the application server while it is installed 0 times on the database! - File: sql/2485086_6.sql: __________________________ The new copy of the file "/opt/cm/v12/test/sql/2485086_6.sql", shipped with the package, is the same as the current copy on disk, and the timestamps on both files are the same! Updating: /opt/cm/v12/test/sql/2485086_6.sql - size (on disk): 8391 bytes - last modified (on disk): 2024-06-27 16:43:50.0 - size (new file): 8391 bytes - last modified (new file): 2024-06-27 16:43:50.0 Warning: The file was not modified. Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-02_03_54_37.343/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-07-02_03_54_37.343/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-02_03_54_37.343/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 2 The group 0 entry Name Update:2485086_6.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-02_03_54_37.343/2485086_6.sql.sh to run 2485086_6.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-02_03_54_37.343/2485086_6.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-07-02_03_54_37.343/2485086_6.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jul 2 03:55:13 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.85086, Work Item 6 -- Norcon Custom Meeting Mins Agenda Updates -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2485086_6.sql Output in 2485086_6.lst -- ====================================================================== -- ====================================================================== -- Turn Patch Flag ON -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- Get the initial state of the database -- ====================================================================== PL/SQL procedure successfully completed. Session altered. -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 g) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 7,611 INDEX 53,170 INDEX PARTITION 54 JOB 259 LOB 1 MATERIALIZED VIEW 3,155 2 PACKAGE 3,148 8 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,550 SYNONYM 7,965 TABLE 35,564 TABLE PARTITION 20,867 97 TRIGGER 266 TYPE 10,347 24 VIEW -------- ********** -------- 144,171 sum 132 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,283 SYNONYM 2 TABLE 391 57 TRIGGER 1,205 6 VIEW -------- ********** -------- 2,894 sum 63 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,881 2 VIEW -------- ********** -------- 4,477 sum 2 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 1 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 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,210 VIEW -------- ********** -------- 6,245 sum 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 384 VIEW -------- ********** -------- 535 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 138 INDEX PARTITION 74 LOB 138 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 48 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,833 sum -------- -------- 163,895 198 =================================================== =================================================================================== == 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-02 03:55:47 special list (before special recompiling) 2024-07-02 03:55:47 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-02 03:55:48 special list (after special recompiling) 2024-07-02 03:55:48 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,611 INDEX 53,170 INDEX PARTITION 54 JOB 259 LOB 1 MATERIALIZED VIEW 3,155 2 PACKAGE 3,148 8 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,550 SYNONYM 7,965 TABLE 35,564 TABLE PARTITION 20,867 97 TRIGGER 266 TYPE 10,347 24 VIEW -------- ********** -------- 144,171 sum 132 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,283 SYNONYM 2 TABLE 391 57 TRIGGER 1,205 6 VIEW -------- ********** -------- 2,894 sum 63 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,881 2 VIEW -------- ********** -------- 4,477 sum 2 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 1 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 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,210 VIEW -------- ********** -------- 6,245 sum 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 384 VIEW -------- ********** -------- 535 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 138 INDEX PARTITION 74 LOB 138 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 48 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,833 sum -------- -------- 163,895 198 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PACKAGE DBK_HR_SSE_REQUESTS DA PACKAGE DBK_PY_REST DA PACKAGE BODY DBK_E_TIMSHEET DA PACKAGE BODY DBK_HR_OPEN_ENROLLMENT DA PACKAGE BODY DBK_HR_QUALIFYING_EVENT DA PACKAGE BODY DBK_HR_SSE_REQUESTS DA PACKAGE BODY DBK_JCPHASE_QTY_COMPLETION DA PACKAGE BODY DBK_PY_REST DA PACKAGE BODY DBK_WKF_PM DA PACKAGE BODY DBK_WKF_WORKFLOW 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_BIU_PYEMPTIMSHT_TEMP DA TRIGGER DBT_I_IUD_HRAPLCNT_PY_ADMS_VW DA TRIGGER DBT_I_IUD_HRAPLREFS_ADMS_VW DA TRIGGER DBT_I_IUD_HRAPLS_ADMS_VW DA TRIGGER DBT_I_IUD_HRAPPHISTORY_ADMS_VW DA TRIGGER DBT_I_IUD_HRAPPLICANT_ADMS_VW DA TRIGGER DBT_I_IUD_HRAPPQNSANS_ADMS_VW DA TRIGGER DBT_I_IUD_HRAPPREVEMPS_ADMS_VW DA TRIGGER DBT_I_IUD_HRAPPSTATUS_ADMS_VW DA TRIGGER DBT_I_IUD_HRDOCTYPES_ADMS_VW DA TRIGGER DBT_I_IUD_HRDOCUMENTS_ADMS_VW DA TRIGGER DBT_I_IUD_HRDOCUMENT_ADMS_VW DA TRIGGER DBT_I_IUD_HREMPCERTLIC_ADMS_VW DA TRIGGER DBT_I_IUD_HREMPDOCS_ADMS_VW DA TRIGGER DBT_I_IUD_HREMPEDU_ADMS_VW DA TRIGGER DBT_I_IUD_HREMPMEMS_ADMS_VW DA TRIGGER DBT_I_IUD_HREMPSKILLS_ADMS_VW DA TRIGGER DBT_I_IUD_HREMRELATIVES_REQ_DETAIL_VW DA TRIGGER DBT_I_IUD_HRHIRINGACT_ADMS_VW DA TRIGGER DBT_I_IUD_HRPMATTACH_ADMS_VW DA TRIGGER DBT_I_IUD_HRPOSITIONS_ADMS_VW DA TRIGGER DBT_I_IUD_HRPOS_TABLE_ADMS_VW DA TRIGGER DBT_I_IUD_HRREQACTION_ADMS_VW DA TRIGGER DBT_I_IUD_HRREQ_ADMS_VW DA TRIGGER DBT_I_IUD_IMG#SOURCES_TABLE_V DA TRIGGER DBT_I_IUD_MP_UI_ROLEFIELDSEC_VW DA TRIGGER DBT_I_IUD_PY#PYEMPSALADJ DA TRIGGER DBT_I_IUD_PYCHKL_CREW_SETUP_VW DA TRIGGER DBT_I_IUD_PYCHKL_CREW_SET_D_VW DA TRIGGER DBT_I_IUD_PYCHKL_CREW_VW DA TRIGGER DBT_I_IUD_PYCHKL_FILL_ANS_VW DA TRIGGER DBT_I_IUD_PYCHKL_FILL_QUES_VW DA TRIGGER DBT_I_IUD_PYCHKL_FILL_VW DA TRIGGER DBT_I_IUD_PYCHKL_FOREMAN_VW DA TRIGGER DBT_I_IUD_PYCHKL_SIGN_OFF_VW DA TRIGGER DBT_I_IUD_PYCHKL_TEMPL_QUES_VW DA TRIGGER DBT_I_IUD_PYCHKL_TEMPL_SECT_VW DA TRIGGER DBT_I_IUD_PYCHKL_TEMPL_VAL_VW DA TRIGGER DBT_I_IUD_PYCHKL_TEMPL_VW DA TRIGGER DBT_I_IUD_PYCREWTIME_SESS_VW DA TRIGGER DBT_I_IUD_PYCREWTIME_SIGN_VW DA TRIGGER DBT_I_IUD_PYCREWTIM_EMP_INT_VW DA TRIGGER DBT_I_IUD_PYCREWTIM_EQP_INT_VW DA TRIGGER DBT_I_IUD_PYCTIME_ACTIVITY_VW DA TRIGGER DBT_I_IUD_PYCTIME_EMPLOYEE_VW DA TRIGGER DBT_I_IUD_PYCTIME_EMP_DET_VW DA TRIGGER DBT_I_IUD_PYCTIME_EQP_DET_VW DA TRIGGER DBT_I_IUD_PYCTIME_EQUIPMENT_VW DA TRIGGER DBT_I_IUD_PYCTIME_HEADER_VW DA TRIGGER DBT_I_IUD_PYCT_CREW_ACT_VW DA TRIGGER DBT_I_IUD_PYCT_CREW_EMP_DET_VW DA TRIGGER DBT_I_IUD_PYCT_CREW_EMP_VW DA TRIGGER DBT_I_IUD_PYCT_CREW_EQP_DET_VW DA TRIGGER DBT_I_IUD_PYCT_CREW_EQP_VW DA TRIGGER DBT_I_IUD_PYCT_CREW_SCHD_T_VW DA TRIGGER DBT_I_IUD_PYCT_CREW_SCHD_VW DA TRIGGER DBT_I_IUD_PYCT_CREW_VW DA TRIGGER DBT_I_IUD_PYCT_EMP_PER_DATE_VW DA TRIGGER DBT_I_IUD_PYCT_TIME_ENT_EMP_VW DA TRIGGER DBT_I_IUD_PYCT_TIME_ENT_EQP_VW DA TRIGGER DBT_I_IUD_PYEMPLEAVEREQ_VW DA TRIGGER DBT_I_IUD_PYEMPLEAVREQ_DET_VW DA TRIGGER DBT_I_IUD_PYEMP_CLOCK_INOUT_VW DA TRIGGER DBT_I_IUD_PYEMP_DELEGATION_VW DA TRIGGER DBT_I_IUD_PYEMP_DEL_ACTION_VW DA TRIGGER DBT_I_IUD_PYEMP_DEL_DELEGEE_VW DA TRIGGER DBT_I_IUD_PYEMP_INOUT_TIMES_VW DA TRIGGER DBT_I_IUD_PYEMP_NATION_ADMS_VW DA TRIGGER DBT_I_IUD_PYET_TIME_ENTRY_VW DA TRIGGER DBT_I_IUD_PYNOTES_VW DA TRIGGER DBT_I_IUD_PYPMNOTES_VW DA TRIGGER DBT_I_IUD_PYPMSUBNOTES_VW DA TRIGGER DBT_I_IUD_PYTRADES_VW DA TRIGGER DBT_I_IUD_PY_ESS_USER_PREFS_VW DA TRIGGER DBT_I_IUD_PY_ESS_USR_DET_VW DA TRIGGER DBT_I_IUD_RTI#PYEMPLOYEE DA TRIGGER DBT_I_IUD_RTI#PYEMP_CLOCK_IO DA VIEW HREMRELATIVES_REQ_DETAIL_VW DA VIEW IMG#SOURCES_TABLE_V DA VIEW PYCREWTIME_PROD_DASHBOARD_VW DA VIEW PYCTIME_ACCOUNT_LOV_VW DA VIEW PYCTIME_ACTIVITY_TYPE_LOV_VW DA VIEW PYCTIME_CATEGORY_LOV_VW DA VIEW PYCTIME_COMPANY_LOV_VW DA VIEW PYCTIME_DEPARTMENT_LOV_VW DA VIEW PYCTIME_EQUIPMENT_LOV_VW DA VIEW PYCTIME_EQUIP_TRAN_LOV_VW DA VIEW PYCTIME_JOB_LOV_VW DA VIEW PYCTIME_PHASE_LOV_VW DA VIEW PYCTIME_PROJECT_LOV_VW DA VIEW PYCTIME_TRADE_LOV_VW DA VIEW PYEMP_CIO_DASHBOARD_V DA VIEW PYEMP_LEAVE_MANAGEMENT_VW DA VIEW PYETIME_DATA_TYPE_LOV_VW DA VIEW PYETIME_EMP_PROFILE_LOV_VW DA VIEW PYETIME_EQUIPMENT_LOV_VW DA VIEW PYETIME_EQUIP_TRAN_LOV_VW DA VIEW PYETIME_TAC_VALUE_VW DA VIEW PYETIME_TRADE_LOV_VW DA VIEW PYETIME_WBS_VALUE_VW DA VIEW PY_DIRECT_REPORTEE_VW DAR TRIGGER DBT_I_IUD_HRAPLCNT_PY_ADMS_V DAR TRIGGER DBT_I_IUD_HRAPLREFS_ADMS_V DAR TRIGGER DBT_I_IUD_HRAPLS_ADMS_V DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V DAR TRIGGER DBT_I_IUD_HRAPPQNSANS_ADMS_V DAR TRIGGER DBT_I_IUD_HRAPPREVEMPS_ADMS_V DAR TRIGGER DBT_I_IUD_HREMPCERTLIC_ADMS_V DAR TRIGGER DBT_I_IUD_HREMPEDU_ADMS_V DAR TRIGGER DBT_I_IUD_HREMPMEMS_ADMS_V DAR TRIGGER DBT_I_IUD_HREMPSKILLS_ADMS_V DAR TRIGGER DBT_I_IUD_HRREQ_ADMS_V DAR TRIGGER DBT_I_IUD_PYCHKL_CREW_SETUP_V DAR TRIGGER DBT_I_IUD_PYCHKL_CREW_SET_D_V DAR TRIGGER DBT_I_IUD_PYCHKL_CREW_V DAR TRIGGER DBT_I_IUD_PYCHKL_FILL_ANS_V DAR TRIGGER DBT_I_IUD_PYCHKL_FILL_QUES_V DAR TRIGGER DBT_I_IUD_PYCHKL_FILL_V DAR TRIGGER DBT_I_IUD_PYCHKL_FOREMAN_V DAR TRIGGER DBT_I_IUD_PYCHKL_SIGN_OFF_V DAR TRIGGER DBT_I_IUD_PYCHKL_TEMPL_QUES_V DAR TRIGGER DBT_I_IUD_PYCHKL_TEMPL_SECT_V DAR TRIGGER DBT_I_IUD_PYCHKL_TEMPL_V DAR TRIGGER DBT_I_IUD_PYCHKL_TEMPL_VAL_V DAR TRIGGER DBT_I_IUD_PYCREWTIME_SESS_V DAR TRIGGER DBT_I_IUD_PYCREWTIME_SIGN_V DAR TRIGGER DBT_I_IUD_PYCTIME_ACTIVITY_V DAR TRIGGER DBT_I_IUD_PYCTIME_EMPLOYEE_V DAR TRIGGER DBT_I_IUD_PYCTIME_EMP_DET_V DAR TRIGGER DBT_I_IUD_PYCTIME_EQP_DET_V DAR TRIGGER DBT_I_IUD_PYCTIME_EQUIPMENT_V DAR TRIGGER DBT_I_IUD_PYCTIME_HEADER_V DAR TRIGGER DBT_I_IUD_PYCT_CREW_ACT_V DAR TRIGGER DBT_I_IUD_PYCT_CREW_EMP_DET_V DAR TRIGGER DBT_I_IUD_PYCT_CREW_EMP_V DAR TRIGGER DBT_I_IUD_PYCT_CREW_EQP_DET_V DAR TRIGGER DBT_I_IUD_PYCT_CREW_EQP_V DAR TRIGGER DBT_I_IUD_PYCT_CREW_SCHD_T_V DAR TRIGGER DBT_I_IUD_PYCT_CREW_SCHD_V DAR TRIGGER DBT_I_IUD_PYCT_CREW_V DAR TRIGGER DBT_I_IUD_PYCT_EMP_PER_DATE_V DAR TRIGGER DBT_I_IUD_PYCT_TIME_ENT_EMP_V DAR TRIGGER DBT_I_IUD_PYCT_TIME_ENT_EQP_V DAR TRIGGER DBT_I_IUD_PYEMPLEAVEREQ_V DAR TRIGGER DBT_I_IUD_PYEMPLEAVREQ_DET_V DAR TRIGGER DBT_I_IUD_PYEMP_CLOCK_INOUT_V DAR TRIGGER DBT_I_IUD_PYEMP_DELEGATION_V DAR TRIGGER DBT_I_IUD_PYEMP_DEL_ACTION_V DAR TRIGGER DBT_I_IUD_PYEMP_DEL_DELEGEE_V DAR TRIGGER DBT_I_IUD_PYEMP_INOUT_TIMES_V DAR TRIGGER DBT_I_IUD_PYEMP_NATION_ADMS_V DAR TRIGGER DBT_I_IUD_PYET_TIME_ENTRY_V DAR TRIGGER DBT_I_IUD_PYNOTES_V DAR TRIGGER DBT_I_IUD_PYPMNOTES_V DAR TRIGGER DBT_I_IUD_PYPMSUBNOTES_V DAR TRIGGER DBT_I_IUD_PYTRADES_VW_V DAR TRIGGER DBT_I_IUD_PY_ESS_USER_PREFS_V DAR TRIGGER DBT_I_IUD_PY_ESS_USR_PRF_DET_V DAR VIEW PYCREWTIME_SESSION_INFO_V DAR VIEW PYEMPLEAVEREQ_V DAR VIEW PYETIME_TIME_ENTRY_V DAR VIEW PYPMNOTES_V DAR VIEW PYTRADES_VW_V DAR VIEW PY_REPORTEE_LEAVE_BALANCE_V JSR VIEW JSR_APEFT_CHQ JSR VIEW JSR_SCCHGDOC_WTB OWF_MGR PACKAGE BODY OWKF_PM =================================================================== DB=test A_TEST01 02-JUL-24 03.55.49.811103 AM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-02t 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 -- ====================================================================== DROP VIEW cmic_report_views.NOR_PM1000_ITEMS * ERROR at line 1: ORA-00942: table or view does not exist DROP VIEW cmic_report_views.NOR_PM1000_ATTENDEES_V2 * ERROR at line 1: ORA-00942: table or view does not exist DROP VIEW cmic_report_views.NOR_PM1000 * ERROR at line 1: ORA-00942: table or view does not exist DROP VIEW cmic_report_views.NOR_PM1000_ATTENDEES * ERROR at line 1: ORA-00942: table or view does not exist . --> Created View CMIC_REPORT_VIEWS.NOR_PM1000_ITEMS . *** VIEW NOT CREATED: Table or View does not exist (or tenant_id column not found). *** -->CMIC_REPORT_WRITER.NOR_PM1000_ATTENDEES_V2 . --> Created View CMIC_REPORT_VIEWS.NOR_PM1000 . *** VIEW NOT CREATED: Table or View does not exist (or tenant_id column not found). *** -->CMIC_REPORT_WRITER.NOR_PM1000_ATTENDEES -- ====================================================================== -- 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,611 INDEX 53,170 INDEX PARTITION 54 JOB 259 LOB 1 MATERIALIZED VIEW 3,155 2 PACKAGE 3,148 8 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,550 SYNONYM 7,965 TABLE 35,564 TABLE PARTITION 20,867 97 TRIGGER 266 TYPE 10,347 24 VIEW -------- ********** -------- 144,171 sum 132 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,283 SYNONYM 2 TABLE 391 57 TRIGGER 1,205 6 VIEW -------- ********** -------- 2,894 sum 63 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,881 2 VIEW -------- ********** -------- 4,477 sum 2 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 1 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 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,212 2 VIEW -------- ********** -------- 6,247 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 384 VIEW -------- ********** -------- 535 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 138 INDEX PARTITION 74 LOB 138 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 48 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,833 sum -------- -------- 163,897 200 =================================================== =================================================================================== == 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-02 03:56:24 special list (before special recompiling) 2024-07-02 03:56:25 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-02 03:56:26 special list (after special recompiling) 2024-07-02 03:56:26 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,611 INDEX 53,170 INDEX PARTITION 54 JOB 259 LOB 1 MATERIALIZED VIEW 3,155 2 PACKAGE 3,148 8 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,550 SYNONYM 7,965 TABLE 35,564 TABLE PARTITION 20,867 97 TRIGGER 266 TYPE 10,347 24 VIEW -------- ********** -------- 144,171 sum 132 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,283 SYNONYM 2 TABLE 391 57 TRIGGER 1,205 6 VIEW -------- ********** -------- 2,894 sum 63 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,881 2 VIEW -------- ********** -------- 4,477 sum 2 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 1 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 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 6,212 2 VIEW -------- ********** -------- 6,247 sum 2 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 384 VIEW -------- ********** -------- 535 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 138 INDEX PARTITION 74 LOB 138 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 48 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,833 sum -------- -------- 163,897 200 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PACKAGE DBK_HR_SSE_REQUESTS DA PACKAGE DBK_PY_REST DA PACKAGE BODY DBK_E_TIMSHEET DA PACKAGE BODY DBK_HR_OPEN_ENROLLMENT DA PACKAGE BODY DBK_HR_QUALIFYING_EVENT DA PACKAGE BODY DBK_HR_SSE_REQUESTS DA PACKAGE BODY DBK_JCPHASE_QTY_COMPLETION DA PACKAGE BODY DBK_PY_REST DA PACKAGE BODY DBK_WKF_PM DA PACKAGE BODY DBK_WKF_WORKFLOW 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_BIU_PYEMPTIMSHT_TEMP DA TRIGGER DBT_I_IUD_HRAPLCNT_PY_ADMS_VW DA TRIGGER DBT_I_IUD_HRAPLREFS_ADMS_VW DA TRIGGER DBT_I_IUD_HRAPLS_ADMS_VW DA TRIGGER DBT_I_IUD_HRAPPHISTORY_ADMS_VW DA TRIGGER DBT_I_IUD_HRAPPLICANT_ADMS_VW DA TRIGGER DBT_I_IUD_HRAPPQNSANS_ADMS_VW DA TRIGGER DBT_I_IUD_HRAPPREVEMPS_ADMS_VW DA TRIGGER DBT_I_IUD_HRAPPSTATUS_ADMS_VW DA TRIGGER DBT_I_IUD_HRDOCTYPES_ADMS_VW DA TRIGGER DBT_I_IUD_HRDOCUMENTS_ADMS_VW DA TRIGGER DBT_I_IUD_HRDOCUMENT_ADMS_VW DA TRIGGER DBT_I_IUD_HREMPCERTLIC_ADMS_VW DA TRIGGER DBT_I_IUD_HREMPDOCS_ADMS_VW DA TRIGGER DBT_I_IUD_HREMPEDU_ADMS_VW DA TRIGGER DBT_I_IUD_HREMPMEMS_ADMS_VW DA TRIGGER DBT_I_IUD_HREMPSKILLS_ADMS_VW DA TRIGGER DBT_I_IUD_HREMRELATIVES_REQ_DETAIL_VW DA TRIGGER DBT_I_IUD_HRHIRINGACT_ADMS_VW DA TRIGGER DBT_I_IUD_HRPMATTACH_ADMS_VW DA TRIGGER DBT_I_IUD_HRPOSITIONS_ADMS_VW DA TRIGGER DBT_I_IUD_HRPOS_TABLE_ADMS_VW DA TRIGGER DBT_I_IUD_HRREQACTION_ADMS_VW DA TRIGGER DBT_I_IUD_HRREQ_ADMS_VW DA TRIGGER DBT_I_IUD_IMG#SOURCES_TABLE_V DA TRIGGER DBT_I_IUD_MP_UI_ROLEFIELDSEC_VW DA TRIGGER DBT_I_IUD_PY#PYEMPSALADJ DA TRIGGER DBT_I_IUD_PYCHKL_CREW_SETUP_VW DA TRIGGER DBT_I_IUD_PYCHKL_CREW_SET_D_VW DA TRIGGER DBT_I_IUD_PYCHKL_CREW_VW DA TRIGGER DBT_I_IUD_PYCHKL_FILL_ANS_VW DA TRIGGER DBT_I_IUD_PYCHKL_FILL_QUES_VW DA TRIGGER DBT_I_IUD_PYCHKL_FILL_VW DA TRIGGER DBT_I_IUD_PYCHKL_FOREMAN_VW DA TRIGGER DBT_I_IUD_PYCHKL_SIGN_OFF_VW DA TRIGGER DBT_I_IUD_PYCHKL_TEMPL_QUES_VW DA TRIGGER DBT_I_IUD_PYCHKL_TEMPL_SECT_VW DA TRIGGER DBT_I_IUD_PYCHKL_TEMPL_VAL_VW DA TRIGGER DBT_I_IUD_PYCHKL_TEMPL_VW DA TRIGGER DBT_I_IUD_PYCREWTIME_SESS_VW DA TRIGGER DBT_I_IUD_PYCREWTIME_SIGN_VW DA TRIGGER DBT_I_IUD_PYCREWTIM_EMP_INT_VW DA TRIGGER DBT_I_IUD_PYCREWTIM_EQP_INT_VW DA TRIGGER DBT_I_IUD_PYCTIME_ACTIVITY_VW DA TRIGGER DBT_I_IUD_PYCTIME_EMPLOYEE_VW DA TRIGGER DBT_I_IUD_PYCTIME_EMP_DET_VW DA TRIGGER DBT_I_IUD_PYCTIME_EQP_DET_VW DA TRIGGER DBT_I_IUD_PYCTIME_EQUIPMENT_VW DA TRIGGER DBT_I_IUD_PYCTIME_HEADER_VW DA TRIGGER DBT_I_IUD_PYCT_CREW_ACT_VW DA TRIGGER DBT_I_IUD_PYCT_CREW_EMP_DET_VW DA TRIGGER DBT_I_IUD_PYCT_CREW_EMP_VW DA TRIGGER DBT_I_IUD_PYCT_CREW_EQP_DET_VW DA TRIGGER DBT_I_IUD_PYCT_CREW_EQP_VW DA TRIGGER DBT_I_IUD_PYCT_CREW_SCHD_T_VW DA TRIGGER DBT_I_IUD_PYCT_CREW_SCHD_VW DA TRIGGER DBT_I_IUD_PYCT_CREW_VW DA TRIGGER DBT_I_IUD_PYCT_EMP_PER_DATE_VW DA TRIGGER DBT_I_IUD_PYCT_TIME_ENT_EMP_VW DA TRIGGER DBT_I_IUD_PYCT_TIME_ENT_EQP_VW DA TRIGGER DBT_I_IUD_PYEMPLEAVEREQ_VW DA TRIGGER DBT_I_IUD_PYEMPLEAVREQ_DET_VW DA TRIGGER DBT_I_IUD_PYEMP_CLOCK_INOUT_VW DA TRIGGER DBT_I_IUD_PYEMP_DELEGATION_VW DA TRIGGER DBT_I_IUD_PYEMP_DEL_ACTION_VW DA TRIGGER DBT_I_IUD_PYEMP_DEL_DELEGEE_VW DA TRIGGER DBT_I_IUD_PYEMP_INOUT_TIMES_VW DA TRIGGER DBT_I_IUD_PYEMP_NATION_ADMS_VW DA TRIGGER DBT_I_IUD_PYET_TIME_ENTRY_VW DA TRIGGER DBT_I_IUD_PYNOTES_VW DA TRIGGER DBT_I_IUD_PYPMNOTES_VW DA TRIGGER DBT_I_IUD_PYPMSUBNOTES_VW DA TRIGGER DBT_I_IUD_PYTRADES_VW DA TRIGGER DBT_I_IUD_PY_ESS_USER_PREFS_VW DA TRIGGER DBT_I_IUD_PY_ESS_USR_DET_VW DA TRIGGER DBT_I_IUD_RTI#PYEMPLOYEE DA TRIGGER DBT_I_IUD_RTI#PYEMP_CLOCK_IO DA VIEW HREMRELATIVES_REQ_DETAIL_VW DA VIEW IMG#SOURCES_TABLE_V DA VIEW PYCREWTIME_PROD_DASHBOARD_VW DA VIEW PYCTIME_ACCOUNT_LOV_VW DA VIEW PYCTIME_ACTIVITY_TYPE_LOV_VW DA VIEW PYCTIME_CATEGORY_LOV_VW DA VIEW PYCTIME_COMPANY_LOV_VW DA VIEW PYCTIME_DEPARTMENT_LOV_VW DA VIEW PYCTIME_EQUIPMENT_LOV_VW DA VIEW PYCTIME_EQUIP_TRAN_LOV_VW DA VIEW PYCTIME_JOB_LOV_VW DA VIEW PYCTIME_PHASE_LOV_VW DA VIEW PYCTIME_PROJECT_LOV_VW DA VIEW PYCTIME_TRADE_LOV_VW DA VIEW PYEMP_CIO_DASHBOARD_V DA VIEW PYEMP_LEAVE_MANAGEMENT_VW DA VIEW PYETIME_DATA_TYPE_LOV_VW DA VIEW PYETIME_EMP_PROFILE_LOV_VW DA VIEW PYETIME_EQUIPMENT_LOV_VW DA VIEW PYETIME_EQUIP_TRAN_LOV_VW DA VIEW PYETIME_TAC_VALUE_VW DA VIEW PYETIME_TRADE_LOV_VW DA VIEW PYETIME_WBS_VALUE_VW DA VIEW PY_DIRECT_REPORTEE_VW DAR TRIGGER DBT_I_IUD_HRAPLCNT_PY_ADMS_V DAR TRIGGER DBT_I_IUD_HRAPLREFS_ADMS_V DAR TRIGGER DBT_I_IUD_HRAPLS_ADMS_V DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V DAR TRIGGER DBT_I_IUD_HRAPPQNSANS_ADMS_V DAR TRIGGER DBT_I_IUD_HRAPPREVEMPS_ADMS_V DAR TRIGGER DBT_I_IUD_HREMPCERTLIC_ADMS_V DAR TRIGGER DBT_I_IUD_HREMPEDU_ADMS_V DAR TRIGGER DBT_I_IUD_HREMPMEMS_ADMS_V DAR TRIGGER DBT_I_IUD_HREMPSKILLS_ADMS_V DAR TRIGGER DBT_I_IUD_HRREQ_ADMS_V DAR TRIGGER DBT_I_IUD_PYCHKL_CREW_SETUP_V DAR TRIGGER DBT_I_IUD_PYCHKL_CREW_SET_D_V DAR TRIGGER DBT_I_IUD_PYCHKL_CREW_V DAR TRIGGER DBT_I_IUD_PYCHKL_FILL_ANS_V DAR TRIGGER DBT_I_IUD_PYCHKL_FILL_QUES_V DAR TRIGGER DBT_I_IUD_PYCHKL_FILL_V DAR TRIGGER DBT_I_IUD_PYCHKL_FOREMAN_V DAR TRIGGER DBT_I_IUD_PYCHKL_SIGN_OFF_V DAR TRIGGER DBT_I_IUD_PYCHKL_TEMPL_QUES_V DAR TRIGGER DBT_I_IUD_PYCHKL_TEMPL_SECT_V DAR TRIGGER DBT_I_IUD_PYCHKL_TEMPL_V DAR TRIGGER DBT_I_IUD_PYCHKL_TEMPL_VAL_V DAR TRIGGER DBT_I_IUD_PYCREWTIME_SESS_V DAR TRIGGER DBT_I_IUD_PYCREWTIME_SIGN_V DAR TRIGGER DBT_I_IUD_PYCTIME_ACTIVITY_V DAR TRIGGER DBT_I_IUD_PYCTIME_EMPLOYEE_V DAR TRIGGER DBT_I_IUD_PYCTIME_EMP_DET_V DAR TRIGGER DBT_I_IUD_PYCTIME_EQP_DET_V DAR TRIGGER DBT_I_IUD_PYCTIME_EQUIPMENT_V DAR TRIGGER DBT_I_IUD_PYCTIME_HEADER_V DAR TRIGGER DBT_I_IUD_PYCT_CREW_ACT_V DAR TRIGGER DBT_I_IUD_PYCT_CREW_EMP_DET_V DAR TRIGGER DBT_I_IUD_PYCT_CREW_EMP_V DAR TRIGGER DBT_I_IUD_PYCT_CREW_EQP_DET_V DAR TRIGGER DBT_I_IUD_PYCT_CREW_EQP_V DAR TRIGGER DBT_I_IUD_PYCT_CREW_SCHD_T_V DAR TRIGGER DBT_I_IUD_PYCT_CREW_SCHD_V DAR TRIGGER DBT_I_IUD_PYCT_CREW_V DAR TRIGGER DBT_I_IUD_PYCT_EMP_PER_DATE_V DAR TRIGGER DBT_I_IUD_PYCT_TIME_ENT_EMP_V DAR TRIGGER DBT_I_IUD_PYCT_TIME_ENT_EQP_V DAR TRIGGER DBT_I_IUD_PYEMPLEAVEREQ_V DAR TRIGGER DBT_I_IUD_PYEMPLEAVREQ_DET_V DAR TRIGGER DBT_I_IUD_PYEMP_CLOCK_INOUT_V DAR TRIGGER DBT_I_IUD_PYEMP_DELEGATION_V DAR TRIGGER DBT_I_IUD_PYEMP_DEL_ACTION_V DAR TRIGGER DBT_I_IUD_PYEMP_DEL_DELEGEE_V DAR TRIGGER DBT_I_IUD_PYEMP_INOUT_TIMES_V DAR TRIGGER DBT_I_IUD_PYEMP_NATION_ADMS_V DAR TRIGGER DBT_I_IUD_PYET_TIME_ENTRY_V DAR TRIGGER DBT_I_IUD_PYNOTES_V DAR TRIGGER DBT_I_IUD_PYPMNOTES_V DAR TRIGGER DBT_I_IUD_PYPMSUBNOTES_V DAR TRIGGER DBT_I_IUD_PYTRADES_VW_V DAR TRIGGER DBT_I_IUD_PY_ESS_USER_PREFS_V DAR TRIGGER DBT_I_IUD_PY_ESS_USR_PRF_DET_V DAR VIEW PYCREWTIME_SESSION_INFO_V DAR VIEW PYEMPLEAVEREQ_V DAR VIEW PYETIME_TIME_ENTRY_V DAR VIEW PYPMNOTES_V DAR VIEW PYTRADES_VW_V DAR VIEW PY_REPORTEE_LEAVE_BALANCE_V JSR VIEW JSR_APEFT_CHQ JSR VIEW JSR_SCCHGDOC_WTB OWF_MGR PACKAGE BODY OWKF_PM =================================================================== DB=test A_TEST01 02-JUL-24 03.56.27.728312 AM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-02t SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 2485086_6.sql completed. Output in 2485086_6.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.85086 was successfully installed, but with warnings. As specified with --no-deploy option, JSPs did not get deployed. Deploy JSPs manually Installation Log Review: ======================== ---------SUMMARY--------- Critical Errors: 0 Warning Errors: 0 Informative Errors: 4 ---------CRITICAL ERRORS--------- ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- 688 | * 689 | ERROR at line 1: 690 | ORA-00942: table or view does not exist 691 | 694 | * 695 | ERROR at line 1: 696 | ORA-00942: table or view does not exist 697 | 700 | * 701 | ERROR at line 1: 702 | ORA-00942: table or view does not exist 703 | 706 | * 707 | ERROR at line 1: 708 | ORA-00942: table or view does not exist 709 | =============================== End of Installation Log Review ===============================